Database support for CDC - 7.1

Change Data Capture (CDC)

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
EnrichPlatform
Talend Administration Center
Talend DQ Portal
Talend Installer
Talend Runtime
Talend Studio

The CDC feature is available for the following databases: AS/400, DB2, Informix, Ingres, MS SQL Server, MySQL, Oracle, PostgreSQL, Sybase, and Teradata. Note that the CDC feature works only with database systems running on the same server.

For more information about setting up a CDC environment, see Setting up a CDC environment.

The following table provides information about the database support for CDC. As explained in the CDC architectural overview, the CDC feature captures the updated data from a Source database and sends the captured data to a Change table, where the Talend Studio Job reads the data from.

Source database

Change table with the same database type as the source

Change table with a different database type from the source

AS/400

Supported

Supported

MySQL

Supported

Supported

Teradata

Supported

Supported

Note: For AS/400, MySQL and Teradata, no schema is involved.

Change table with the same database type as the source

Change table with a different database type from the source

Source database

Same schema (table)

Different schema (table)

Same schema (table)

Different schema (table)

DB2

Supported

Supported

Unsupported

Unsupported

Informix

Supported

Supported

Unsupported

Unsupported

Ingres

Supported

Unsupported

Unsupported

Unsupported

MS SQL Server

Supported

Supported

Supported

Supported

Oracle

Supported

Supported

Unsupported

Unsupported

PostgreSQL

Supported

Supported

Unsupported

Unsupported

Sybase

Supported

Supported

Supported

Supported