All Products
Search

This Product

    Hologres:SAP BusinessObjects

    Document Center

    Hologres:SAP BusinessObjects

    Last Updated:Jun 07, 2023

    SAP BusinessObjects (SAP BO) can provide the report, dashboard, ad hoc query, and data management features and is a well-known business intelligence (BI) tool developed by SAP. This topic describes how to connect SAP BO to Hologres and analyze data in a visualized manner.

    Procedure

    1. Install a PostgreSQL ODBC driver.

      You can download a PostgreSQL ODBC driver from File Browser.

      Note

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

    2. Create a relational connection.

      1. Log on to Information Design Tool and choose File > New Universenew universe.

      2. Click Select an existing project, select a project for which you want to create a connection from existing projects, and then click Next. If no project exists, click Create a project and create a project.project

      3. Select Relational data source and click Next.data source type

      4. Specify the Resource Name parameter and click Next.Resource Name

      5. Select Hierarchical List, choose PostgreSQL > PostgreSQL 11 > ODBC Drivers, and then click Next.odbc

      6. Specify the User Name and Password parameters. Select Use connection string, click the Refresh icon next to the Driver field, select the driver that is used to connect SAP BO to Hologres from the drop-down list, and then configure other parameters. The following table describes the parameters.Configure parameters

        Parameter

        Description

        User Name

        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.

        Host

        The public endpoint of the Hologres instance. You can view the 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 to which you want to connect. 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.

      7. Click Test Connection. If the message Test Successful appears, the database is connected. Click Next to configure the connection and the parameters. If no special configuration is required, click Next.

    3. Create a data foundation.

      1. On the New Data Foundation page, configure the Resource Name parameter and click Next.

      2. Select the tables from which you want to obtain data and click Next.Select tables

    4. Create a relational business layer.

      On the New Relational Business Layer page, configure the Resource Name parameter and click Finish. Then, Hologres is connected to SAP BO, and you can design a model to analyze data in a visualized manner.