Hologres:IBM Cognos Analytics

Procedure

1. Install IBM Cognos Analytics.

   Install IBM Cognos Analytics. For more information, see the official IBM Cognos Analytics documentation.

2. Connect to Hologres.

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

   2. At the top of the page, click the + icon to create a data source connection. Set the data source type to PostgreSQL.

   3. After you select PostgreSQL as the data source type, configure the JDBC URL and Authentication method parameters.

      Parameter	Description
      JDBC URL	The Java Database Connectivity (JDBC) URL. The format is jdbc:postgresql://<host>:<port>/<databasename>. The parameters are described as follows: host: The public endpoint of the Hologres instance. Go to the instance details page in the Hologres console and get the endpoint from the Network Information section. port: The port of the Hologres instance. Go to the instance details page in the Hologres console and get the instance port from the Network Information section. databasename: The name of the database that you created in Hologres.
      Driver class name	Keep the default value.
      Authentication method	Set Authentication method to Use the following signon.

   4. Click the + icon under Authentication method to add authentication information. Enter the User ID and Password.

      Parameter	Description
      User ID	The AccessKey ID of your Alibaba Cloud account. To obtain an AccessKey ID, see Create an AccessKey.
      Password	The AccessKey secret of your Alibaba Cloud account. To obtain an AccessKey secret, see Create an AccessKey.

   5. After you complete the configuration, click Test in the lower-left corner. If a Success message appears at the bottom of the page, the test is successful. Enter a name for the connection at the top of the page and click Save.

   6. After you save the connection configuration, click the Schemas tab and select the schema to load. Click the More icon to the right of the schema name. In the dialog box that appears, select Load metadata or Load options. Load metadata loads the metadata of all tables in the schema. Load options lets you configure data details. This topic uses Load metadata as an example.

   7. After the schema information loads, a message appears as shown in the following figure. This indicates that you have successfully connected to Hologres and can start performing data visualization.

3. Create a data module.

   After you create the data connection, create a data module for data analytics.

   1. Log on to IBM Cognos Analytics, click the + icon in the lower-left corner, and select Data module from the list.

   2. On the Select sources page, click the icon on the left. Go to the Data servers tab and click the data connection that you created.

   3. On the details page of the data connection, the schemas with loaded metadata are displayed. Select the target schema and click OK at the bottom of the page.

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

   5. On the Select tables page, select the checkbox for the target table and click OK.

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

   7. On the Create relationship page, complete the relationship settings and click Save to save the model.

4. After you create the model, use it for visual analytics. For more information about how to use IBM Cognos Analytics, see the official IBM Cognos Analytics documentation.