AnalyticDB for MySQL nodes are supported in DataWorks. You can create an AnalyticDB for MySQL node in the DataWorks console to build an online extract, transform, and load (ETL) process.

Background information

AnalyticDB for MySQL nodes are used to connect to AnalyticDB for MySQL, a database service that is provided by Alibaba Cloud. For more information, see AnalyticDB for MySQL documentation.
Note You can run AnalyticDB for MySQL nodes only on exclusive resource groups for scheduling. For more information, see Add and use exclusive resource groups for scheduling.

Procedure

  1. Go to the DataStudio 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 the target workspace resides. Find the target workspace and click Data Analytics in the Actions column.
  2. On the Data Development tab, move the pointer over Create icon and choose Customize > AnalyticDB for MySQL.
    Alternatively, you can click the target workflow in the Business process section, right-click Customize, and then choose New > AnalyticDB for MySQL.
  3. In the New node dialog box, set the Node name and Destination folder parameters.
    Note The node name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.). It is not case-sensitive.
  4. Click Submit.
  5. Configure the AnalyticDB for MySQL node.
    1. Select a connection.
      On the configuration tab of the AnalyticDB for MySQL node, select a connection from the Select data source drop-down list. If you cannot find the required connection in the drop-down list, click New data source to add a connection on the Data Source page. For more information, see Supported data stores and plug-ins.Configuration tab
    2. Write the SQL statements of the node.
      After you select a connection, write SQL statements based on the syntax that is supported by AnalyticDB for MySQL. You can write data manipulation language (DML) or data definition language (DDL) statements in the code editor.
    3. Click Save icon in the toolbar.
    4. Click Run icon in the toolbar to run the SQL statements you have saved.
    If you need to change the resource group on which you test the AnalyticDB for MySQL node on the DataStudio page, click Advanced run (run with parameters) icon in the toolbar and select your desired exclusive resource group.
    Note To access a data store in a virtual private cloud (VPC), a node must be run on an exclusive resource group for scheduling. In this example, the data store is in a VPC. You must select an exclusive resource group for scheduling that is connected to the target AnalyticDB for MySQL data store.
  6. Click the Scheduling configuration tab in the right-side navigation pane. On the Scheduling configuration tab, set the scheduling properties for the node. For more information, see Basic attributes.
    You must select an exclusive resource group for scheduling that is connected to the target AnalyticDB for MySQL data store to periodically run the node.
  7. Save and commit the node.
    Notice You must set the Rerun attribute and Dependent upstream node parameters on the Scheduling configuration tab before you can commit the node.
    1. Click Save icon in the toolbar to save the node.
    2. Click Submit icon in the toolbar to commit the node.
    3. In the Submit New Version dialog box, enter your comments in the Change description field.
    4. Click OK.
    In a workspace in standard mode, you must click Publish in the upper-right corner after you commit the AnalyticDB for MySQL node. For more information, see Deploy a node.
  8. Test the node. For more information, see Auto triggered nodes.