Before you create a data migration or synchronization project, you must create the data sources. This topic describes how to create an Oracle data source by using the data transmission service.
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 Oracle 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.
Instance type
Parameter
Description
Self-Managed Database in VPC
VPC
Select the desired virtual private cloud (VPC) from the VPC drop-down list.
Host IP Address
The IP address of the host where the database is located.
Port
The port number of the host where the database is located.
Database Gateway
Gateway Name
Select the name of the destination database gateway from the Gateway Name drop-down list.
Database Instance
Select the destination database instance from the Database Instance drop-down list.
Self-Managed Database with Public IP Address
Host IP Address
The IP address of the host where the database is located.
Port
The port number of the host where the database is located.
Common parameters
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.
ImportantThis parameter is not displayed when Self-Managed Database with Public IP Address is selected as the instance type.
Service Name
The service name of the Oracle database.
Username
The username of the Oracle database for data migration or synchronization.
We recommend that you create a dedicated database user for the migration or synchronization project.
Password
The password of the database user.
Schema Name
The schema name of the Oracle database.
NoteIf you specify this parameter for the source data source, you can select the objects to migrate or synchronize only from the specified schema.
If you do not specify this parameter, all schemas on which you have the read privilege can be migrated or synchronized.
Remarks
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.