Share this article:

Vertica Integration with IBM Cognos Analytics: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one version of Vertica and one version of the third party vendor’s software. Other versions of the third-party product may work with Vertica. However, we may not have tested those other versions.

Vertica and Cognos Analytics: Versions Tested

Software Version
Partner Product

IBM Cognos 11 Release 13 Version 11.0.13.0

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica JDBC 9.2.1-0

Vertica Server

Vertica Database 9.2.1-0

Cognos Analytics Overview

IBM Cognos Analytics is a web-based solution for building applications that perform reporting and analysis. You can use Cognos Analytics on cloud or on-prem.

For details about IBM Cognos Analytics, see the IBM Cognos Analytics documentation.

Install Cognos Analytics

You can download and install a free trial of Cognos Analytics for cloud deployment. Follow these steps:

  1. Navigate to the Cognos Analytics Support portal.
  2. Check the prerequisites and follow the instructions on the download page.

Install the Vertica JDBC Driver

IBM Cognos Analytics server uses the Vertica JDBC driver to connect to Vertica. To install the JDBC driver:

  1. Navigate to the Vertica Client Drivers page.
  2. Download the JDBC driver that matches your operating platform and your version of Vertica.

    Note Vertica drivers are forward compatible. You can use an older driver version to connect to a newer server version. For more information about client and server compatibility, see the Vertica documentation.

  3. Place the JDBC .jar file in the Cognos driver directory:

    Cognos_Install_Directory\drivers

Note If you upgrade your Vertica client, you must repeat these steps to replace the .jar file.

Connect Cognos Analytics to Vertica

  1. Open the Cognos Analytics home page:

    http://Machine_IP:9300/bi/index.html?perspective=home

    The home page displays as shown:

  2. Click Manage.
  3. Click Data server connections.

  4. Click the plus (+) sign to add a data server:

  5. From the list of databases, select Vertica:

  6. Provide the database connection name and JDBC URL, then click Test.

    When the connection is successful, the Success button turns green:

  7. Click Save.
  8. Select Data module and click New.

  9. Click Data Servers and select VMart:

  10. Right click the database schemas that you want to include in your data module and click Load metadata:

    When the metadata is successfully loaded, the status button turns green.

  11. Click Done.

  12. Drag and drop the tables you want to include in your data module:

Known Limitations

  • Cognos does not support the following Vertica data types: Boolean, IntervalMonth, IntervalSeconds, TimeTz, TimestampTz, Binary, Varbinary, Longvarbinary, and UUID.

    Values of these data types in Vertica are not loaded into the Cognos reporting environment.

  • Millisecond part is truncated from Time and Timestamp datatype.

For More Information

Share this article: