Each type of task node can be used to perform a specific operation. Data Management (DMS) provides multiple types of task nodes, such as Single Instance SQL, Cross Database SQL, DTS data migration, and DBS Backup. You can configure multiple types of SQL tasks with ease. This improves development efficiency.

Task node type Description Configuration item on the Content tab
Single Instance SQL Executes SQL statements in a specific database.

If you drag a Single Instance SQL task node to the canvas, you can select one from relational databases of all types that are supported by DMS. You can also drag a task node dedicated to a specific type of relational database. Then, you can select a database only of the specific type. For example, you can drag a MySQL, PostgreSQL, or PolarDB-MySQL task node.

  • Database
  • SQL statements
Cross Database SQL Executes SQL statements across multiple heterogeneous databases. Cross-instance SQL Syntax
DLA Serverless Spark Uses the serverless Spark engine of Data Lake Analytics (DLA). For more information, see Create and run Spark jobs.
  • Region
  • Spark cluster
  • Job configuration
DTS data migration Uses the features of Data Transmission Service (DTS) to migrate data between databases. For more information, see Overview of data migration scenarios.
  • Source
  • Database
  • Table
  • Synchronous Configuration
Lock-Free data modify Changes data without the need to lock tables. For more information, see DML-based lockless change.
  • Database
  • SQL statements
DLA one-click DW Uses the one-click data warehousing feature of DLA to back up data from a database to an Object Storage Service (OSS) bucket that you create.
  • Source of data
  • Target database (Schema) name
  • OSS path
  • Optional:Advanced options
Table status check Executes SQL statements to check whether a table is updated after a specified point in time.
  • Database
  • Table
  • Number of retries
  • Retry interval (Min)
DBS Backup Uses the features of Database Backup (DBS) to back up data from a database to the OSS bucket that is provided by DBS.
  • Source
  • Table
  • Optional:Cross account configuration
DBS Recovery Restores the data that is backed up from the OSS bucket that is provided by DBS to the source database or another database.
  • Data sources
  • Target database
  • Recovery point in time
  • Select the table that needs to be recovered
  • Rename Policy
  • Optional:Cross account configuration
Audit Task Uses an audit task to check the data quality of a table. After you specify a quality rule for the table and a scheduling cycle for the audit task, DMS checks the data quality of the table and generates a report.
  • Database
  • Table name
  • Quality Rule
  • Optional:Column Name