Use DataWorks batch sync nodes to load data from relational databases into Hologres for high-concurrency, low-latency query and analysis.
Prerequisites
Before you begin, ensure that you have:
-
An active DataWorks instance — see Get started
-
A Hologres instance attached to a DataWorks workspace — see Attach a Hologres instance
-
The source database activated and accessible
For cross-region data synchronization, see Network connectivity solutions.
Supported source databases
Batch sync supports RDS for MySQL, Oracle, PolarDB, and SQL Server. For the full list, see Supported data sources and read/write plug-ins.
Connector references: MySQL Reader, Oracle Reader, PolarDB Reader, SQL Server Reader, Hologres Writer
Synchronize data
Step 1: Configure data sources
Configure both a source database data source and the Hologres data source before creating a sync task.
Configure the source database. Select the guide for your database type and follow the steps to complete the configuration:
-
For other databases, see Configure a data source.
Configure the Hologres data source. See Configure a Hologres data source.
Step 2: Configure a sync task
Create a sync task to transfer data from the source database to Hologres. Two configuration methods are available:
| Method | Best for |
|---|---|
| Codeless UI | Most users — configure the task visually without writing JSON scripts. Configure a task in the codeless UI |
| Code Editor | Advanced users who need fine-grained control via JSON scripts. Configure a task in the code editor |
Step 3: Query synchronized data
After the sync task completes, run queries against the synchronized data in Hologres:
SELECT * FROM rds_test;