This topic explains how to add a user-created SAP HANA data source. It is supported only by the Professional Edition and Pro.
Prerequisites
Ensure your network connectivity:
If connecting Quick BI to your SAP HANA database over the Internet, add the IP address of Quick BI to the database whitelist. For more information, see Add Security Group Rules.
If connecting Quick BI to your SAP HANA database over an internal network, ensure connectivity between the data source and Quick BI using one of the following methods:
If the SAP HANA database is deployed on an Alibaba Cloud ECS instance, establish a connection over an Alibaba Cloud VPC.
Alternatively, deploy a jump server and access the database via an SSH tunnel.
A user-created SAP HANA database is in place.
The username and password for accessing the user-created SAP HANA database are available.
Limits
Supports version 2.0.
Procedure
Log on to the Quick BI console.
Follow the steps depicted in the figure below to add a user-created data source.
Navigate to the data source creation page via the data source creation entry.
Click Show More.
Select the SAP HANA data source.
In the Add SAP HANA Data Source dialog box, fill out the required configurations.
Name
Description
Display Name
The display name in the datasource config list.
The name cannot contain special characters or start or end with spaces.
Database Address
The address where the SAP HANA database is deployed, including the IP address or domain name.
Port
The correct port number. Default value: 30015.
Database
The name of the database to be connected.
Schema
The schema of the database. Default value: public.
Username
The username that is used to connect to the database.
Password
The password that is used to connect to the database.
VPC Data Source
Specifies whether to access the user-created data source over a VPC based on your business requirements. If you select VPC Data Source, you need to configure the following parameters:
Purchaser Accessid: The AccessKey ID of the purchaser of this instance.
For more information, see Obtain an AccessKey.
NoteEnsure that the AccessKey ID has Read permission on the destination instance. If it also has Write permission, the system automatically adds the whitelist. Otherwise, you need to add it manually. For more information, see Create a Custom Policy.
Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance.
For more information, see Obtain an AccessKey.
Instance ID: The ID of the purchaser of this instance. Log on to the ECS console and obtain the instance ID on the Instances tab.
For more information, see View Instance Information.
Region: The region where the instance is located. Log on to the ECS console and obtain the region of the instance in the upper-left corner.
For more information, see View Instance Information.
SSH
Specifies whether to access the data source over an SSH tunnel based on your business requirements. If you select SSH, you need to configure the following parameters:
SSH Host: The hostname or IP address.
SSH Username: The SSH username that is used to connect to the database.
SSH Password: The password of the SSH username that is used to connect to the database.
SSH Port: The port of the database. Default value: 22.
Click Connection Test to verify the data source connectivity.
Once the test is successful, click OK to finalize the addition of the data source.
What to Do Next
After creating a data source, you can proceed to create datasets and analyze data.
To add data tables from the SAP HANA database or custom SQL to Quick BI, refer to Create and Manage Datasets.
To create visualization charts and analyze data, refer to Create a Dashboard and Overview of Visualization Charts.
For in-depth data analysis and drill-down capabilities, refer to Drill-Down Settings and Display.