This topic describes how to add multiple connections at a time.

  • Currently, you can only add multiple MySQL, Oracle, or SQL Server connections at a time.
  • You can only set the connection type to JDBC Connection Mode.
  • After adding MySQL, Oracle, or SQL Server connections, you must test connectivity. If the connectivity test is passed, you can select the connections when you configure sync nodes to migrate tables to the cloud.
  1. Log on to the DataWorks console as a workspace administrator. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Integration in the Actions column.
  2. On the Data Integration page, click Connection in the left-side navigation pane. The Data Source page appears.
  3. On the Data Source page, click Add Connections in the upper-right corner.
  4. In the Add Connections dialog box that appears, select a connection type, click Select File, and then upload the relevant file. In this topic, MySQL connections are added.
    Parameter or button Description
    Connect To The type of the connection. You can only set the value to JDBC Connection Mode.
    Upload Script Click Download Template. In the template, enter the name, description, JDBC URL, username, and password of each connection to add.
    Note The template contains information about a default connection mysql_001_di_test. You can delete the information and add your connections.
    Select File Click Select File and select the modified template.
    Create After the file is uploaded, click Create. The upload results, including the number of added connections, number of connections that fail to be added, and failure causes, appear in the text box at the bottom.
  5. After the file is uploaded, click Close.
  6. On the Data Source page, select the added connections and click Test Connection.
    Note You can use the connections to migrate multiple tables to the cloud only after the connectivity test is passed.