TIBCO ActiveMatrix® Adapter for Database (TIBCO Business Studio™) User's Guide

Software Release 1.3

April 2016

  • Important Information
  • TIBCO Documentation and Support Services
  • Product Overview
    TIBCO ActiveMatrix® Adapter for Database (TIBCO Business Studio™) provides a design-time environment to configure adapter configurations, Publication Service, Subscription Service, Request-Response Service, and schemas in TIBCO Business Studio.
  • Getting Started
    This tutorial is designed for beginners who want to use TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio).
  • Working with an Adapter Configuration
    An adapter configuration in a project contains all information required by the runtime adapter. Each adapter configuration must have its corresponding resources configured.
  • Adapter Configuration Reference
    The Adapter Configuration editor is a form-based editor split into several tabs. Each tab contains one type of resource and has one or more configuration sections that are presented in panels. You can use these tabs to configure an adapter configuration.
  • Creating and Configuring Publication Service
    When running as a publisher, the adapter extracts data in the changed rows from database tables and publishes them on appropriate subject names. You can create Publication Service and then configure the service by using the adapter service tabs.
  • Creating and Configuring Subscription Service
    When running as a subscriber, the adapter listens on a subject, receives messages, and updates the relevant tables in its associated database. The data is then available to other applications that have access to the database.
  • Creating and Configuring Request-Response Service
    Request-Response Service often acts as a Request Reply server or Remote Procedural Call (RPC) server. When running Request-Response Service, the adapter receives requests from other applications, parses them, and translates them into queries to the database to retrieve data. The output data is wrapped in an MInstance and sent back to the caller.
  • Adapter Service Reference
    After you create an adapter service, the adapter service configuration resources are displayed in the right panel of the Adapter Services tab. These resources are divided into different tabs for you to customize your adapter service.
  • Working with Parent-Child Table Relationships
    Data models typically contain tables that share column data through a relationship. You can configure a publishing table to include related data from another table for publication. Data from the related table is not copied to the publishing table, but is fetched by reference.
  • Working with Schema Browser
    TIBCO adapters use schemas to manage data that is retrieved from and exported to a source or target application. You can use the Schema Browser view provided by TIBCO ActiveMatrix Adapter Framework to add and manage schemas.
  • 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.
  • Working with BusinessWorks Processes
    Processes in TIBCO ActiveMatrix BusinessWorks capture and manage the flow of business information in an enterprise between different data sources and destinations. The Adapter palette installed with TIBCO ActiveMatrix Adapter Framework provides activities for wiring adapter services into processes.
  • Migrating an Adapter Project Created in TIBCO Designer
    You can migrate an adapter project from TIBCO Designer with TIBCO ActiveMatrix BusinessWorks 5.x to TIBCO Business Studio with TIBCO ActiveMatrix BusinessWorks 6.x by using the migration tool in TIBCO Business Studio.
  • Working with an Alerter
    An alerter is used to asynchronously notify Publication Service of database changes. When an alerter is used, the adapter does not poll its publishing table for new rows at every interval. You can use an alerter when database changes are infrequent.
  • Multithreading
    Using multiple threads, an application can simultaneously process multiple and independent events. TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) supports multithreading to efficiently handle requests and increase the response speed of the system.
  • Advanced Operations
    In addition to the common configurations of the adapter, such as creating a project, creating and configuring adapter configurations, and adding and configuring adapter services, you can perform advanced configurations for the adapter.
  • Frequently Asked Questions
    When you configure and deploy the adapter project, possibly you encounter some problems. Those frequently asked questions are listed and their answers are provided to facilitate your configuration and deployment. The frequently asked questions involve both general questions and Request-Response Service questions.
  • Using Module Properties
    When you configure a project, you can use module properties. Module properties provide an easy way to set default values for use throughout your project. You can use the variable substitution mechanism to replace the input values in a project with the values of predefined module properties.
  • Adapter Properties File
    The runtime adapter parses one or more properties files at startup. The default properties file for TIBCO ActiveMatrix Adapter for Database is the adbagent.tra file, which is located in the TIB_ADADB_HOME\bin subdirectory. The runtime adapter provides a template TRA file for each properties file when the actual properties file is corrupted or deleted by mistake.
  • Trace Messages
    Trace messages provide information about adapter activities. The messages are logged to the console where the runtime adapter is started and to a log file. Trace messages can also be redirected to the TIBCO Hawk Display application, or sent to other applications using the TIBCO Rendezvous transport type.
  • Adapter Microagents and Methods
    TIBCO Hawk provides microagents and methods to supplement the monitoring information provided by the standard logging levels capability. These microagents and methods help monitor and debug the adapter.