About this task
To retrieve modified data, define the connection between CDC and data:
Procedure
-
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
box.
-
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.
Results
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.