DataV:Add RDS for MySQL data source

Add data source through intranet

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create Data Source.

3. Select RDS for MySQL from the Type dropdown.

4. Choose Intranet from the list and select the area where the RDS instance is located.

   

5. Select the network type for the intranet database, which includes Virtual Private Cloud and Classic Network options.

   Virtual private cloud

   1. Activate the VPC toggle to switch to Virtual Private Cloud mode.

   2. Enter the database information.

      Note

      To create a new database, refer to create database.

      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 RDS for MySQL instance is located. You can obtain it from the RDS Management Console in the database connection details of the instance.
      VPC Instance ID	The ID of the database instance under the VPC. You can obtain it from the basic information page of the instance in the RDS Management Console.
      Domain Name	The connection address of the database. The intranet environment address of Alibaba Cloud RDS for MySQL can be obtained from the instance details database in the RDS Management Console. Important This address is the domain name or IP address that the DataV server can access your database through the public network or Alibaba Cloud's internal network in some regions.
      Port	The port set by the database. The default is 3306.
      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.
      insecureAuth	If your MySQL version is lower, you need to turn on the switch to configure and use MySQL.

   3. Once the database information is entered, the system will automatically test the connection to confirm normal database access.

      Important

      If the error message Access VPC instance fail appears during the connection test, try adding the suffix -1 to the Instance ID and test the connection again.

   Classic network

   1. Deactivate the VPC toggle to switch to Classic Network mode.

   2. Enter the database information.

      Note

      To create a new database, refer to create database.

      Parameter	Description
      Name	The name of the data source. You can specify a custom name.
      Domain Name	The connection address of the database. The intranet environment address of Alibaba Cloud RDS for MySQL can be obtained from the instance details database in the RDS Management Console. Important This address is the domain name or IP address that the DataV server can access your database through the public network or Alibaba Cloud's internal network in some regions.
      Port	The port set by the database. The default is 3306.
      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.
      insecureAuth	If your MySQL version is lower, you need to turn on the switch to configure and use MySQL.

   3. Once the database information is entered, the system will automatically test the connection to confirm normal database access.

      Important

      If the error message Access VPC instance fail appears during the connection test, try adding the suffix -1 to the Instance ID and test the connection again.

6. Once the connection test is successful, click OK to finalize the data source addition. The new data source will then appear in the data source list.

Add data source through the internet

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the left-side navigation pane to access the Data Source page, and then click Create Data Source.

3. Select RDS for MySQL from the Type dropdown.

4. Select Internet from the list.

   For internet address settings, see set connection address.

5. Enter the database information.

   Parameter	Description
   Name	The name of the data source. You can specify a custom name.
   Domain Name	The connection address of the database. The internet environment address of Alibaba Cloud RDS for MySQL can be obtained from the database connection page of the instance details in the RDS Management Console. Important This address is the domain name or IP address that the DataV server can access your database through the public network or Alibaba Cloud's internal network in some regions.
   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.
   insecureAuth	If your MySQL version is lower, you need to turn on the switch to configure and use MySQL.

   After entering the database information, the system will automatically test the connection to ensure it is functioning properly.

   Important

   If the error message Access VPC instance fail appears during the connection test, try adding the suffix -1 to the Instance ID and test the connection again.

6. After a successful connection test, click OK to add the data source.

   The newly added data source will appear in the data source list.

What to do next

Once you have the raw data, you can refer to widget data source configuration for widget data adaptation.

FAQ

For more information, see Data Source FAQ.