Prepare client platform - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last edition
2024-09-05
Last publish date
2024-09-05T15:00:09.754973

The Oracle Capture Agent is generally installed on a separate platform from the Database itself simply because the Oracle DBA's will not permit third party software to be installed on the Oracle database server platform. Connect CDC SQData supports remote capture of Oracle from any platform with properly installed Oracle SQL*Net client software.

Install the Oracle SQL*Net client and configure the tnsnames.ora file to support connections to the database to be captured using Oracle's documentation for that process.

Note: Enabling change data capture will increase the amount of data written to the Oracle recovery log on the database platform for each update to the source data table. Depending on the size of the tables and the volume of updates made to the table, the size of the active Oracle logs may have to be adjusted to accommodate the increase data.