Our example began with the addition of a new Db2 Table to the data capture process and publishing 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 Engine DB2TOORA), that will populate a new Oracle table with columns corresponding to a subset of the columns from the SQDATA.dept Db2 source table.
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.