Mapping source and target tables for Adaptive Apply

Procedure

  1. Start Management Console and log into Access Server.
  2. Click Configuration > Subscriptions.
  3. Select a subscription, right-click and select Map Tables.
  4. Select Custom Table Mapping > Adaptive Apply and click Next.
  5. Select the source table from the Source Tables list and click Next.

    If you want to hide columns so that the target is not aware of them, click Filter Columns and clear the check box for the column you want to hide.

  6. Select a table from the Target table list and click Next.
  7. Choose one of the following and click Next:
  8. Choose a replication method from the following and click Next:
    Mirror (Change Data Capture)
    Immediately replicates changes made to the source table to the target table or accumulate source table changes and replicate at a later time. If your configuration requires you to prevent recursive updates when mirroring, enable the Prevent Recursion check box. This check box is only available in components of CDC Replication that support both source and target databases.
    Refresh (Snapshot)
    Replicates a snapshot of the source table to the target table.
  9. If you are replicating source database changes using the CDC Replication Engine for Oracle databases (Trigger edition) and want to use a journal table to mirror database operations from the source to the target table, then enable one of the following:
    Use Default Journal
    Enable when you want the CDC Replication Engine for Oracle databases to use the default journal table provided with the CDC Replication Engine for Oracle databases: <TS SCHEMA>.DMCJRN. CDC Replication uses this journal table to detect and replicate database changes from the source to the target.
    Use Selected Journal
    Enable when you want the CDC Replication Engine for Oracle databases to use another journal table other than the default journal table provided with CDC Replication Engine for Oracle databases. When you select the database owner and provide a name for the journal table, the CDC Replication Engine for Oracle databases creates this new journal table and uses it to detect and replicate database changes from the source to the target.
    Owner
    Lists the database owner of the journal table.
    Name
    Lists the name of the journal table.
  10. Click Next.
  11. Review the mapping summary.
  12. Choose one of the following options and click Finish:
    Define column mappings
    Continues with the column mapping.
    Create a new table mapping
    Allows you to start a new table mapping.
    Return to current view
    Returns you to the current view.