Add multiple connections at a time

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

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.