Setting up a CDC environment - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

The CDC feature is part of Talend Studio, and you do not need to install any software other than Talend Studio to use CDC.

However, if you want to use CDC in Redo/Archive log mode for an Oracle, you must first of all configure the database so that it generates the redo records that hold all insert, update or delete changes made in datafiles. For further information, see Prerequisites for the Oracle Redo/Archive log mode.

If you want to use CDC in Redo/Archive log mode for AS/400, you must verify that the prerequisites on your AS/400 are all met. For further information, see The prerequisites on AS/400.

Note: For the time being, CDC is only available in Java and is for Oracle, MySQL, DB2, PostgreSQL, Sybase, MS SQL Server, Informix, Ingres, and Teradata in Trigger mode, for Oracle and AS/400 databases in Redo/Archive log mode, and for Oracle in XStream mode.

To set up a CDC environment you must understand the basics involved in designing a Job in Talend Studio, and particularly the definition of metadata items.

When setting up a CDC environment, make sure that the database connection for CDC is on the same server with the source data to which changes are to be captured.

The CDC Foundation feature in the database metadata wizard is not shipped with Talend Studio by default. You need to install it using the Feature Manager. For more information, see Installing features using the Feature Manager.