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

Background information

  • To migrate multiple tables to the cloud, you can create only multiple MySQL, Oracle, or SQL Server connections at a time.
  • To create multiple connections at a time, you can set the connection type only to Connection string mode.
  • After you create 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 multiple tables to the cloud.

Procedure

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