DataV:Add an RDS for MySQL data source

Add a data source over a private network

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.

3. From the Type list, select RDS for MySQL.

4. Select Private Network and then select the region where the RDS instance is located.

   

5. Select the network type for the private network database. The available network types are virtual private cloud and classic network.

   Virtual private cloud

   1. Turn on the VPC switch to enable Virtual Private Cloud mode.

   2. Enter the database information.

      Note

      To create a new database, see Create a database.

      Parameter	Description
      Name	The display name for the data source. You can enter any name.
      VPC ID	The ID of the VPC where your RDS for MySQL instance resides. Go to the RDS console and find the ID in the Database Connection section of the instance details page.
      VPC Instance ID	The ID of the database instance in the VPC. Go to the RDS console and find the ID on the Basic Information page for the instance.
      Domain Name	The endpoint for the database connection. For an Alibaba Cloud RDS for MySQL instance in a private network environment, get the endpoint from the instance details page in the RDS console. Important This endpoint is a domain name or IP address that the DataV server can use to access your database over the public network or a private network in some Alibaba Cloud regions.
      Port	The port number for the database. The default is 3306.
      Username	The username to log on to the database.
      Password	The password to log on to the database.
      Database	The name of the database.

   3. After you enter the database information, the system automatically tests the connection.

   Classic network

   1. To switch to the classic network, turn off the VPC switch.

   2. Enter the database information.

      Note

      To create a new database, see Create a database.

      Parameter	Description
      Name	The display name for the data source. You can enter any name.
      Domain Name	The endpoint for the database connection. For an Alibaba Cloud RDS for MySQL instance in a private network environment, get the endpoint from the instance details page in the RDS console. Important This endpoint is a domain name or IP address that the DataV server can use to access your database over the public network or a private network in some Alibaba Cloud regions.
      Port	The port number for the database. The default is 3306.
      Username	The username to log on to the database.
      Password	The password to log on to the database.
      Database	The name of the database.

   3. After you enter the database information, the system automatically tests the connection.

6. After the connection test is successful, click OK to add the data source. The new data source is automatically added to the data source list.

Add a data source over the public network

1. Access the DataV console.

2. On the Workbench page, click Data Preparation > Data Source in the navigation pane on the left. On the Data Source page, click New Data Source.

3. From the Type list, select RDS for MySQL.

4. Select Public Network.

   For information about how to set a public endpoint, see Set a connection address.

5. Enter the database information.

   Parameter	Description
   Name	The display name for the data source. You can enter any name.
   Domain Name	The endpoint for the database connection. For an Alibaba Cloud RDS for MySQL instance in a public network environment, get the public endpoint from the Database Connection page of the instance details in the RDS console. Important This endpoint is a domain name or IP address that the DataV server can use to access your database over the public network or a private network in some Alibaba Cloud regions.
   Port	The port number for the database.
   Username	The username to log on to the database.
   Password	The password to log on to the database.
   Database	The name of the database.

   After you enter the database information, the system automatically tests the connection.

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

   The new data source is automatically added to the data source list.

What to do next

To use the data source in your widgets, see Configure a widget data source.

FAQ

For more information, see FAQ about data source configuration and usage.