An Oracle Change Data Capture (CDC) reader synchronizes data through the trigger created in the Oracle database. You must activate the Oracle CDC service.

Create an Oracle CDC reader

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Analytics in the Actions column.
  2. On the Data Analytics tab, move the pointer over the Create a sync node icon and choose Data Integration > Real-Time Sync.

    You can also find the target workflow, right-click Data Integration, and choose Create > Real-Time Sync.

  3. In the Create Node dialog box that appears, set Node Name and Location, and then click Commit.
  4. On the configuration tab of the real-time sync node, drag Oracle CDC under Reader to the editing panel.
  5. Click the Oracle CDC node and set parameters in the Node Settings section.
    Parameter Description
    Connection The connection to the Oracle CDC data store. In this example, you can only select an Oracle CDC connection.

    If no connection is available, click Add Connection on the right to create one on the Workspace Manage > Data Source page.

    Table The name of the table from which data is read in the Oracle database. You can click Preview on the right to preview the selected table.
    Start Offset The start time of the sync node.
    Time Zone The time zone where the Oracle database resides.
    Output Fields The fields from which data is read.
  6. Click Save the settings in the toolbar.