This topic describes how to add a user-created SAP IQ (Sybase IQ) data source. This feature is available only for workspaces in Quick BI Professional and Quick BI Advanced.
Prerequisites
Verify your network connectivity:
If you connect to the SAP IQ database from Quick BI over the public network, you must add the IP addresses of Quick BI to the IP address whitelist of the database. For more information, see Use security groups.
If you connect to the SAP IQ database from Quick BI over an internal network, connect the data source to Quick BI by using one of the following methods:
If your SAP IQ database is hosted on an Alibaba Cloud ECS instance, you can connect through a VPC.
You can also set up a bastion host and connect to the database through an SSH tunnel.
You must have a user-created SAP IQ database.
You must have the username and password for your user-created SAP IQ database.
Limitations
Quick BI supports SAP IQ version 16.1.030.1031/10645.
Procedure
Log on to the Quick BI console.
Follow these steps to add the data source:
Navigate to the page for creating data sources. For more information, see Create a data source.
On the User-created Data Source tab, click SAP IQ (Sybase IQ).
In the Add SAP IQ (Sybase IQ) Data Source dialog box, configure the parameters.
Parameter
Description
Display name
The name that appears in the data source list.
Enter a name that does not contain special characters or leading or trailing spaces.
Database address
The IP address or domain name of the database server.
Port
The port number for the database connection. The default port is 2638.
Database
The name of the target database. In this example, the value is SAP_IQ.
Schema
The name of the target schema. The default value is sybase.
Username
The username for connecting to the database.
Password
The password for the specified username.
VPC data source
Select this option if your data source is a VPC data source. If you select VPC data source, you must configure the following parameters:
Purchaser's AccessKey ID: The AccessKey ID of the account that purchased the instance.
For more information, see Obtain an AccessKey pair.
NoteEnsure that the AccessKey ID has read permissions on the destination instance. If the AccessKey ID also has write permissions on the relevant security group, the IP address whitelist is automatically updated. Otherwise, you must update it manually. For more information, see Create a custom permission policy.
Purchaser's AccessKey Secret: The AccessKey Secret of the account that purchased the instance.
For more information, see Obtain an AccessKey pair.
Instance ID: The ID of the ECS instance. Log on to the ECS console to view the instance ID.
For more information, see View instance information.
Region: The region where the instance is located.
For more information, see View instance information.
SSH
Select this option if you want to connect to your data source by using an SSH tunnel. If you select SSH, you must configure the following parameters:
SSH host: The hostname or IP address of the bastion host.
SSH username: The SSH username for connecting to the database.
SSH password: The password for the SSH username.
SSH port: The port number for the SSH connection. The default port is 22.
NoteConnecting to a user-created data source through an SSH tunnel is supported only in Quick BI Professional workspaces.
Click Test Connection to test the connection.
After a successful test, click OK to add the data source.
Next steps
After you add the data source, you can create datasets and analyze your data.
To add data tables from the SAP IQ database or use custom SQL to create a dataset in Quick BI, see Create a dataset.
To add visual charts and analyze data, see Create a dashboard and Overview of visual charts.
To drill down and analyze your data in depth, see Step 3: Set up and view drill-down data.