This topic describes how to add a user-created SAP HANA data source.

Prerequisites

  • The database that you use as a data source is accessible from the Internet. If you want to deploy Quick BI on a private cloud, consult technical support personnel.
  • A user-created SAP HANA Server database is created.
  • The username and password that you use to access the user-created SAP HANA database are obtained.

Background information

Quick BI Enterprise Standard allows you to access user-created data sources in group workspaces over SSH tunnels. This access mode is not supported for other Quick BI editions.

Quick BI Enterprise Standard and Quick BI Pro allow you to add user-created SAP HANA data sources in group workspaces.

Procedure

  1. Click the Workspace tab. In the left-side navigation pane, click Data Sources.
  2. On the Data Sources page, click Create Data Source in the upper-right corner.
  3. In the Add Data Source dialog box, click the User-created Data Sources tab and then the SAP HANA card.
    Add Data Source
  4. In the Add SAP HANA Database dialog box, configure the required parameters.
    Configure the data source
    Parameter Description
    Name The name of the data source. In this example, set the value to user-created SAP_HANA data source.
    Database Address The IP Address of the database that is used as the data source.
    Port Number The port that you use to access the database.
    Database The name of the database.
    Schema The schema of the database. Default value: public.
    User Name The username that you use to access the database.
    Password The password that you use to access the database.
    ssh Optional.
    Note This parameter appears only in group workspaces of Quick BI Enterprise Standard.
    SSH Host The hostname or IP address of the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Username The username that you use to access the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Password The password that you use to access the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Port Number The port that you use to access the SSH host. Default value: 22.
    Note This parameter appears only when you select the ssh option.
  5. Click Test Connection to test connectivity with the database.
    Test the connectivity
  6. After the database passes the connectivity test, click Add.