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 of Alibaba
Cloud. For more information, see AnalyticDB for MySQL documentation.
Procedure
- Go to the DataStudio page.
- Log on to the DataWorks console.
- In the left-side navigation pane, click Workspaces.
- In the top navigation bar, select the region where your workspace resides, find the
workspace, and then click Data Analytics in the Actions column.
- Move the pointer over the
icon and choose .Alternatively, you can click the required workflow, right-click UserDefined, and then choose .
- In the Create Node dialog box, set the Node Name and Location parameters.
Note The node name must be 1 to 128 characters in length and can contain letters, digits,
underscores (_), and periods (.).
- Click Commit.
- Configure the AnalyticDB for MySQL node.
- Select a connection.
Select a connection for the node. If you cannot find the required connection in the
drop-down list, click
Add Connection and create a connection on the
Data Source page. For more information, see
Supported data stores and plug-ins.

- 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.
- Click the
icon in the toolbar to save the SQL statements to the server.
- Click the
icon in the toolbar to execute the SQL statements you have saved.When you run the node for the first time, the
Parameters dialog box appears. You must select a resource group for running the node from the
Scheduling Resource Group drop-down list, set other parameters as required, and then click
Confirm.
When you run the node later, the system uses the resource group and parameter settings
that you specify for the first running of the node. If you need to change the resource
group or modify the parameter settings, click the

icon in the toolbar.
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, you must select an exclusive
resource group for scheduling that is connected to the AnalyticDB for PostgreSQL instance.
- Click the Properties tab in the right-side navigation pane and set the scheduling properties for the node.
For more information, see Basic properties.
You must select an exclusive resource group for scheduling that is connected to the
specified AnalyticDB for MySQL data store to periodically run the node.
- Save and commit the node.
Notice You must set the Rerun and Parent Nodes parameters before you can commit the node.
- Click the
icon in the toolbar to save the node.
- Click the
icon in the toolbar.
- In the Commit Node dialog box, enter your comments in the Change description field.
- Click OK.
In a workspace in standard mode, you must click
Deploy in the upper-right corner after you commit the node. For more information, see
Deploy a node.
- Test the node. For more information, see View auto triggered nodes.