Change Data Capture component

Overview

The Change Data Capture component contains the tools needed to initiate Change Data Capture (CDC) mechanisms on various technologies.

Install the Change Data Capture component

If you did not install it yet, install the Change Data Capture component in Designer by following the component installation process.

Supported technologies

The Change Data Capture Component has the necessary tools for the following technologies.

Technology

Description

DB2/400

Change Data Capture with DB2/400. See Getting started with DB2/400 databases.

HSQL

Change Data Capture with HSQL.

Informix

Change Data Capture with Informix.

Microsoft SQL Server

Change Data Capture with Microsoft SQL Server.

MySQL

Change Data Capture with MySQL.

Oracle

Change Data Capture with Oracle.

When using any other option than the triggers to capture the changes, please check that your Oracle licence includes the underlying features used by the template to avoid activating an undesirable option.

PostgreSQL

Change Data Capture with PostgreSQL.

Teradata

Change Data Capture with Teradata.