edit-icon download-icon

Step 2: Configure RDS data source

Last Updated: May 04, 2018

Prerequisites

Because of the RDS data security restrictions, you must add the IP address of the computer to run data synchronization tasks to the RDS whitelist before connecting DataWorks (formerly the Data IDE) data synchronization tasks with RDS databases. For more information, see IP Whitelist or go to the entry to view IP on the data source configuration page.

Procedure

  1. Log on to the DataWorks console as a developer and click Enter Workplace in the Actions column of the relevant project.

  2. Click Data Integration from the upper menu and navigate to the Data Source page.

  3. Click New Data Source.

  4. In the data source creation dialog box, select RDS > MySQL as the data source type.

  5. Select to configure the MySQL data source in the form of an RDS instance.

    80

  1. Click Test Connectivity.

  2. When the connectivity test is passed, click OK.

    Note:

    • In this example, the region of the RDS instance is South China 1 and the network type is VPC, and synchronizing data through DataWorks actually transfers data on the VPC across regions.

    • Data Integration of DataWorks makes sure network interconnectivity for the RDS by detecting devices automatically through the reverse proxy and also guarantees network connectivity for data synchronization without special processing.

What to do next

Now you have learned how to configure the RDS data source. The next tutorial describes how to create the synchronization task to export data from the RDS to MaxCompute. For more information, see Configuring the data synchronization task.

Thank you! We've received your feedback.