All Products
Search
Document Center

Hologres:IBM Cognos Analytics

Last Updated:Jun 07, 2023

IBM Cognos Analytics can access and process data with ease and implement data visualization. This helps your decision making. This topic describes how to connect IBM Cognos Analytics to Hologres and analyze data in a visualized manner.

Procedure

  1. Install IBM Cognos Analytics.

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

  2. Connect IBM Cognos Analytics to Hologres.

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

    2. Click the plus sign (+) in the upper-right corner and select PostgreSQL in the Select a type section.Create a data source

    3. After you select PostgreSQL in the Select a type section, configure the JDBC URL and Authentication method parameters on the page that appears.Configure parameters

      Parameter

      Description

      JDBC URL

      The Java Database Connectivity (JDBC) URL that is used to connect to Hologres. Specify the value in the format of jdbc:postgresql://<host>:<port>/<databasename>. The JDBC URL contains the following variables:

      • host: the public endpoint of the Hologres instance. You can view the public endpoint of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console.

      • port: the port number of the Hologres instance. You can view the port number of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console.

      • database: the name of the Hologres database.

      Driver class name

      Use the default value for this parameter.

      Authentication method

      Select Use the following signon for the Authentication method parameter.

    4. Click the plus sign (+) under the Authentication method parameter to add authentication information. On the Credentials tab, enter your user ID and password and enter the password again to confirm the password.Username and password

      Parameter

      Description

      User ID

      The AccessKey ID of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey ID, see Create an Alibaba Cloud account.

      Password

      The AccessKey secret of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey secret, see Create an Alibaba Cloud account.

    5. After the configuration is complete, click Test in the lower-left part of the Settings tab. If the Success message appears, the test is successful. After you enter the name of the connection in the upper part of the page, click Save.Test

    6. After the connection configurations are saved, click the Schemas tab and select the schema for which you want to load the metadata. Click the More icon on the rightmost side of the schema and select Load metadata or Load options. schemaIf you select Load metadata, the system loads the metadata of all the tables that reside in this schema. If you select Load options, you can specify the data to be loaded. In this example, Load metadata is selected.

    7. After the required metadata in the schema is loaded, the system provides a prompt, as shown in the following figure. Then, you can use IBM Cognos Analytics to connect to Hologres and analyze data in a visualized manner.loaded

  3. Create a data module.

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

    1. Log on to IBM Cognos Analytics, click the plus sign (+) in the lower-left corner, and then select Data module.data module

    2. On the Select sources page, click the data servers icon on the left side. The Data servers tab appears. Click the connection that you have created.Select a dataset

    3. On the details page of the connection, the system displays the schemas in which the metadata has been loaded. You can select the schema from which you want to obtain data and click OK in the lower part of the page.Add a schema

    4. On the Add tables page, select Select tables and click Next in the lower part of the page.

    5. On the Select tables page, select the name of the table from which you want to obtain data and click OK.select tables

    6. On the New data module page, click the Relationships tab and create a relationship between tables.relation

    7. After you create the relationship between tables on the Create relationship page, click Save to save this module.Table relationship

  4. After the data module is created, you can use this module for visualized data analytics. For more information about IBM Cognos Analytics, see IBM Cognos Analytics official documentation.Analytics