This topic describes how to add a user-created SAP IQ (Sybase IQ) data source. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add user-created SAP IQ (Sybase IQ) data sources in group workspaces.

Prerequisites

  • You can access data sources directly or indirectly from an external network.
  • A self-managed SAP IQ (Sybase IQ) database is created.
  • The username and password that you use to access the user-created SAP IQ (Sybase IQ) database are obtained.

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 IQ (Sybase IQ) card.
    添加数据源
  4. In the Add SAP IQ (Sybase IQ) Database dialog box, configure the parameters.
    2
    Parameter Description
    Name The name of the data source. In this example, set the value to user-created data source SAP_IQ.
    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. Default value: 2638.
    Database The name of the database that you want to access. In this example, set the value to SAP_IQ.
    Schema The schema of the database. Default value: sybase.
    Username The username that you use to access the database.
    Password The password that you use to access the database.
    ssh Specify whether to access a data source over an SSH tunnel based on your business requirements. If you select ssh, configure the following parameters:
    • SSH Host: the hostname or IP address of the SSH host.
    • SSH Username: the username that you use to access the SSH host.
    • SSH password: the password that you use to access the SSH host.
    • SSH Port Number: the port that you use to access the SSH host. Default value: 22.
    Note Only Quick BI Enterprise Standard allows you to access user-created data sources in group workspaces over SSH tunnels.
  5. Click Test Connection to test connectivity with the database.
    测试连通性
  6. After the database passes the connectivity test, click OK.