edit-icon download-icon

Configure DM data source

Last Updated: Apr 24, 2018

The DM relational database data source provides the ability to read data from and write data to DM databases, and supports configuring synchronization tasks in both the wizard and script modes.

Procedure

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

    EnterProject

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

    DataSources

  3. Click New Source, and select DM from the data sources list.

  4. Configure the information items of the DM data source.

    Select either of the following data source types as needed when you create a DM data source.

    • Public IP

      PublicIP

      • Type: With a public IP address.

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

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

      • JDBC URL: JDBC connection information in the format of jdbc:mysql://ServerIP:Port/Database.

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

    • No public IP

      NoPublicIP

      • Type: Data source without a public IP address. The data source of this type must use custom scheduling resources so that it can synchronize data.

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

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

      • Selected resources Group: It is used to run synchronization tasks, and generally multiple machines can be bound when you add a resource group. For more information, Add scheduling resources.

      • JDBC URL: JDBC connection information in the format of jdbc:dm://ServerIP:Port/Database.

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

  5. Click Test Connectivity.

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

Connectivity test description

  • The connectivity test is available in the classic network environment, to identify whether the input JDBC URL, username, and password are correct.

  • Currently, connectivity test does not support the VPC and public IP data source types. Thus, click Complete directly.

Thank you! We've received your feedback.