Getting Started

This tutorial is designed for users who want to use TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio).

All the operations are processed in TIBCO Business Studio. See TIBCO Business Studio Overview to get familiar with TIBCO Business Studio.

A basic procedure of using the adapter includes the following:
  1. Creating database tables
  2. Creating a project
  3. Creating a database connection
  4. Creating adapter configurations
  5. Adding the database connection
  6. Adding Adapter Services
  7. Specifying a working directory
  8. Starting the adapter configurations
  9. Changing the Table Values and Receiving a Notification

This tutorial emulates the configurations of the Demo1Oracle project in the TIB_ADADB_HOME\demo\bw6\Demo1 directory and uses the Oracle SQL script in this directory to create database tables. In addition, this tutorial describes how to connect the adapter to an Oracle database.

Note: Before you use the Oracle SQL script, you have to unzip the Demo1.zip file to a local directory.

After doing this exercise, you will know how to create tables in your database, create a project, adapter configurations, and adapter services, and insert data into the source table and receive a notification.

Tables and Data Flow

In this tutorial, you have to deal with the following tables to exchange data:
  • Source table
  • 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 create a publishing table for each table you want to activate using TIBCO Business Studio.
  • Destination table
  • Exceptions table: if a database restriction or failure occurs, an exception 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.
When you insert, update, or delete data in the source table, the following actions occur:
  • For Publication Service, when data changes in the source table, if you set Publish by Value as the storage mode, the insert, update, delete, and upsert operations fire a trigger and the inserted row is copied to the publishing table. If you set Publish by Reference as the storage mode, only the rows inserted in the primary key column and the user-defined key column can be copied to the publishing table.
  • The publisher adapter polls the publishing table to check if any new row has been inserted. Newly inserted rows are fetched by using JDBC, packed into a message, and published.
  • The subscriber adapter listens for messages. When a message is received, the subscriber adapter inserts a row or delete it in the destination table by using JDBC.

The following figure illustrates the actions:

Required Platform and Software

You can perform this exercise on any supported operating system, with the JMS transport type. The databases you can use with the example include Oracle, Microsoft SQL, and DB2 databases. This tutorial describes how to run the example on an Oracle database from a Windows platform.

Contents
Search Results