1 / 5

Oracle CDC

Ready-to-use data delivered to Amazon S3, Amazon Redshift, and Snowflake at lightning speeds with BryteFlow data management tool. This automated tool is completely self-service, low on maintenance and requires no coding. It can integrate data from any API and legacy databases like SAP, Oracle, SQL Server, and MSQL.

michalSmitth84
Download Presentation

Oracle CDC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How Does Change Data Capture Work in Oracle Databases

  2. Before understanding the mechanism of how Change Data Capture (CDC) works on Oracle databases, it is necessary to understand first the concept of CDC and why it is so critical in the modern business environment.  In any organization today, changes in the form of inserts, updates, and deletes are continually made to databases. These changes have to be necessarily recorded and maintained for optimal data analysis whenever required. This is what Change Data Capture or CDC is all about. The focus of CDC regardless of whether it is database Oracle CDCor Microsoft SQL Server CDC is to make sure that all the data of a specific business is continually kept synchronized so that the need for ETL process is minimized. 

  3. All changes in databases to any table are recorded by the CDC and kept available in a relational user-friendly format. Column information as well as metadata that are necessary to make the changes at a target source after loading or migration are captured for the modified rows and stored in change tables. These tracks all details of the column structure and hence CDC offers table-valued functions that permit access to changed data.

  4. The point to consider now is how to use this CDC tool that is in-built in the Oracle Data Integrator to monitor the changes to the data and thereafter process the changes in the integration flows in Oracle CDC. • With the help of Oracle Data Integrator, Oracle CDCtracks changes in the source data from every application. This is feasible simply because the Oracle Data Integrator can bypass the mechanism of processing unchanged data whenever the integration interfaces are run.  • In data synchronization, replication, or migration, there are several benefits of restricting the flow of data from source to changed data only. One is setting up an event-oriented architecture for integration where changes to data are made at the time of executing business processes by applications. These changes are transformed by the Oracle Data Integrator in Oracle CDC into specific events which are then circulated to all the information systems and databases.  • What is the Oracle CDCmechanism? • It is carried out by setting up infrastructure and journalizing models to capture the changes made to the existing databases. The Oracle Data Integrator supports two journalizing models. • The first is the Simple Journalizing model. Here all changes in the individual data stores in a model are tracked. Next is the Consistent Set Journalizing model. In this model, changes to the data stores in the group are tracked to ensure the referential integrity of the data stores. Only the Consistent Set group of data stores is journalized.  • Setting up the mechanism to run Oracle CDCon the Oracle Data Integrator is not complex. From setting up the CDC parameters in the data model to starting the journals, the whole process is automated and can be completed without human intervention. 

More Related