Hologres:IBM Cognos Analytics

Prerequisites

Before you begin, ensure that you have:

• IBM Cognos Analytics installed. See the IBM Cognos Analytics documentation for installation instructions.

• A Hologres instance with at least one database created

• The public endpoint and port of your Hologres instance (available in the Hologres console under Network Information)

• An Alibaba Cloud AccessKey ID and AccessKey secret. See Create an AccessKey.

Connect to Hologres

1. Log on to IBM Cognos Analytics, click the (Manage) icon in the lower-left corner, and create a connection.

2. Click the + icon to create a data source connection. Set the data source type to PostgreSQL.

   

3. Configure the connection parameters.

   Parameter	Description
   JDBC URL	The Java Database Connectivity (JDBC) URL for your Hologres instance. Use the format jdbc:postgresql://<host>:<port>/<databasename>, where host is the public endpoint, port is the instance port, and databasename is the name of your Hologres database. Find the endpoint and port on the instance details page in the Hologres console under Network Information.
   Driver class name	Keep the default value.
   Authentication method	Select Use the following signon.

   

4. Click the + icon under Authentication method to add credentials.

   Parameter	Description
   User ID	Your Alibaba Cloud AccessKey ID.
   Password	Your Alibaba Cloud AccessKey secret.

   

5. Click Test in the lower-left corner. If a Success message appears, the connection is valid. Enter a name for the connection at the top of the page and click Save.

   

6. Click the Schemas tab and select the schema to load. Click the More icon next to the schema name and select Load metadata or Load options.

   • Load metadata loads the metadata for all tables in the schema.

   • Load options lets you configure which data to load in more detail.

   

7. After the schema loads successfully, a confirmation message appears. You are now ready to create data modules and run visual analytics.

   

Create a data module

After setting up the connection, create a data module to start analyzing your data.

1. Click the + icon in the lower-left corner and select Data module.

   

2. On the Select sources page, click the icon on the left to go to the Data servers tab. Click the connection you created.

   

3. Select the target schema and click OK.

   

4. On the Add tables page, select Select tables and click Next.

5. Select the checkbox for the target table and click OK.

   

6. On the modeling page, click Relationships to define table relationships.

   

7. Complete the relationship settings and click Save.

   

What's next

With the data module created, use it to build dashboards and run visual analytics in IBM Cognos Analytics.

For more information on building reports and dashboards, see the IBM Cognos Analytics documentation.