SAP BusinessObjects (SAP BO) is a SAP business intelligence (BI) platform that provides reporting, dashboards, ad hoc analysis, and data management capabilities. This topic describes how to connect SAP BusinessObjects to Hologres so that you can run visual analytics on your Hologres data.
Prerequisites
Before you begin, make sure that you have:
-
A running Hologres instance with a database created
-
The public endpoint and port of your Hologres instance (available in the Network Information section of the Hologres Management Console)
-
An Alibaba Cloud AccessKey ID and AccessKey secret (Create an AccessKey pair)
-
The PostgreSQL ODBC driver (version Psqlodbc_11_01_0000 or later) installed on both the SAP BusinessObjects server and client — download from the PostgreSQL official website
Hologres is compatible with the PostgreSQL 11 ecosystem. Use the PostgreSQL ODBC driver to connect.
Connect SAP BusinessObjects to Hologres
Step 1: Create a relational connection
-
Open SAP Information Design Tool and select File > New Universe.
-
Select an existing project, then click Next. If no project exists, select Create a project first.
-
Select Relational data source, then click Next.
-
Enter a Resource Name, then click Next.
-
In the list, select PostgreSQL > PostgreSQL 11 > ODBC Drivers, then click Next.
-
Enter your User Name and Password, select Use connection string, and click the
icon next to Driver. Select the target driver from the drop-down list, then configure the remaining parameters.Parameter
Required
Description
User Name
Yes
Your Alibaba Cloud AccessKey ID. Find it in the Alibaba Cloud console under AccessKey Management.
Password
Yes
Your Alibaba Cloud AccessKey secret. Find it alongside your AccessKey ID in AccessKey Management.
Host
Yes
The public endpoint of your Hologres instance. In the Hologres Management Console, open your instance and copy the endpoint from the Network Information section.
Port
Yes
The port number of your Hologres instance. Find it in the Network Information section of the same instance page.
Database
Yes
The name of the Hologres database to connect to.
-
Click Test Connection. If the result shows "Test Successful", click Next to configure the connection and parameters. If you have no special configuration requirements, click Next directly.
Step 2: Create a data foundation
-
On the New Data Foundation page, enter a Resource Name, then click Next.
-
Select the tables to include, then click Next.
Step 3: Create a relational business layer
On the New Relational Business Layer page, enter a Resource Name, then click Finish.
The connection between SAP BusinessObjects and Hologres is now ready. You can design models and run visual analytics on your Hologres data.