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.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.
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 the workspace resides. On the Workspaces page, find the workspace in which you want to create tables, 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 Business Flow, 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 Confirm.
- Configure the AnalyticDB for MySQL node.
- 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. Important You must configure the Rerun and Parent Nodes parameters on the Properties tab before you commit the node.
- 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.
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. - Perform O&M operations on the node. For more information, see Perform basic O&M operations on auto triggered nodes.