Database nodes let you run SQL tasks against external relational databases, schedule them on a recurring basis, and integrate them into broader DataWorks workflows.
Prerequisites
Before you begin, ensure that you have:
A workspace with the Developer or Workspace Administrator role assigned to your RAM user (optional for RAM users). The Workspace Administrator role carries broad permissions — assign it with caution. For more information, see Add members to a workspace.
A DataWorks data source created using a JDBC connection string. Other connection types are not supported for database nodes. For more information, see Data Source Management.
Network connectivity confirmed between your serverless resource group and the data source. For more information, see Network connectivity solutions.
A data source that supports database nodes. See Supported data sources.
A database node already created. For more information, see Create a node for a scheduled workflow.
Step 1: Develop the database node
Select a data source
In the Select Data Source drop-down list, click 
to open the dialog box. Select the data source to use for task development. If the data source you need is not listed, click Add Data Source to add it.
In a Standard mode workspace, the list only shows data sources configured for both the development and production environments. Database nodes support only data sources created using a JDBC connection string.
Write the SQL script
In the SQL editor, write the SQL statements for your task. The following example queries a table and uses a placeholder parameter:
SELECT * FROM your_table_name; -- Query the table.
SELECT '${var}'; -- Use a placeholder parameter.Write SQL based on the syntax supported by your configured data source.
Stored procedures are not supported in DataWorks script development, even if the underlying database supports them natively.
Configure the resource group and parameters
Click Run Configuration to open the debugging panel. Configure the following settings before running:
| Setting | Required | Description |
|---|---|---|
| DataWorks Resource Group | Required | A serverless resource group with network connectivity to your data source. Required for both public network and VPC access. See Network connectivity solutions. |
| Script Parameter | Optional | Values assigned to placeholder parameters (such as ${var}) defined in your SQL script. |
Save and run
Click 
to save the node, then click 
to run the SQL script and verify it works as expected.
Configure scheduling
After the SQL script runs successfully, click scheduling configuration on the right side of the SQL editor to set the node's schedule. For more information, see Node scheduling configuration.
Step 2: Publish and maintain the node
Submit and publish the database node to the production environment. For more information, see Node and workflow deployment.
After publishing, the task runs automatically on the configured schedule. To monitor and manage it, go to Operations Center > Task O&M > Scheduled Task O&M > Scheduled Task. For more information, see Getting started with Operation Center.
What's next
Node scheduling configuration — Set up recurring schedules, dependencies, and triggers for your database node.
Node and workflow deployment — Submit and publish nodes from the development environment to production.
Getting started with Operation Center — Monitor scheduled task execution and perform maintenance operations.
Network connectivity solutions — Troubleshoot connectivity between your resource group and data source.