Change Data Capture for Oracle
NCDC
Next Generation Change Data Capture
Fast, lightweight replication of changed data from Oracle to MS SQL Server in near real time. It carries database structure changes into your data warehouse too.
How it works
Changes in Oracle, straight in your data warehouse
Source
Oracle
Single instance, RAC and Exadata.
NCDC
Change capture
Reads changes through Oracle LogMiner. No GoldenGate needed.
Target
MS SQL Server
Database or data warehouse. Apache Kafka coming soon.
What makes NCDC different
It carries
It carries
structure changes too
When tables change in the source database, NCDC adjusts the target schema to match. Replication keeps running and nobody has to fix anything by hand.
- Table and column changes
- No manual work
- Data warehouses
Why NCDC
01
Fast
30 to 40 thousand rows per second and near real-time replication.
02
Lightweight
Configured through metadata, not by clicking through a GUI. SQL-like filters for tables and rows.
03
Under control
Detailed logging, Windows performance counters and a web interface for monitoring.
Reference
Tipsport runs NCDC on its move to Oracle Exadata.