Table Reference

When TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) publishes data to or retrieves data from a source or target application, the adapter has to deal with several tables.

The tables are listed as follows:

For details about supported data types, see Supported Data Types.

  • Publishing Table
    Publishing tables mirror tables that you have identified for monitoring. They contain additional columns, primarily a sequence number and delivery status, which are required by the adapter to detect new rows. You can create a publishing table for each table that you want to activate in TIBCO Business Studio.
  • Source Table
    You can insert, update, and delete data in a source table. If loop detection is enabled, the ADB_SOURCE column is added to the source table.
  • Exceptions Table
    If a database restriction or failure occurs, an exceptions table can be configured to receive a message. If insertion into an exception table also fails, an error message is displayed and the adapter configuration is terminated.
  • Child Exceptions Table
    A child exceptions table contains not only columns in a child table, but also additional columns.
  • Opaque Exceptions Table
    An opaque exceptions table records a whole message into a column along with the error message.
  • Incremental Parent-Child Operation
    To support incremental parent-child operations, each child row has an opcode, that is, an extra ADB_OPCODE column that is added to the child schema. The ADB_OPCODE_BYPASS column is used to bypass the current table operation.
  • Supported Data Types
    For TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio), DataDirect database drivers support different data types depending on the database conditions.