Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
130
Chapter 9 - Database Triggers
Data sources using database adapters can serve as input event triggers that are
defined in the Database Interface Designer, enabled in the Integration Flow
Designer, and executed by an Event Server.
Note For information about the availability and usage of triggering for your specific
database and platform, refer to the database-specific adapter reference guide.
Database Triggers Overview
This introductory section provides information about the following topics:
♦ Database Support
This topic discusses those databases supporting triggering and the types of
triggering supported.
♦ Installation Requirements
This topic discusses the database-specific scripts required to be run to enable
database triggering.
♦ Tables Created for Triggering
This topic discusses the four tables created as a result of running the
installation scripts for triggering.
♦ Maintaining Triggering Tables
This topic discusses table maintenance required in unusual situations such as
unexpected shutdown of Event Servers and working with truncated tables.
Database Support
The event(s) that occur causing a trigger to run a map may be the result of a map
or some other application.
The following databases support triggering:
♦ Oracle 8 client or above and Oracle 8 server or above (for Windows and UNIX)
♦ Microsoft SQL Server 7.0 and above (for Windows only)