Oracle change data capture (CDC) was first launched with the 9i version as an in-built tool of the Oracle database. It was a tool that recorded and monitored all changes made in the user tables in a database. These changes were then stored in change tables and used in ETL applications for later processing and transferring to other data warehouses and databases.
The release version of Oracle change data capture had
triggers placed in the source database. However, database administrators found
this technology very invasive and did not favor it. Ultimately, Oracle changed
the Oracle change data capture technology and released it with the 10g
version after naming it Oracle Streams.
The working of this release was different. Oracle
change data capture used the redo logs of the source database along with a
replication tool of Oracle Streams. This technology turned out to be very
successful and a highly optimized method to identify and move change data to a
target database without affecting the speed or performance of the source
database. Further, during replication, the source database functions without a
break, saving organizations from having to shut down their systems.
Surprisingly, even though this form of Oracle
change data capture became very popular and was well-received by users,
Oracle Corporation decided to discontinue it from the 12c version which no
longer supported the tool. Users had two options now, either seek other CDC
solutions or pay for Oracle GoldenGatewhich offered the Oracle change data
capture feature out of the box.
Oracle CDChelps businesses running on Oracle
database to lower data warehousing costs while improving efficiencies.
Comments
Post a Comment