All Products
Search

This Product

    Data Transmission Service:Create a connection template

    Document Center

    Data Transmission Service:Create a connection template

    Last Updated:Oct 13, 2023

    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 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.