edit-icon download-icon

DRDS data source config

Last Updated: Apr 03, 2018

The Distributed Relational Database Service (DRDS) data source provides the ability to read data from and write data to DRDS, and supports configuring the synchronization task in both the wizard and script modes.

Procedure

  1. Enter the DataWorks console as a developer, and click Enter Project, as shown in the following figure.

    Enter

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

    DataSources

  3. Click New Source.

  4. In the dialog box, select DRDS as the data source type.

  5. Complete the configuration items for the data source.

    14

    • Name: A combination of letters, numbers, and underscores (). It must begin with a letter or an underscore (), and the length must not exceed 60 characters.

    • Description: A brief description of the data source, which must not exceed 80 characters.

    • JDBC URL: The JDBC URL. Format: jdbc://mysql://serverIP:Port/database.

    • Username/Password: The username and password of the database.

  6. Click Test Connectivity.

  7. When the connectivity test is passed, click Complete.

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the JDBC URL and Username/Password entered are correct.

  • Currently, test of the connectivity to data sources is unavailable in VPC environments.

What to do next

Now you have learned how to configure the DRDS data source. The article explains how to configure the DRDS Writer plug‑in later. For more information, see Configure DRDS Writer.

Thank you! We've received your feedback.