Database support for CDC - 6.5

Talend Data Fabric Studio User Guide

EnrichVersion
6.5
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation
Design and Development
EnrichPlatform
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 the same database system 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

Not Supported

Not Supported

Informix

Supported

Supported

Not Supported

Not Supported

Ingres

Supported

Not Supported

Not Supported

Not Supported

MS SQL Server

Supported

Supported

Supported

Supported

Oracle

Supported

Supported

Not Supported

Not Supported

PostgreSQL

Supported

Supported

Not Supported

Not Supported

Sybase

Supported

Supported

Supported

Supported