Updated on 2022-09-22 GMT+08:00

Creating Links

Scenario

Before creating a data migration job, create a link to enable the CDM cluster to read data from and write data to a data source. A migration job requires a source link and a destination link. For details on the data sources that can be exported (source links) and imported (destination links) in different migration modes (table/file migration), see Supported Data Sources.

The link configurations depend on the data source. This section describes how to create these links.

Constraints

If changes occur in the connected data source (for example, the MRS cluster capacity is expanded), you need to edit and save the connection.

Prerequisites

  • A CDM cluster is available.
  • The CDM cluster can communicate with the destination data source.
    • If the destination data source is an on-premises database, you need the Internet or Direct Connect. When using the Internet, ensure that an EIP has been bound to the CDM cluster, the security group of CDM allows outbound traffic from the host where the off-cloud data source is located, the host where the data source is located can access the Internet, and the connection port has been enabled in the firewall rules.
    • If the destination data source is a cloud service (such as DWS, MRS, and ECS), the following requirements must be met for network interconnection:
      • If the CDM cluster and the cloud service are in different regions, a public network or a dedicated connection is required for enabling communication between the CDM cluster and the cloud service. If the Internet is used for communication, ensure that an EIP has been bound to the CDM cluster, the host where the data source is located can access the Internet, and the port has been enabled in the firewall rules.
      • If the CDM cluster and the cloud service are in the same region, VPC, subnet, and security group, they can communicate with each other by default. If they are in the same VPC but in different subnets or security groups, you must configure routing rules and security group rules. For details about how to configure routing rules, see configuring routes. For details about how to configure security group rules, see configuring security group rules.
      • The cloud service instance and the CDM cluster belong to the same enterprise project. If they do not, you can modify the enterprise project of the workspace.
  • You have obtained the URL and the account for accessing the data source. The account is granted with the read and write permissions for the data source.
  • When using the Agent, you need to use the main account to grant the CDM operation permission to the sub-account.

Creating Links

  1. Log in to the management console and choose Service List > Cloud Data Migration. On the CDM console, choose Cluster Management in the left navigation pane. Locate the row that contains the target cluster and click Job Management in the Operation column. On the displayed Links page, click Create Link. On the displayed page shown in Figure 1, select a connector.

    The connectors are classified based on the type of the data source to be connected. All supported data types are displayed.

    Figure 1 Selecting a connector type

  2. Select a data source and click Next. The following describes how to create a MySQL link.

    The link parameters of different data sources vary. Table 1 describes the link parameters.
    Table 1 Link parameters

    Connector

    Description

    • Data Warehouse Service
    • RDS for MySQL
    • RDS for PostgreSQL
    • RDS for SQL Server
    • PostgreSQL
    • Microsoft SQL Server
    • SAP HANA

    Because the JDBC drivers used to connect to these relational databases are the same, the parameters to be configured are also the same and are described in Link to a Common Relational Database.

    MySQL

    For details about the parameters, see Link to an RDS for MySQL/MySQL Database.

    Oracle

    For details about the parameters, see Link to an Oracle Database.

    Database Sharding

    For details about the parameters, see Link to a Database Shard.

    HUAWEI CLOUD OBS

    For details about the parameters, see Link to OBS.

    • MRS HDFS
    • FusionInsight HDFS
    • Apache HDFS

    If the data source is HDFS of MRS, Apache Hadoop, or FusionInsight HD, see Link to HDFS.

    • MRS HBase
    • FusionInsight HBase
    • Apache HBase

    If the data source is HBase of MRS, Apache Hadoop, or FusionInsight HD, see Link to HBase.

    • MRS Hive
    • FusionInsight Hive
    • Apache Hive

    If the data source is Hive on MRS, Apache Hadoop, or FusionInsight HD, see Link to Hive.

    CloudTable Service

    If the data source is CloudTable, see Link to CloudTable.

    • FTP
    • SFTP

    If the data source is an FTP or SFTP server, see Link to an FTP or SFTP Server.

    HTTP

    These connectors are used to read files with an HTTP/HTTPS URL, such as reading public files on the third-party object storage system and web disks.

    When creating an HTTP link, you only need to configure the link name. The URL is configured during job creation.

    MongoDB

    If the data source is a local MongoDB, see Link to MongoDB.

    Document Database Service (DDS)

    If the data source is DDS, see Link to DDS.

    • Redis
    • Distributed Cache Service

    If the data source is Redis or DCS, see Link to Redis/DCS.

    • MRS Kafka
    • Apache Kafka

    If the data source is MRS Kafka or Apache Kafka, see Link to Kafka.

    Cloud Search Service (CSS)

    Elasticsearch

    If the data source is CSS or Elasticsearch, see Link to Elasticsearch/CSS.

    Data Lake Insight

    If the data source is DLI, see Link to DLI.

    DMS Kafka

    If the data source is DMS Kafka, see Link to DMS Kafka.

    Cassandra

    If the data source is Cassandra, see Link to Cassandra.

    Currently, the following data sources are in the OBT phase: FunsionInsight HDFS, FunsionInsight HBase, FunsionInsight Hive, SAP HANA, Document Database Service, CloudTable Service, Cassandra, DMS Kafka, Cloud Search Service, and Sharding Database.

  3. After configuring the parameters of the link, click Test to check whether the link is available. Alternatively, click Save, and the system checks automatically.

    If the network is poor or the data source is too large, the link test may take 30 to 60 seconds.

Managing Links

CDM allows you to perform the following operations on created links:
  • Deleting links: You can delete links that are not used by any job.
  • Editing a link: You can modify link parameters but cannot reselect the connector. To modify a link, you need to re-enter the password needed to access the data source.
  • Testing connectivity: You can test connectivity of a link that has been saved.
  • Viewing the JSON file of a link: You can view parameters of a link in a JSON file.
  • Editing the JSON file of a link: Modify parameters of a link in a JSON file.
  • Viewing the backend link: You can view the backend link corresponding to a link. For example, you can query details about the backend link of a MyCAT link.

Before managing a link, ensure that the link is not used by any job to avoid affecting jobs. The procedure for managing connections is as follows:

  1. Log in to the management console and choose Service List > Cloud Data Migration. On the CDM console, choose Cluster Management in the left navigation pane. Locate the row that contains the target cluster and click Job Management in the Operation column. On the displayed page, click the Links tab.
  2. On the Links page, locate the link to be modified.

    • Deleting a link: Click Delete in the Operation column to delete a link. Alternatively, select the links that are not used by any job and click Delete Link above the list to delete them.
    • Editing the link: Click the link name or click Edit in the Operation column to access the page for modifying the link. When modifying the link, you need to enter the password for logging in to the data source again.
    • Testing connectivity of the link: Click Test Connectivity in the Operation column.
    • Viewing the JSON file of the link: In the Operation column, choose More > View Link JSON to view link parameters in JSON format.
    • Editing the JSON file of the link: In the Operation column, choose More > Edit Link JSON to modify link parameters in JSON format.
    • Viewing the backend link: Locate the row that contains a link and click More in the Operation column and select View Backend Link to view the backend link corresponding to the link.