edit-icon download-icon

SqlServer data source config

Last Updated: Apr 24, 2018

The SqlServer Relational Database data source provides the ability to read data from and write data to SqlServer, and supports configuring synchronization tasks in both the wizard and script modes.

If you are using SqlServer in a VPC environment, note the following:

  • User‑created SQLServer data sources:

    • The connectivity test is not supported but you can configure synchronization tasks. When creating a data source, click OK.

    • You must use the custom scheduling resource group to run the synchronization task. Make sure the connectivity is maintained between the custom scheduling resource group and the user‑created database. For more information, see Configure VPC environment to achieve data synchronization.

  • For the SqlServer data source created by using RDS: The system automatically selects the network environment, based on the RDS instance information provided by you.

Procedure

  1. Enter 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.

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

    • Alibaba Cloud database (RDS)

      11

      • Type: The Alibaba Cloud database (RDS).

      • 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.

      • examples of rds ID: The RDS instance ID.

      • examples of rds buyers id: The RDS buyers account ID.

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

    • Public IP

      PublicIP

      • Type: The public IP.

      • 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: An identifier to connect to the specified remote database. The format is jdbc:sqlserver://ServerIP:Port;DatabaseName=Database.

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

    • No public IP

      NoPublicIP

      • Type: The no public IP.

      • 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.

      • Select resource group: It can be used to perform synchronization tasks, and in general, multiple machines can be bundled when a resource group is added. For more information, see Add scheduling resources.

      • JDBC URL: An identifier to connect to the specified remote database. The format is jdbc:sqlserver://ServerIP:Port;DatabaseName=Database.

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

  5. Click Test Connectivity.

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

Connectivity test description

  • In a classic network, the connectivity test is provided to verify whether the JDBC URL and Username/Password entered is 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 SqlServer data source. The article explains how to configure the SqlServer Writer plug‑in later. For more information, see Configure SqlServer Writer.

Thank you! We've received your feedback.