This topic describes how to configure the destination database for an ETL task.

Prerequisites

  • An ETL task is created in the China (Hangzhou) or China (Beijing) region.
  • The destination database is a self-managed MySQL database, an ApsaraDB RDS for MySQL instance, or an AnalyticDB for MySQL cluster.
  • The destination database is created.
  • The source database and the transformation component are configured.
  • The schemas of tables in the destination database are created. This is because the ETL feature does not support schema migration. For example, Table A contains Field 1, Field 2, and Field 3, and Table B contains Field 3, Field 4, and Field 5. If you need to join Table A and Table B into a table that contains Field 1, Field 2, Field 3, Field 4, and Field 5, you must create Table C in the destination database. Table C contains Field 1, Field 2, Field 3, Field 4, and Field 5.

Procedure

Note In this example, the destination database is a self-managed MySQL database.
  1. In the upper-left corner of the page, select the region where you create the ETL task.
    Note You can create an ETL task only in the China (Hangzhou) or China (Beijing) region. Select a region based on the actual scenario.
  2. In the left-side navigation pane, click ETL.
  3. On the ETL page, click Create Task (Pay-as-you-go).
  4. Configure the source database. For more information, see Configure a source database.
  5. Configure the transformation component. For more information, see Configure the transformation components.
  6. Move the pointer over the destination database, and click the dot to draw a line between the destination database and the transformation component.
  7. In the Output section on the left side of the page, select MySQL and drag it to the canvas on the right side of the page.
  8. Click MySQL on the canvas.
  9. In the Output: MySQL section, set the required parameters.
    1. On the Configure Nodes tab, set the required parameters.
      Destination Database_Configure Nodes
      Parameter Description
      Data Source Name DTS automatically generates a name. We recommend that you specify an informative name for easy identification. You do not need to use a unique name.
      Region Select the region where the destination database resides.
      Database Connection Template Select the name of the template that stores the connection settings of the destination database. You can also click Create Template to create a connection template. For more information, see Create a connection template.
      Table Mapping Select the table to be stored in the destination database.

      In the Select Destination Table section, click the destination table.

    2. On the Field Mapping tab, select the column names based on your needs and set the related parameters.
      Destination Database_Field Mapping

Result

After the destination database is configured, the Configured icon appears on the right side of the destination database.