This topic describes how to add an ApsaraDB RDS for MySQL data source in DataV.

Add an ApsaraDB RDS for MySQL data source over an internal network

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then Add Source.
  3. Select RDS for MySQL from the Type drop-down list.
  4. Select Intranet from the network type drop-down list, and select the region where the target ApsaraDB RDS for MySQL instance resides from the region drop-down list.
    Select Intranet
  5. Specify a network type for the internal network of the database, such as VPC or classic network.
    • VPC
      1. Turn on VPC to enter the VPC mode.Data source parameters in VPC mode
      2. Enter database information.
        Note If you need to create a database, see Create a database for an RDS MySQL instance.
        Parameter Description
        Name The name that you want to display for the data source.
        Domain Name The domain name or IP address that is used to connect to the database.
        Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for MySQL database over an internal network, an example of the domain name is rm-bpxxxxxxxxx33150.mysql.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        VPC ID The ID of the VPC to which your ApsaraDB RDS for MySQL instance belongs. You can log on to the ApsaraDB for RDS console and navigate to Instances > Basic Information to view the VPC ID of the target ApsaraDB RDS for SQL Server instance in the Network Type column.Obtain VPC ID
        Instance ID The ID of the database instance in the VPC. You can log on to the ApsaraDB for RDS console and view the ID of the target database instance on the Instances page.
        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        Database The database that you want to use as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
    • Classic network
      1. Turn off VPC to enter the classic network mode.
      2. Enter database information.Add an ApsaraDB RDS for MySQL data source over a classic network (internal network)
        Note If you need to create a database, see Create a database for an RDS MySQL instance.
        Parameter Description
        Name The name that you want to display for the data source.
        Domain Name The domain name or IP address that is used to connect to the database.
        Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

        If you need to access an ApsaraDB RDS for MySQL database over an internal network, an example of the domain name is rm-bpxxxxxxxxx33150.mysql.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

        Username The username that is used to connect to the database.
        Password The password that is used to connect to the database.
        Port The port that is used to connect to the database.
        Database The database that you want to use as the data source.
      3. After you enter the database information, DataV automatically tests whether the database can be connected.
  6. After the database passes the connectivity test, click OK.

    The added data source is displayed in the data source list.

Add an ApsaraDB RDS for MySQL data source over the Internet

  1. Log on to the DataV console.
  2. Click the Data Sources tab and then Add Source.
  3. Select RDS for MySQL from the Type drop-down list.
  4. Select Internet from the network type drop-down list.
  5. Enter database information.
    Add an ApsaraDB RDS for MySQL data source (Internet)
    Parameter Description
    Name The name that you want to display for the data source.
    Domain Name The domain name or IP address that is used to connect to the database.
    Notice The DataV server can use the domain name or IP address to access your database over the Internet or an internal network in some regions of Alibaba Cloud.

    If you need to access an ApsaraDB RDS for MySQL database over the Internet, an example of the domain name is rm-bpxxxxxxxxxco.mysql.rds.aliyuncs.com. You can log on to the ApsaraDB for RDS console and view the required information on the Instances page.

    Username The username that is used to connect to the database.
    Password The password that is used to connect to the database.
    Port The port that is used to connect to the database.
    Database The database that you want to use as the data source.

    After you enter the database information, DataV automatically tests whether the database can be connected.

  6. After the database passes the connectivity test, click OK.

    The added data source is displayed in the data source list.