Try OpenEdge Now
skip to main content
Managing Change Data Capture in Databases
Managing Change Data Capture in a Database : Enabling Change Data Capture for a database
 

Enabling Change Data Capture for a database

You can enable Change Data Capture (CDC) for a database from the Database Administration Console of OpenEdge Management or from OpenEdge Explorer.
To enable CDC for a database:
1. From the console menu of OpenEdge Management or OpenEdge Explorer, select Database Administration > Go to Database Administration.
The Database Administration page appears.
2. Filter or search for the required database connection and select it.
The database connection home page appears.
3. Scroll through the entries in the Database Features section to see the Change Data Capture status.
If CDC is already enabled for the database, a check mark in a green circle appears in the Status column and the word Enable does not appear in the Action column.
4. Click Enable.
The Enable Change Data Capture page appears.
5. In the Data area field, type a valid area name or click Search to select an area in the Area Selection window.
6. Repeat step 5 to select an area for the Index area field.
Note: For offline databases, search icons for the Data area and the Index area fields are disabled. So while enabling CDC for an offline database, you must enter valid area names and select the required areas.
7. (Optional) Select the Deactivate Index checkbox to create the change tracking table with inactive indexes.
8. Click Enable Change Data Capture.
A message appears confirming that CDC is enabled for the database.
9. Click OK.
The database connection home page appears, and the Change Data Capture status in the Database Features section appears as enabled.