You can create an AnalyticDB for MySQL node in the DataWorks console to build an online extract, transform, and load (ETL) process.
Note You can run AnalyticDB for MySQL nodes only on exclusive resource groups for scheduling. For more information, see Create and use an exclusive resource group for scheduling.
- 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 in which the workspace that you want to manage resides. Find the workspace and click DataStudio in the Actions column.
- Move the pointer over the icon and choose . Alternatively, you can click the name of the desired workflow in the Business Flow section, right-click UserDefined, and then choose .
- In the Create Node dialog box, configure the Name and Path 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 data source. Select a data source for the node. If you cannot find the desired data source from the Select Data Source drop-down list, click Add Data Source and add a data source on the Data Source page. For more information, see Supported data source types, readers, and writers.
- Write SQL statements for the node. After you select a data source, 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.
- Select a data source.
- On the configuration tab of the node, click Properties in the right-side navigation pane. On the Properties tab, configure scheduling properties
for the node. For more information, see Configure basic properties. You must select an exclusive resource group for scheduling that is connected to the specific AnalyticDB for MySQL data source to periodically run the node.
- Save and commit the node. Notice You must configure the Rerun and Parent Nodes parameters on the Properties tab before you commit the node.
If the workspace that you use is in standard mode, you must click Deploy in the upper-right corner to deploy the node after you commit it. For more information, see Deploy nodes.
- Click the icon in the top toolbar to save the node.
- Click the icon in the toolbar.
- In the Commit Node dialog box, configure the Change description parameter.
- Click OK.
- Perform O&M operations on the node. For more information, see O&M overview of auto triggered nodes.