This topic describes how to create a connection template for the source or destination database instance that you want to use in an extract, transform, and load (ETL) task.

Procedure

Note
  • In this topic, a MySQL database is used to describe how to create a connection template.
  • For more information about how to create a connection template in the Data Management (DMS) console, see Create a connection template.
  1. Go to the ETL page.
  2. In the upper-left corner of the page, select the region where you want to create a connection template.
    Note You can create an ETL task only in the China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Shenzhen), and China (Guangzhou) regions. Select a region based on your needs.
  3. In the left-side navigation pane, click ETL.
  4. On the ETL page, click Create Task.
  5. In the Input/Dimension Table section on the left side of the page, select MySQL and drag it to the canvas on the right side of the page.
  6. Click MySQL on the canvas.
  7. In the Input/Dimension Table: MySQL section, set parameters for the source database.
    1. Click the Node Settings tab.
    2. Click Create Template.
    3. In the Create Template dialog box, set the required parameters.
      new
      Parameter Description
      Connection Name The name of the database connection. We recommend that you specify a descriptive name to that makes it easy to identify. You do not need to use a unique name.
      Access Method The access method of the database instance. Select one of the following access methods based on your needs.
      • Alibaba Cloud Instance
      • Express Connect, VPN Gateway, or Smart Access Gateway
      • Public IP Address
      • Self-managed Database on ECS
      • Cloud Enterprise Network (CEN)
      • Database Gateway
      Instance Region Select the region where the database instance resides.
      Replicate Data Across Alibaba Cloud Accounts Specify whether the ETL task is performed across Alibaba Cloud accounts.
      Note This parameter is required only if you select Alibaba Cloud Instance as the access method.
      RDS Instance ID Select the ID of the database instance.
      Note This parameter is required only if you select Alibaba Cloud Instance for the access method.
      Database Account Enter the account used to log on to the database instance.
      Database password Enter the password used to log on to the database instance.
      Encryption Select Non-encrypted or SSL-encrypted. If you select SSL-encrypted, you must enable SSL encryption for the database instance before you configure the ETL task.
      Note This parameter is required only if you select Alibaba Cloud Instance as the access method.
      Hostname or IP Address Enter the endpoint that is used to access the database instance.
      Note This parameter is required only if you select Public IP Address as the access method.
      Port Number Enter the service port number of the database instance.
      Note This parameter is required only if you select Public IP Address as the access method.
    4. Click Save.