Send existing UDB data to new target - 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 updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

Our example began with the addition of a new UDB Table to the data capture process and sending the captured data to an existing Engine. Often however, a change results from recognition that a new downstream process or application can benefit from the ability to capture changes to existing data. Whether the scenario is event processing or some form of Straight replication the implementation process is essentially the same.

Our example continues with the addition of a new Integration Engine UDBTOORA that will populate relational tables with columns corresponding to one or more fields from the same UDB source. The new Integration Engine will be running on a second platform, not previously used by an SQData Agent and will be updating Oracle tables.

While no changes are required to the Storage agent to support the new Engine, the Capture agent will require configuration changes and the new Engine must be added.