Plug-in Overview

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database is an add-on product for TIBCO ActiveMatrix BusinessWorks™. The plug-in supports capturing of change data (insert, update, or delete data) from and merging change data request into a relational database. It also supports submitting one or more SQL statements, stored procedures, and functions, and getting a reply. The plug-in supports JDBC-compliant databases such as Oracle, Microsoft SQL Server, MySQL, IBM DB2 for z/OS, iSeries (AS400), and UDB, PostgreSQL, Amazon RDS for MySQL, Oracle, SQL Server, Microsoft Azure SQL Server, Sybase, and Teradata.

You can perform the following main tasks by using the Data Event Poller activity:

  • Define the schema of a parent table, parent-child table, and a reference table.
  • Select the storage mode, that is, specify how the publishing table stores the event information.
    • Publish by value: All the column information is stored in the stage table.
    • Publish by reference: Only the key values of the changed event are stored in the stage table, and data of other columns is retrieved through the table's join operation.
  • Publish the data of a child table. (The Publish Child Data option).
  • Order the data of the child table in ascending or descending order. (Child Table Order By option).
  • Receive confirmation on event consumption (configured by using the Confirmer activity) and change the record status to completed (C).
  • Specify the maximum number of database records to be published per event to start an ActiveMatrix BusinessWorks™ job. (Record per event option).
  • Specify a Polling Interval and the maximum number of records to be retrieved for each polling when a polling batch is used. (Polling Interval (ms) and Batch Size (Max Rows) options).
  • Improve the performance in a high-load scenario by using load balancing. Load balancing distributes the workload across application nodes.
  • Insert, delete, and update records in the parent and child tables.
  • Republish records with status as failed, scheduled, or pending (Failed (F) Records, Scheduled (S) Records, and Pending (P) Records options).
  • Specify the schema mapping options for design time and runtime (Design Time and Runtime options).
  • Improve the performance of queries by using hints for Oracle and MSSQL databases.

You can perform the following main tasks by using the Data Merger activity:

  • Define the schema of a parent table and a parent-child table.
  • Specify the exception table and the opaque exception table.
  • Specify the child exception table mappings.
  • Specify the precommit stored procedure. (Stored Procedure option).
  • Specify the date-time patterns. (Date, Time, and Timestamp options).
  • Specify the Bulk insert size and batch commit size for handling bulk insertion of data. (“Bulk Insert Size” and “Batch Commit Size” options).
  • Handling of Bulk Insert Error (Handle Bulk Insert Error option).
  • Handle Upsert Operation (Upsert option).
  • Handle Empty String and set to default. (Set Empty String to Default (Oracle) option).
  • Specify the schema mapping options for design time and runtime (Design Time and Runtime options).

You can perform the following main tasks by using the Data Requester activity:

  • Submit and run one or more SQL statements, stored procedures, and functions.
  • Process the requests and return the result as a reply.

These features can be implemented by using:

  • ADB Configuration Shared Resource - The ADB Configuration shared resource uses JDBC Connection shared resource to connect to a database and create XML schema definition (XSD) schema for plug-in operation. The ADB Configuration shared resource is used by the plug-in activities.
  • Data Event Poller - You can use this activity to poll the change in the stage table at a specified interval.
  • Data Merger - You can use this activity to perform insert, delete, update, and upsert operations on the relevant tables in the associated database. The data is then available to other applications that have access to the database.
  • Data Requester - You can use this activity to submit and run one or more SQL statements, stored procedures, and functions. The result is returned as a reply.