All Products
Search

This Product

    DataWorks:Attach an AnalyticDB for MySQL 3.0 computing resource

    Document Center

    DataWorks:Attach an AnalyticDB for MySQL 3.0 computing resource

    Last Updated:Oct 29, 2025

    To develop and manage AnalyticDB for MySQL 3.0 tasks in DataWorks, you must first attach your AnalyticDB for MySQL 3.0 cluster as an AnalyticDB for MySQL (V3.0) computing resource. After the resource is attached, DataWorks can use it to connect to the AnalyticDB for MySQL 3.0 cluster. This lets you perform operations such as data synchronization, data development, and data analysis.

    Prerequisites

    • An AnalyticDB for MySQL 3.0 cluster is created.

      Note

      When you purchase an AnalyticDB for MySQL 3.0 cluster, select the same Region as your DataWorks workspace. If the regions are different, you cannot attach the cluster to the workspace as a computing resource.

    • A DataWorks workspace is created. The Resource Access Management (RAM) user who performs the operation must be added to the workspace and assigned the Workspace Administrator role.

    • A resource group is attached to the workspace, and its network connectivity is confirmed.

      • If you use a Serverless resource group, ensure that the AnalyticDB for MySQL (V3.0) computing resource can connect to the Serverless resource group.

      • If you use a legacy exclusive resource group, ensure that the AnalyticDB for MySQL (V3.0) computing resource can connect to the exclusive resource group for scheduling for the relevant scenario.

      • The resource group must be attached to the same VPC as the AnalyticDB for MySQL 3.0 cluster. Add the IP addresses of the resource group to the whitelist of the AnalyticDB for MySQL 3.0 cluster.

    Limits

    • Region: China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Hong Kong), Japan (Tokyo), Singapore, Malaysia (Kuala Lumpur), and Indonesia (Jakarta).

    • Permissions:

      Operator

      Required permissions

      Alibaba Cloud account

      No extra permissions are required.

      RAM user/RAM role

      Only workspace members with the O&M or Workspace Administrator role, or members with the AliyunDataWorksFullAccess permission can create computing resources. For more information about authorization, see Grant permissions to a workspace administrator.

    New Data Development (DataStudio): Attach an AnalyticDB for MySQL (V3.0) computing resource

    Attach an AnalyticDB for MySQL (V3.0) computing resource to a workspace that Uses The New Data Development (DataStudio).

    Go to the computing resources page

    1. Log on to the DataWorks console. Switch to the destination region. In the navigation pane on the left, click More > Management Center. Select the desired workspace from the drop-down list and click Go To Management Center.

    2. In the navigation pane on the left, click Computing Resources to go to the computing resources page.

    Attach the AnalyticDB for MySQL (V3.0) computing resource

    On the computing resources page, configure the AnalyticDB for MySQL (V3.0) computing resource.

    1. Select the computing resource type.

      1. Click Attach Computing Resource to go to the Attach Computing Resource page.

      2. On the Attach Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). You are redirected to the Attach AnalyticDB For MySQL (V3.0) Computing Resource configuration page.

    2. Configure the AnalyticDB for MySQL (V3.0) computing resource.

      On the Attach AnalyticDB For MySQL (V3.0) Computing Resource configuration page, set the parameters as described in the following table.

      Parameter

      Description

      Configuration Mode

      Only Alibaba Cloud Instance Mode is supported.

      Alibaba Cloud Account

      Only the current Alibaba Cloud account is supported.

      Instance

      Select the AnalyticDB for MySQL 3.0 cluster to attach. You can also click Create in the drop-down menu to create an AnalyticDB for MySQL 3.0 cluster.

      Database Name

      Enter the name of a database that is already created in the AnalyticDB for MySQL 3.0 cluster.

      Username and Password

      The database account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account.

      Computing Resource Instance Name

      Enter a custom name for the computing resource. At runtime, you can select the computing resource for a task based on this name.

    3. Test the connectivity.

      In the connection settings section, select the resource group that DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Click Test Connectivity to verify that the resource group can access your AnalyticDB for MySQL (V3.0) cluster. For more information, see Overview of network connection solutions.

    4. Click Confirm to complete the configuration.

      Note

      When you attach an AnalyticDB for MySQL (V3.0) computing resource, the system automatically creates an AnalyticDB for MySQL (V3.0) data source with the same name in the Data Source section of the current workspace.

    Legacy Data Development: Attach an AnalyticDB for MySQL (V3.0) computing resource

    Attach an AnalyticDB for MySQL (V3.0) computing resource to a workspace that does not Use The New Data Development (DataStudio).

    Go to the computing resources page

    1. Go to the DataStudio page.

      Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and O&M > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

    2. In the navigation pane on the left, click the image icon to go to the Computing Resources page.

    Attach the AnalyticDB for MySQL (V3.0) computing resource

    On the computing resources page, configure the AnalyticDB for MySQL (V3.0) computing resource.

    1. Select the computing resource type.

      1. Click Create Computing Resource to go to the Create Computing Resource page.

      2. On the Create Computing Resource page, set the computing resource type to AnalyticDB for MySQL (V3.0). You are redirected to the Create Computing Resource configuration page.

    2. Configure the AnalyticDB for MySQL (V3.0) computing resource.

      On the Create Computing Resource configuration page, set the parameters as described in the following table.

      Parameter

      Description

      Data Source Name

      Enter a custom name for the computing resource. At runtime, you can select the computing resource for a task based on this name.

      Configuration Mode

      Select Alibaba Cloud Instance Mode.

      Note

      Computing resources attached in Connection String Mode cannot be attached to the current workspace. They can only be generated as data sources.

      Alibaba Cloud Account

      You can select Current Alibaba Cloud Account or Other Alibaba Cloud Account.

      Note

      If you select Other Alibaba Cloud Account, enter the parameters related to the other account as prompted on the page.

      Region

      The region where your workspace resides.

      Instance

      Select the AnalyticDB for MySQL 3.0 cluster that you want to attach in the current region.

      Database Name

      Enter the name of a database that is already created in the AnalyticDB for MySQL 3.0 cluster.

      Username and Password

      The database account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account.

    3. Test the connectivity.

      In the connection settings section, select the resource group that DataWorks will use to run AnalyticDB for MySQL 3.0 tasks. Click Test Connectivity to verify that the resource group can access your AnalyticDB for MySQL 3.0 cluster. For more information, see Overview of network connection solutions.

    4. Click Create Computing Resource And Attach To Data Development to complete the configuration.

      Note

      When you attach an AnalyticDB for MySQL (V3.0) computing resource, the system automatically creates an AnalyticDB for MySQL (V3.0) data source with the same name in the Data Source section of the current workspace.

    Appendix

    Connection String Mode does not support attaching a computing resource. It only supports creating a data source. You can use Connection String Mode to configure an AnalyticDB for MySQL 3.0 data source.

    Parameter

    Description

    JDBC URL

    Format: jdbc:mysql://ServerIP:Port/Database.

    Note

    ServerIP: The Internet or VPC endpoint of the AnalyticDB for MySQL 3.0 cluster.

    Port: The VPC port number of the AnalyticDB for MySQL 3.0 cluster. The default value is 3306.

    Database: The name of a database that is already created in your AnalyticDB for MySQL 3.0 cluster.

    Username and Password

    The database account and password that can be used to access the AnalyticDB for MySQL 3.0 cluster. If you do not have an account, you can create a database account.

    What to do next

    • New Data Development: After you configure the AnalyticDB for MySQL (V3.0) computing resource, you can use an offline sync node for data synchronization and an ADB for MySQL node for data development.

    • Legacy Data Development: After you configure the AnalyticDB for MySQL (V3.0) computing resource, you can use a Data Integration > Offline Synchronization node for data synchronization and an AnalyticDB for MySQL node for data development.