Database support for CDC - 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 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.

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.

Database support for CDC
Source database Change table with the same database as the source Change table with a different database from the source
AS/400 Supported Supported
MySQL Supported Supported
Teradata Supported Supported
Note: For AS/400, MySQL and Teradata, no schema is involved.
Database and schema compatibility for change tables with the same database as the source
Source database Same schema (table) Different schema (table)
DB2 Supported Supported
Informix Supported Supported
Ingres Supported Unsupported
MS SQL Server Supported Supported
Oracle Supported Supported
PostgreSQL Supported Supported
Sybase Supported Supported
Database and schema compatibility for change tables with a different database from the source
Source database Same schema (table) Different schema (table)
DB2 Unsupported Unsupported
Informix Unsupported Unsupported
Ingres Unsupported Unsupported
MS SQL Server Supported Supported
Oracle Unsupported Unsupported
PostgreSQL Unsupported Unsupported
Sybase Supported Supported