Connecting IBM Cognos Analytics to Presto in watsonx.data
This topic provides you with the procedure to connect IBM Cognos Analytics to Presto. IBM Cognos Analytics provides AI-powered automation capabilities and allows you to generate insights from the connected data sources.
Before you begin
Pre-requisites for IBM Cognos Analytics
- IBM Cognos Analytics version 12.0.1 or above.
- Download the Presto JDBC driver from JDBC Drivers. Use a version of the JDBC driver, which is supported by IBM Cognos Analytics. Copy the driver to IBM Cognos Analytics installation_location\drivers directory, and restart the query service.
- Data source Connections administrator privilege to create data server connections.
Pre-requisites for IBM watsonx.data
- Subscription to watsonx.data on IBM Cloud.
- Provision watsonx.data instance with Presto engine.
Connecting to Presto
-
Log in to Cognos Analytics.
-
From the navigation menu, click New.
-
Click Data server. The Create data server connection page opens. In this page, do the following:
-
Provide the following details:
- Name: Provide a name for the connection.
- Connection type: Select
watsonx.data
.
-
Click Next.
-
Provide the following details:
- JDBC URL: Presto JDBC URL. For more information about retrieving the hostname and port, see Getting connection information. Example of the URL :
jdbc:presto://xxxxx-xxxx-xxx-xxx-xxxxx.xxxxx.xx.x.appdomain.cloud:xxxx?SSL=true
. - Driver class name (optional)
- Connection properties (optional)
- Authentication > Method: Select Use signon.
- Click Add signon. The User ID and password window opens.
- JDBC URL: Presto JDBC URL. For more information about retrieving the hostname and port, see Getting connection information. Example of the URL :
-
In the User ID and password window, provide the following details of the Presto engine:
-
Username : Username is
ibmlhapikey_<watsonx.datauser_id>
oribmlhapikey_ServiceId-<service_id>
. For example,ibmlhapikey_joe@ibm.com
oribmlhapikey_ServiceId-xxxxxxx-9-9e71-xxxx-yxay-cxaraa68
.To get the<service_id>
, see Creating a service ID by using the console. -
Password : The API key of the watsonx.data user. For more information about retrieving the API key, see Generating the API key.
-
-
Click Done.
-
Click Test connection to verify that the connection is successful.
-
You can click Next when your test connection is successful.
-
Specify the commands that the database executes when certain events occur (Optional). For more information, see Creating a data server connection.
-
Click Create. Click Load to configure the assets used by the connection. The catalogs from watsonx.data gets listed.
-
Select the assets that you want to use in IBM Cognos Analytics and click the Load link against the asset. It will load the tables present in the catalogs.
-
Click Done. The Data server connections page opens and the connection is listed.
-
-
Click the watsonx.data connection that you created.
-
Click the overflow menu against the connection name. Select Assets to list all the available schemas and tables from the watsonx.data instance.
-
The Assets page opens. Select the assets (tables and schemas) to import to Cognos Analytics.
-
Select the table (any additional) that you want to work with and click the overflow menu against it. Click Load metadata. The status displays
Loaded
when the table is completely loaded.You can start working with the data.
-
You can also verify whether the data in the table is completely loaded. To do that:
- Go to Navigation menu.
- Click New > Data module.
- Select Data Servers.
- Select the watsonx.data connection that you created.
- Click OK. View the Data module page with data from watsonx.data.