About this task
To retrieve modified data, define the connection between CDC and data:
Right-click the relevant CDC
Foundation folder and proceed to connect to the Oracle
database to be monitored.
Select Create CDC to open the
[Create Change Data Capture] dialog
- Click the three-dot button next to the Set Link Connection field to select the connection that corresponds to CDC. Then define the user for Oracle - publisher in this example. This user will create the change tables that store modifications and will activate change captures for the source table.
- In the Options area, select Log mode as the option for capturing changes.
Click Create Subscriber. The
[Create Subscriber and Execute SQL
Script] dialog box appears.
- Click Execute and then Close to close the dialog box.
- Click Finish in the [Create Change Data Capture] dialog box.
In the CDC Foundation folder, the subscription table schema appears. An icon also appears to show that the change capture for the source table is activated.