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 in which the workspace you want to manage resides. On the Workspaces page, find the workspace, move the pointer over the More icon in the Actions column, and then select Workspace Settings.
    4. In the left-side navigation pane of the page that appears, click Data Source to go to the Data Source page.
    Note You can also go to the Data Sources page in Data Integration to add a data source. However, you can add a data source on the Data Sources page in Data Integration only to the production environment.
  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
    ParameterDescription
    Data source typeYou can set this parameter only to Connection string mode.
    Script UploadClick 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 FileClick Select File and select the modified template.
    Start newAfter 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 Database migration and migration of multiple tables to the cloud.