Add subscription to LogMiner capture - 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

One or more output Datastores, also referred to as Subscriptions, may be specified for each table in the configuration file. Once the initial configuration file has been created, Datastores can be added or removed using the SQDCONF modify command.

The following example adds a subscription for a second Target Engine (ORATOSQL) for changes to the sqdata.dept table.
$ sqdconf modify /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab
 --key=<sqdata.dept> --datastore=cdc:////ORATOSQL --active
Note:
  • A modify must be performed for each source table that will be published to the new Engine.
  • The configuration file changes must be followed by an apply in order to have the capture agent recognize the updated configuration file.