Create a TiDB data source by using the data transmission service - ApsaraDB for OceanBase

Before you create a data migration or synchronization project, you must create the data sources. This topic describes how to create a TiDB data source in the data transmission system.

Prerequisites

You have obtained the IP address and port number of the related database.
You have created a database user for data migration.
We recommend that you create a dedicated database user for the data migration project and grant the required data operation privileges to the user. For more information, see Create a TiDB database user.
If you need to subscribe to incremental logs from the TiDB database, deploy a Kafka data source and a Kafka topic. In addition, you must create a project to synchronize data from the TiDB database to the Kafka data source in advance. For more information, see TiDB User Guide.
Important
The names of the databases and tables that you subscribe to in the TiDB database must be the same as those specified in the data migration project.

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 TiDB for Data Source Type.

Configure the following parameters. Select an instance type from the Instance Type drop-down list. The corresponding configuration section automatically appears.

Note

The instance type of a TiDB data source can be self-managed database in VPC or self-managed database with a public IP address.

Instance type	Parameter	Description
Self-managed database in a virtual private cloud (VPC)	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.
Self-managed database in a virtual private cloud (VPC)	VPC	The unique ID of the VPC that you used.
Common parameters Self-managed database instance with a public IP address (contains all common parameters)	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.
	Host IP Address	The IP address of the server where the TiDB database is located.
	Port	The port number corresponding to the IP address of the server where the TiDB database is located.
	Username	The name of the TiDB database user for data migration or synchronization. We recommend that you create a dedicated database user for data migration or synchronization. For more information, see Create a database user.
	Password	The password of the database user.
	DB Name	The name of the TiDB database. Note If this parameter is specified, you can select only migration objects in the specified database when a data source serves as the source of a data migration project.
	Incremental Synchronization Settings	Kafka data source/Topic Specifies whether to use a Kafka data source to save the incremental logs of the TiDB database that are converted by TiCDC for consumption by the data transmission system. If you select this option, select a Kafka data source and the corresponding Kafka topic from the drop-down list. Note At present, the data transmission service supports only a self-managed Kafka instance in a VPC as the Kafka data source. If you do not select this option, you cannot select Incremental Synchronization for Migration Type when you create a project to migrate data from a TiDB database to a MySQL tenant of OceanBase Database. TiDB data format When you migrate data from a TiDB database to a MySQL tenant of OceanBase Database, you can select the TiCDC or TiDB Binlog data format from the drop-down list.
	Remarks (Optional)	Additional information about the data source.

Click Test Connection to verify the network connection between the data transmission system and the data source, as well as the validity of the username and password.
After the test is passed, click OK.