Before you create a data migration or synchronization project, you must create the data sources. This topic describes how to create a data source of the AnalyticDB for MySQL (ADB) type, a cloud-native data warehouse, by using data transmission.
Background information
For more information about ADB, see Basic data types.
For more information about how to create, partition, and distribute tables in ADB, see CREATE TABLE.
For more information about the data type mapping rules, see Data types and mappings.
Procedure
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, choose Data Transmission > Data Source Management.
On the Data Sources page, click New Data Source in the upper-right corner.
In the Create Data Source dialog box, select ADB for Data Source Type and configure the following parameters.
Parameter
Description
Data Source Identifier
The data source identifier. We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a data migration or synchronization project between instances under different Alibaba Cloud accounts to migrate or synchronize data across Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the Alibaba Cloud account of the destination instance. If you do not have permissions on this Alibaba Cloud account, request for authorization first. For more information, see Apply for cross-account authorization.
Cluster ID
Select the ID of the target cluster from the drop-down list.
Username
Specify the username for logging on to the cluster.
Password
Specify the password for logging on to the cluster.
Remarks
Optional. Additional information about the data source.
Click Test Connection to verify the network connection between the data transmission service and the data source, as well as the validity of the username and password.
After the test is passed, click OK.