Connect to Hologres from SAP BusinessObjects

Procedure

1. Install the PostgreSQL ODBC driver

   You can download the PostgreSQL ODBC driver from the official PostgreSQL website.

   Note

   Hologres is compatible with the PostgreSQL 11 ecosystem. You must install the psqlodbc_11_01_0000 or a later version of the ODBC driver on both the SAP BusinessObjects server and client.

2. Create a relational connection

   1. Open the SAP Information Design Tool and select File > New Universe.

   2. Select an existing project and click Next. If no projects exist, click Create a project to create one.

   3. Select relational data source and click Next.

   4. Enter a resource name and click Next. For example, enter Hologres as the resource name.

   5. From the list, select PostgreSQL > PostgreSQL 11 > ODBC Drivers, and then click Next.

   6. Enter your user name and password. Select Use connection string. Click the icon next to Driver, select the target driver from the drop-down list, and configure the remaining parameters. The following table describes the parameters.

      Parameter	Description
      user name	The AccessKey ID of your Alibaba Cloud account. For more information about how to obtain an access key, see Create an access key.
      password	The AccessKey Secret of your Alibaba Cloud account. For more information about how to obtain an access key, see Create an access key.
      host	The public endpoint of the Hologres instance. Find the endpoint in the Network Information section on the Instance Details page of the Hologres console.
      port	The port number of the Hologres instance. Find the port number in the Network Information section on the Instance Details page of the Hologres console.
      database	The name of the Hologres database.

   7. Click Test Connection. If the message Test Successful appears, the connection is successful. Click Next to configure connection and parameter settings. If you have no special configuration requirements, you can click Next.

3. Create a data foundation

   1. On the New Data Foundation page, enter a resource name and click Next.

   2. Select the tables you want to add and click Next. Expand the Hologres data source, select the public schema, and select the target tables, such as customer, for_test, lineitem, and nation. At the bottom of the page, confirm that the Detect joins, Detect keys, Detect cardinalities, and Detect row counts checkboxes are selected.

4. Create a relational business layer

   On the New Relational Business Layer page, enter a resource name and click Finish. When the process is complete, the connection between SAP BusinessObjects and Hologres is established. You can now perform model design and visual analysis.