This topic outlines how to add a PolarDB for Oracle data source in DataV, including instructions for parameter configuration. PolarDB is a next-generation, cloud-native relational database by Alibaba, fully compatible with Oracle syntax.
Prerequisites
The PolarDB for Oracle data source is prepared and ready to be added.
You must first add the whitelist IP address of the corresponding area to your data source whitelist to ensure that DataV-Board can access your database normally. For more information, see configure database whitelist.
Limits
Supports only Enterprise Edition or higher.
Add a data source through the intranet
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
Select PolarDB for Oracle from the Type dropdown list.
Choose Intranet from the list and select the region corresponding to your PolarDB instance.
Enter the database information.
Parameter
Description
Name
The name of the data source. You can specify a custom name.
VPC ID
The ID of the VPC-connected instance. This VPC is where your PolarDB for Oracle instance is located. You can go to the PolarDB console and obtain it on the basic information page of the instance. You can configure the whitelist of the DataV VPC intranet address in the region where the instance is located to view the VPC ID and VPC Instance ID of the instance.
Instance ID
The ID of the database instance under the VPC. You can obtain it on the basic information page of the instance in the PolarDB console.
Domain Name
The intranet address for connecting to the database.
ImportantThis address is the domain name or IP address that the DataV server can access your database through the public network or the intranet of some Alibaba Cloud regions.
For example, when using Alibaba Cloud PolarDB for Oracle in an intranet environment, the domain name example is: xxxxxxxx.o.polardb.rds.aliyuncs.com. You can go to the PolarDB console, click to configure the whitelist of the DataV VPC intranet address in the region where the instance is located, and use it after the intranet address takes effect.
Port
The port set by the database.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
Upon entering the database details, the system will automatically test the connection to ensure normal database connectivity.
Once the connection test succeeds, click OK to finalize the addition of the data source.
The new data source will then appear automatically in the list of data sources.
Add a data source through the internet
Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to access the Data Source page, and then click Create Data Source.
Select PolarDB for Oracle from the Type dropdown list.
Choose Internet from the dropdown list.
Enter the relevant details for the PolarDB for Oracle data source.
Parameter
Description
Name
The name of the data source. You can specify a custom name.
Domain Name
The internet address for connecting to the database.
ImportantThis address is the domain name or IP address that the DataV server can access your database through the public network or the intranet of some Alibaba Cloud regions.
For example, when using Alibaba Cloud PolarDB for Oracle in an internet environment, the domain name example is: xxxxxxxx.o.polardb.rds.aliyuncs.com. You can go to the PolarDB console, click to request an internet address, and configure the whitelist of the DataV internet. You can use it after the internet address takes effect.
Port
The port set by the database.
Username
The username that is used to log on to the database.
Password
The password that is used to log on to the database.
Database
The name of the currently selected database.
Once you have entered the information, click OK to finalize the addition of the data source.
The new data source will then be automatically displayed in the list of data sources.
What to do next
Once you have the raw data, you can consult datasource config for widget data adaptation.
FAQ
For additional questions, consult the FAQ about datasource config.