Add an Oracle data source - DataV

This document outlines the steps to add an Oracle data source in DataV, including detailed explanations of the related parameter configurations.

Prerequisites

You must have an Oracle data source ready to be added.

Important

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.

Procedure

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.
From the Type list, select Oracle.

Enter the database information.

Parameter	Description
Name	The display name of the data source. You can specify a custom name.
Domain Name	The address used to connect to the database. Important This address must be a domain name or IP address that the DataV server can access through the public network or the Alibaba Cloud intranet in certain regions.
Port	The port set for 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.
Service Name	The service name of the currently selected database.

Once the database information is entered, the system will automatically test the connection to ensure it can be established successfully.

Upon successful connection, click OK to finalize the data source addition.

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.