Create multiple connections at a time

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

1. Go to the Data Source page.
   1. Log on to the DataWorks console.
   2. In the left-side navigation pane, click Workspaces.
   3. In the top navigation bar, select the region where your workspace resides. Find your workspace and click Data Integration in the Actions column.
   4. On the page that appears, click Connection in the left-side navigation pane. The Data Source page appears.
2. On the Data Source page, click Batch add data source in the upper-right corner.
3. In the Batch add data source dialog box, select a connection type, click Select File, and then upload a file. In this example, MySQL connections are created.
   

   Parameter	Description
   Data source type	You can set this parameter only to Connection string mode.
   Script Upload	Click Template download. In the template, enter the name, description, URL, username, and password of each connection that you want to create. Note The template contains information about a default connection mysql_001_di_test. You can delete the information about the default connection and create your connections.
   Select File	Click Select File and select the modified template.
   Start new	After the file is uploaded, click Start new. The upload results appear in the text box. For example, the upload results include the number of created connections, the number of connections that fail to be created, and failure causes.

4. After the file is uploaded, click Close.
5. On the Data Source page, find the required connection and click Edit.
6. In the dialog box, click Batch test connectivity.
   Note You can use the connections to migrate multiple tables to the cloud only after the connectivity test is passed. For more information, see Migrate multiple tables to the cloud at a time.