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 (UDBTOORA) for changes to the sqdata.dept table.
$ sqdconf modify /<SQDATA_VAR_DIR>/udbcdc/udbcdc.cab
--key=sqdata.dept
--datastore=cdc:////UDBTOORA --active Notes:
- 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.