How to use Change Data Capture in Oracle (Step 1/4)
Languages available:
Learn how to implement a Change Data Capture (CDC) in Oracle
Data warehousing involves the extraction and transportation of data from one or more databases into a target system or systems for analysis. But this involves the extraction and transportation of huge volumes of data and is very expensive in both resources and time.
The ability to capture only the changed source data and to move it from a source to a target system(s) in real time is known as Change Data Capture (CDC). Capturing changes reduces traffic across a network and thus helps reduce ETL time.
Release Notes: A new type of CDC has been integrated in Talend Integration Suite 3.2.
The new CDC -only available now on Oracle and AS400- is based on the log file. As a consequence, the redo log mode is less intrusive than the Trigger mode, generated by Talend.The DBA will appreciate more this CDC version that the older.
Step 3: Create the DB connections from Talend Studio
Step 1: Create the company's CRM system
Objective: Create a database containing the table Customers.
Create
a new user in Oracle called DATA. To do this, open a Web browser and navigate
to your Oracle administration page. Connect with the system user and click
Home > Administration > Manage Database Users.
Step 3: Create the DB connections from Talend Studio
In the Studio, click Repository > Metadata. Right-click Db Connections and select Create a connection. It opens the Database Connection wizard. In the Name field, type in DATAOracle.
In the Studio, click Repository > Metadata. Right click Db Connections and select Create a connection. It opens the Database Connection wizard. In the Name field, type in CDCOracle.
In the Studio, click Repository > Metadata. Right-click Db Connections and select Create a connection. It opens the Database Connection wizard. In the Name field, type in DWHOracle.
