Getting Started

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

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.

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

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

Note: Before you use the Oracle SQL script, you have to unzip the Demo1.zip file to a local directory.
A basic procedure of using the adapter includes the following tasks:
  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
  10. Removing the tables from a database

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 can use the source table, publishing table, destination table, and exceptions table to exchange data.
  • TIBCO Business Studio Overview
    TIBCO Business Studio is an Eclipse-based integration development environment that is used to design, develop, and test ActiveMatrix BusinessWorks applications.
  • Creating Database Tables
    Before you create a project in TIBCO Business Studio, you must create tables in a database.
  • Creating a Project
    The first task of using the adapter is to create a project. After creating a project, you can create adapter configurations and add services.
  • Creating a Database Connection
    After creating a project, you have to create a database connection to connect an adapter configuration to your database.
  • Creating Adapter Configurations
    After creating a project, you can create adapter configurations to use the database connection to connect to your database. An adapter configuration contains all information required by the runtime adapter.
  • Adding the Database Connection
    After creating the adapter configurations, you can add the database connection for the adapter configurations.
  • Adding Adapter Services
    After configuring adapter configurations, you can add adapter services to communicate with source or target applications.
  • Specifying a Working Directory
    Before you start the adapter configurations, you have to specify a working directory to save the temporary files for the runtime adapter.
  • Starting the Adapter Configurations
    After configuring adapter services and specifying a working directory, you can start the adapter configurations containing these services so that the adapter exchanges data with the database.
  • Changing the Table Values and Receiving a Notification
    After starting the adapter, you can change the values in the source table and test the adapter services.
  • Removing the Tables from a Database
    After running the adapter services and obtaining your test results, you can execute the cleanup script to remove all the example tables that were created by the demo1_databasevendor.sql script.