This topic describes how to use the data integration feature of DataWorks to migrate data from Oracle to MaxCompute.
Prerequisites
- The DataWorks environment is ready.
- Activate MaxCompute.
- Create a workspace. In this example, a workspace in basic mode is used.
- A workflow is created in the DataWorks console. For more information, see Create a workflow.
- The Oracle database is ready.
In this example, the Oracle database is installed on an Elastic Compute Service (ECS) instance. The following figure shows the configuration of the ECS instance. To enable network communication, you must configure a public IP address for the ECS instance. In addition, you must configure a security group rule for the ECS instance to ensure that the common port 1521 of the Oracle database is accessible. For more information about how to configure a security group rule for an ECS instance, see Modify security group rules.
As shown in the preceding figure, the type of the ECS instance is ecs.c5.xlarge. The ECS instance resides in a virtual private cloud (VPC) in the China (Hangzhou) region.
Background information
In this example, DataWorks Oracle Reader is used to read test data from the Oracle database. For more information, see Configure Oracle Reader.
Prepare test data in the Oracle database
Use DataWorks to migrate data from the Oracle database to MaxCompute
- Go to the DataStudio page.
- Log on to the DataWorks console.
- In the left-side navigation pane, click Workspaces.
- Select the region where the required workspace resides. Find the required workspace and click Data Analytics.
- On the DataStudio page, create a destination table to receive data migrated from the Oracle database.
- Create an Oracle connection. For more information, see Configure an Oracle connection.
- Create a batch sync node.
- Go to the data analytics page. Right-click the specified workflow and choose .
- In create a node dialog box, enter node name, and click submit.
- After you create the batch sync node, set the Connection parameter to the created Oracle connection and the Table parameter to the Oracle table that you have created. Click Map Fields with the Same Name. Use the default values for other parameters.
- Click
icon to run the code.
- You can operation Log view the results.