How to enable/disable Oracle triggers from TDI ?

29 views
Skip to first unread message

DIVYA RAIBAGKAR

unread,
Feb 7, 2022, 6:24:52 AMFeb 7
to
Hi,

Is it possible to handle database triggers from TDI?
I have an Oracle database where I need to enable and disable a trigger based
on certain conditions.

alter trigger "IGACORE"."TRIGGER_NAME" disable;
alter trigger "IGACORE"."TRIGGER_NAME" enable;

Can we do this in UPDATE mode of JDBC Connector ?
Looking forward for a discussion

Thanks

Mark Blakey

unread,
Feb 7, 2022, 12:19:15 PMFeb 7
to
I believe for this use case, the jdbc connector mode doesn't matter, you just need to have an initialized connector then:

thisConnector.execSQL(sql_string)

Inside the override hook probably.

Check out this resource: https://www.stephen-swann.co.uk/javadoc/tdi7.1.1/index.html?com/ibm/di/connector/JDBCConnector.html

Franzw

unread,
Feb 8, 2022, 10:46:58 AMFeb 8
to
I believe this may be what your are looking for : https://www.ibm.com/docs/de/sdi/7.1.1?topic=connectors-rdbms-change-detection-connector#wq650

HTH

Regards
Franz Wolfhagen
Reply all
Reply to author
Forward
0 new messages