This topic explains how to add a user-created Oracle data source.
Prerequisites
Verify your network connectivity:
For Internet connections to the Oracle database, add the IP address of Quick BI to the database whitelist. For more information, see add a security group rule.
For internal network connections to the Oracle database, ensure connectivity between the data source and Quick BI using one of the following methods:
If the Oracle database is hosted on an Alibaba Cloud ECS instance, establish a connection through Alibaba Cloud VPC.
Alternatively, set up a jump server and establish an SSH tunnel to access the database.
A user-created Oracle database has been established.
You have obtained the username and password for accessing the user-created Oracle database.
Limits
Supports version 11.0.
Procedure
Log on to the or the international Quick BI console.
To add a data source, follow the instructions shown in the figure below.
Navigate to the data source creation interface via the data source creation entry.
On the User-created Data Source tab, select Oracle data source.
In the Configure Connection dialog box, complete the following 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 Oracle database is deployed, including the IP or domain name.
Port
Enter the correct port number. Default value: 1521.
Database
The name of the database that you want to access.
Schema
The schema of the database that you want to access.
Username
The username that is used to connect to the database.
Password
The password that is used to connect to the database.
Character Encoding
Quick BI supports the following encoding formats. You can configure this parameter based on your business requirements:
GBK (default)
UTF-8
GB2312
ISO-8859-1
VPC Data Source
Specifies whether to access the 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 will automatically add 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 ECS instance ID. Log on to the ECS console and obtain the instance ID on the Instances tab.
For more information, see view instance information.
Area: The region where the ECS instance is located. Log on to the ECS console and obtain the region in the upper-left corner of the page.
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 username that is used to connect to the database.
SSH Port: The port that is used to connect to the database. Default value: 22.
Enable File Upload Entry
After enabling, file upload is supported.
Initialize SQL
After enabling, you can configure the SQL statement that is executed to initialize the data source connection.
Only SET statements are allowed in the SQL statement that is executed to initialize the data source connection. Separate statements with a semicolon.
Click Connection Test to verify the data source connectivity.
Once the test is successful, click OK to finalize the data source addition.
What to Do next
After the data source is established, you can proceed to create datasets and analyze data.
To import data tables from the Oracle database or add custom SQL to Quick BI, refer to create and manage datasets.
For adding visualization charts and data analysis, see create a dashboard and visualization chart overview.
To conduct in-depth data analysis, consult drilling settings and display.