Oracle to Tablestore Real-Time Sync
Alibaba Cloud Tablestore is a serverless table storage service designed for handling large volumes of structured data. It also provides a comprehensive solution for IoT scenarios, offering optimized data storage capabilities. TapData enables real-time synchronization of Oracle data to Tablestore, providing seamless data flow and facilitating easy adaptation to data architecture changes and big data analysis scenarios.
Prerequisites
Before you create a replication task, make sure you have configured the relevant data source:
Also note the reference data type support.
Configure Task
Based on the product type, select the operation entry:
- TapData Cloud: In the left navigation panel, click Data Replications.
- TapData Enterprise: In the left navigation panel, choose Data Pipelines > Replications.
On the right side of the page, click Create to configure the task.
Drag and drop the Oracle and Tablestore data sources from the left side of the page onto the right canvas. Once they are placed, you can connect them by drawing a line or arrow between the two data sources.
Click on the Oracle data source, choose the desired table in the right panel, and then click on the Tablestore data source to view the synchronized data structure.
tipSince the number of columns in a single table in Tablestore cannot exceed 32, if the number of columns in the Oracle tables to be synchronized exceeds 32, you can address this limitation by adding a Field Edit node between the Oracle and Tablestore data sources. This node allows you to handle the situation and selectively exclude business-independent columns from the synchronization process. For more information, see Processing Node.
After confirming the configuration is correct, click Start.
After the operation is completed, you can observe the performance of the task on the current page, such as RPS (Records Per Second), delay, task time statistics, etc.
Task Management
On the Task List page, you can also start, stop, monitor, edit, copy, reset, and delete tasks.
For more information, See Management Tasks.