An AnalyticDB for MySQL 3.0 connection allows you to read data from and write data to AnalyticDB for MySQL 3.0. You can configure sync nodes for AnalyticDB for MySQL 3.0 by using the codeless user interface (UI) or code editor.

Workspaces in standard mode support the connection isolation feature. You can add connections for the development and production environments separately and isolate the connections to protect your data security.

Procedure

  1. Log on to the DataWorks console as a workspace administrator, find the target workspace, and then click Data Integration in the Actions column.
  2. In the left-side navigation pane, click Connection to go to the Workspace Manage > Data Source page.
  3. On the Data Source page, click Add Connection in the upper-right corner.
  4. In the Add Connection dialog box that appears, click AnalyticDB for MySQL 3.0 in the Relational Database section.
  5. In the Add AnalyticDB for MySQL 3.0 Connection dialog box that appears, set the parameters.
    The AnalyticDB for MySQL 3.0 connection type can be set to AnalyticDB for MySQL or JDBC Connection Mode.
    • The following table describes the parameters that appear after you set Connect To to AnalyticDB for MySQL.
      Parameter Description
      Connect To The type of the connection. Here, set the value to AnalyticDB for MySQL.
      Connection Name The name of the connection. The name can contain letters, digits, and underscores (_) and must start with a letter.
      Description The description of the connection. The description cannot exceed 80 characters in length.
      Applicable Environment The environment in which the connection is used. Valid values: Development and Production.
      Note This parameter is available only when the workspace is in standard mode.
      Region The region of the AnalyticDB for MySQL 3.0 instance.
      ADS Instance ID The ID of the AnalyticDB for MySQL 3.0 instance. You can view the ID on the AnalyticDB for MySQL 3.0 console.
      Database Name The name of the database.
      Username The username for logging on to the database.
      Password The password for logging on to the database.
    • The following table describes the parameters that appear after you set Connect To to JDBC Connection Mode.
      Parameter Description
      Connect To The type of the connection. Here, set the value to JDBC Connection Mode.
      Connection Name The name of the connection. The name can contain letters, digits, and underscores (_) and must start with a letter.
      Description The description of the connection. The description cannot exceed 80 characters in length.
      Applicable Environment The environment in which the connection is used. Valid values: Development and Production.
      Note This parameter is available only when the workspace is in standard mode.
      JDBC URL The Java Database Connectivity (JDBC) URL of the database, in the format of jdbc:mysql://ServerIP:Port/Database.
      Username The username for logging on to the database.
      Password The password for logging on to the database.
  6. Click Test Connection.
  7. After the connectivity test is passed, click Complete.

Note on connectivity testing

  • If the data store is a user-created one deployed on Elastic Compute Service (ECS) instances that reside on a classic network, we recommend that you use a custom resource group to run sync nodes that use the connection. The default resource group does not guarantee that it can connect to the data store over the network.
  • If the data store is deployed in a Virtual Private Cloud (VPC) and you configure the connection in instance mode, the connectivity test checks whether the entered information is correct.