AnalyticDB for MySQL nodes are supported in DataWorks. You can create an AnalyticDB for MySQL node in the DataWorks console to build an online ETL process.

Background information

AnalyticDB for MySQL nodes are used to connect to AnalyticDB for MySQL of Alibaba Cloud. For more information, see https://www.alibabacloud.com/help/doc-detail/93776.htm.

Note
  • Only AnalyticDB for MySQL groups are supported for exclusive resources for scheduling nodes. .
  • for AnalyticDB for MySQL nodes, you can only select data sources in the production environment.

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. Hover over Createicon, click custom > AnalyticDB for MySQL.
    You can also select a workflow, right-click UserDefined, and then choose Create > AnalyticDB for MySQL.
  3. In the Create Node dialog box that appears, set Node Name and Location.
    Note The node name can be up to 128 characters in length and can contain letters, digits, underscores (_), and periods (.).
  4. Click OK.
  5. Edit AnalyticDB for MySQL node:
    1. Configure the connections.
      Select a connection for the node. If the required data source is not in the drop-down list, click create a data source, in data source management page, see supported data source and read /write plug-ins.Configure a connection
    2. Write SQL statements.
      After selecting a connection, you can write SQL statements based on the syntax supported by AnalyticDB for MySQL. You can write Data Manipulation Language (DML) and Data Definition Language (DDL) statements in the SQL code editor.
    3. Click Save icon in the toolbar.
    4. Click Run iconicon to execute the SQL statement.
    If you need to modify data Development the task execution resource to use when testing the page, click Run with Argumentsicon to select a exclusive resources for scheduling group.
    Note To access the data source of the VPC network environment, you must use the exclusive resources for scheduling Group to execute the task. Therefore, you must select a exclusive resources for scheduling Group to test the connectivity.
  6. In the node editing area, click scheduling configuration to configure the schedule of the node. For more information, see Basic attributes.
    When you configure the properties of a resource group, set the AnalyticDB for MySQL group to a resource group that is already connected to the exclusive resources for scheduling network.
  7. Save and commit the node.
    Notice You need to set the node's re-run attribute and dependent upstream node to commit the node.
    1. Click Save iconicon to save the node.
    2. Click Commit dialog box in the toolbar.
    3. In submit New version dialog box, enter remarks.
    4. Click OK.
    In a workspace in the standard mode, you need to click Publish in the upper-right corner after you commit the real-time sync node. For more information, see Deploy a node.
  8. The test node. For more information, see Auto triggered nodes.