Set the trigger-based capture - Connect_CDC - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

To switch from log-based capture to trigger-based capture, do the following:

  1. In the omnient.ini file, set the trigger flag to 1 in the following line:

    OracleCaptureTriggersOnly=1
  2. Shut down and restart the Connect CDC Director.

  3. Commit the model. Warning messages display that inform you to disable the logon and logoff trigger before updating the model in the Connect CDC MonCon or Connece CDC Console. You can disregard the warning and update the model before you disable the logon and logoff trigger.

  4. Update the model.

  5. Disable the logon and logoff trigger by running the following commands in the Connect CDC Director SQL window as user sys:

alter trigger sys.rp_logon_trg disable
alter trigger sys.rp_logoff_trg disable