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 simple operations. This improves development efficiency.

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

If you drag a Single Instance SQL task node to the canvas, you can select one from relational databases of all types that DMS supports. 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 database instances. 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
  • Target
  • 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 the data from a database to a self-managed Object Storage Service (OSS) bucket.
  • 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.
  • Target
  • 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 DBS provides.
  • Source of data
  • Table
  • Optional:Cross account configuration
DBS Recovery Restores the data that is backed up from the OSS bucket that DBS provides 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