Database trigger tables

When using a database system as a Source, Cast Iron® Express® requires a trigger table to be created within the database system.

When starting an integration which uses a table in a database for the first time, Cast Iron Express notifies the user that this trigger table needs to be created. An information dialog is displayed containing an explanation of what is required and two links. One link attempts to connect to the database, and automatically creates the trigger table on behalf of the user. To use this method means that the connection details configured in the integration include the required permissions within the database system to create the tables. If the configured user does not have the required permissions, a second link is displayed which makes available a DDL document for creating the required table.

This document link can be passed to the database administrator who can create the required table on behalf of the user.

Restriction: The Cast Iron Express buffer table uses the following field names:
  • IH_PK
  • IH_OPERATION_NAME
  • IH_FLAG
Therefore, these field names are not supported when you create your own table because they clash with the trigger mechanism.



Feedback | Notices


Timestamp icon Last updated: Wednesday, December 16, 2015


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.api.omniapps.doc/DatabaseTriggerTables.html