This topic describes how to add a user-created SAP HANA data source. This feature is available only in Quick BI Professional Edition and Advanced Edition.
Prerequisites
Ensure that you have proper network connectivity:
If you use a public network connection to connect Quick BI to your SAP HANA database, you must add the IP addresses of Quick BI to the database whitelist. For more information, see Use a security group.
If you use an internal network connection to connect Quick BI to your SAP HANA database, establish network connectivity by using one of the following methods:
If your SAP HANA database is deployed on an Alibaba Cloud ECS instance, you can use a VPC connection.
You can set up a bastion host and use an SSH tunnel to access the database.
An SAP HANA database.
The username and password for your SAP HANA database.
Limitations
SAP HANA 2.0 is supported.
Procedure
Log on to the Quick BI console.
Follow these steps to add a data source:
Navigate to the page for adding a data source. For more information, see Create a data source.
On the User-Created Data Sources tab, click SAP HANA.
In the Add SAP HANA Data Source dialog box, configure the following parameters.
Parameter
Description
Display name
The display name of the data source in the data source list.
The name must not contain special characters or leading or trailing spaces.
Database address
The address of the SAP HANA database. This can be an IP address or a domain name.
Port
The port number of the database.
Database
The name of the database to connect to.
Schema
The name of the schema to connect to. The default value is public.
Username
The username of the database account.
Password
The password for the username.
VPC data source
Select this option if your database is a user-created data source in a VPC. If you select VPC data source, configure the following parameters:
AccessKey ID: The AccessKey ID of the account that owns the instance.
For more information, see Create an AccessKey.
NoteEnsure that the AccessKey ID has read permissions on the target instance. If it also has write permissions, the system automatically adds the required IP addresses to the whitelist. Otherwise, you must add them manually. For more information, see Create a custom RAM policy.
AccessKey Secret: The AccessKey Secret of the account that owns the instance.
For more information, see Create an AccessKey.
Instance ID: The ID of the instance. You can obtain the instance ID from the Instances page in the ECS console.
For more information, see View instance information.
Region: The region where the instance is located. You can find the region in the upper-left corner of the ECS console.
For more information, see View instance information.
SSH
Select this option to connect to the data source over an SSH tunnel. If you select SSH, configure the following parameters:
SSH host: The hostname or IP address of the bastion host.
SSH username: The username for the SSH connection.
SSH password: The password for the SSH username.
SSH port: The port for the SSH connection. The default value is 22.
Click Test Connection.
If the test succeeds, click OK to add the data source.
Next steps
After you add the data source, you can create a dataset and analyze your data.
To add data tables or custom SQL queries from your SAP HANA database to Quick BI, see Create a dataset.
To add charts and analyze data, see Create a dashboard and Overview of charts.
To drill down and perform in-depth analysis, see Step 3: Configure and display drill-down data.