A connection template stores the credentials and network settings for a source or destination database instance, so you can reuse the connection across multiple extract, transform, and load (ETL) tasks without reconfiguring it each time.
To create a connection template in the Data Management (DMS) console instead, see Create a connection template.
Prerequisites
Before you begin, make sure you have:
The database account and password for the instance you want to connect to
The access method you plan to use (see the parameter table below)
If using SSL-encrypted: SSL encryption already enabled on the database instance
If using Alibaba Cloud Instance: the RDS instance ID
ETL tasks are only supported in the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Shenzhen), and China (Guangzhou).
Create a connection template
This procedure uses MySQL as an example. You can apply the same steps for other supported database types.
Go to the ETL page.
In the upper-left corner, select the region where you want to create the connection template.
In the left-side navigation pane, click ETL.
On the ETL page, click Create Task.
In the Input/Dimension Table section on the left side, select MySQL and drag it to the canvas.
Click MySQL on the canvas.
In the Input/Dimension Table: MySQL section, click the Node Settings tab, then click Create Template.
In the Create Template dialog box, configure the parameters. Parameters for Alibaba Cloud Instance only These parameters are required only when Access Method is set to Alibaba Cloud Instance. Parameters for Public IP Address only These parameters are required only when Access Method is set to Public IP Address.
General settings
Parameter Description Connection Name A name for this connection. Use a descriptive name that helps you identify the connection later. The name does not need to be unique. Access Method How the database instance is accessed. Options: 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 The region where the database instance resides. Database Account The account used to log on to the database instance. Database Password The password used to log on to the database instance. Parameter Description Replicate Data Across Alibaba Cloud Accounts Whether the ETL task runs across Alibaba Cloud accounts. RDS Instance ID The ID of the database instance. Encryption 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. Parameter Description Hostname or IP Address The endpoint used to access the database instance. Port Number The service port number of the database instance. 
Click Save.
What's next
Configure the ETL task using the connection template you just created.
To create a connection template for the destination database, repeat the steps above and select the destination database type in the Input/Dimension Table section.