TIBCO ActiveMatrix® Adapter for Database (TIBCO Business Studio™)
Software Release 1.2
April 2015
Home
Previous topic
Next topic
Contents
Search Results
User's Guide
Important Information
TIBCO Documentation and Support Services
Product Overview
Getting Started
TIBCO Business Studio Overview
Creating Database Tables
Creating a Project
Creating a Database Connection
Creating Adapter Configurations
Adding the Database Connection
Adding Adapter Services
Specifying a Working Directory
Starting the Adapter Configurations
Changing the Table Values and Receiving a Notification
Working with an Adapter Configuration
Creating an Adapter Configuration
Configuring an Adapter Configuration
Validating an Adapter Configuration
Testing an Adapter Configuration
Working with Adapter Services
Creating an Adapter Service
Using Create Service Wizard to Create a Service
Configuring an Adapter Service
Adapter Configuration Reference
Configuration Tab
Guidelines for Choosing an Instance ID
New Connection Information
Adapter Services Tab
Transports Tab
Logging Tab
Log Level Panel
Supported Log Sinks and Roles
Log Sink Configuration Reference
Monitoring Tab
Advisories Tab
Advanced Tab
Sessions and Endpoints
Sessions for the TIBCO Rendezvous Transport Type
Sessions for the JMS Transport Type
Session Reference
Rendezvous Sessions
JMS Sessions
Endpoint Reference
Publisher Endpoint Reference
Subscriber Endpoint Reference
Server Endpoint Reference
Adapter Service Reference
Adapter Service--Configuration Tab
Transport Options
Guideline for Configuring the Wire Format
Guideline for Configuring the Delivery Mode (JMS Only)
Class Reference
Schema Tab
Child Tables
Publication Options Tab
DB2/390 Options Tab
DB2/AS400 Options Tab
Subscription Options Tab
Child Table Mappings Tab
Child Exception Table Mappings Tab
Request-Response Options Tab
Working with Schemas
Adding a Destination
Fetching Tables or Stored Procedures
Fetching Tables
Fetching Child Tables
Fetching Stored Procedures
Referencing an External Schema
Replicating Schema Information
Working with BusinessWorks Processes
Creating a Business Process
Testing a Specified BusinessWorks Process
Testing Multiple BusinessWorks Processes in Multiple Applications
Activities for Communicating with Adapter Services
Handling the anyType AE Data Type
Migrating an Adapter Project Created in TIBCO Designer
Calling a Process that Uses the Start Activity
Configuring Publication Service
Specifying a Schema for Publication Service
Specifying Child Tables for Publication Service
Adding Child Tables
Specifying the Relationship Between the Parent and Child Tables
Specifying a Publishing Table
Publishing Table Reference
Implementing Incremental Parent-Child Operation
Specifying a Polling Method
Alerter
Setting Up an Alerter
Before Starting an Alerter
Starting an Alerter
Example for Starting an Oracle Alerter
Example for Starting a Microsoft SQL Server Alerter
Selecting a Storage Mode
Using Publish by Reference Object
Specifying a Reference Object
Adding an Association
Adding a Sequence
Enabling Loop Detection
Source Table
Configuring Subscription Service
Specifying a Schema for Subscription Service
Specifying Child Tables for Subscription Service
Setting Up the Mapping Relationship Between Child Tables
Specifying a Child Exceptions Table
Restrictions of Subscribed Columns
Handling Exceptions
Specifying an Exceptions Table
Using an Exceptions Table as a Source Table
Specifying an Opaque Exceptions Table
Exceptions Table Reference
Child Exceptions Table Reference
Opaque Exceptions Table Reference
Specifying a Precommit Stored Procedure Call
Configuring a Subscriber Replying Sender
Adding NUMBER_OF_UPDATED_ROW After Migration
Configuring Request-Response Service
Selecting a Service Mode
Requests
Responses
Using Request-Reply Mode
Using RPC Mode
Standard RPC Operation
Custom RPC Operation
Using Quotes in a Request with Microsoft SQL Server Databases
Using the REF Data Type with Oracle Databases
Performance Tuning
Multithreading
Multithreading and Session in Request-Response Service
Multithreading and Session in Subscription Service
Multithreading and Tables for Subscription Service
Load Balancing
Load Balancing in Publication Service
Creating an Adapter for Database Connection
Creating an Adapter Configuration for Publication Service
Adding a Service of Publication Service
Configuring Load Balancing for Publication Service
Load Balancing in Subscription Service and Request-Response Service
Example for Configuring Load Balancing in Subscription Service
Creating an Adapter Configuration for Subscription Service
Adding a Service of Subscription Service
Configuring Load Balancing for Subscription Service
Example for Configuring Load Balancing in Custom RPC Service
Batch Processing
Batch Processing in Publication Service
Batch Processing in Subscription Service
Using Hints (Publication Service Only)
Advanced Topics
Handling Passwords
Subject and Destination Names
Preregistering a Certified Subscriber
Preregistering in TIBCO Business Studio
Setting Preregistered Listeners in TRA Properties File
Changing the Location of the Ledger File
Configuring in TIBCO Business Studio
Modifying the TRA Properties File
Sending DateTime Data to an Adapter Configuration
Using the User Callout Java Library
Adding a User Library in a Project
Adding a Java Package and Class
Using the adbPreCommit Function
Using the alterMsgPub() and alterMsgSub() Functions
Exporting the JAR File
Replacing the Original JAR File
Using Database Deployment and Cleanup Scripts
OS Authentication
Runtime Schema
Runtime Table Schema Configuration
Specifying Query Timeout
Compressing JMS Messages
Configuring RVCMQ Backlog Size
Implementing Refresh Connection
Error Handling by Subscription Service
Prerequisites of Using Bulk Insert Error Handling
Working with Bulk Insert Error Handling
Using Opcodes to Set Operations for Subscription Service
Frequently Asked Questions
General Questions and Answers
Request-Response Service Questions and Answers
Supported Data Types
DB2
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
Sybase and Sybase Adaptive Server Anywhere
Teradata
Using Module Properties
Configuring Module Properties
Defining a Module Property with a Combined Value
Predefined Module Properties
Adapter Properties File
Adapter Properties
Trace Messages
Trace Message Examples
Trace Message Fields
Trace Messages Reference
Adapter Microagents and Methods
Adapter Microagents
Available TIBCO Hawk Methods
getEventQueueSize()
setDebugLevel()
toggleVerboseFlag()
showConfiguration()
terminateADBagent()
getPollingInterval()
setPollingInterval()
getPollingBatchSize()
setPollingBatchSize()
getActivityStatistics()
getActivityStatisticsByService
getActivityStatisticsByOperation()
getThreadStatistics()
getQueueStatistics()
getConnectionStatistics()
resetActivityStatistics()
resetThreadStatistics()
resetConnectionStatistics()
Examples
Important Information
TIBCO Documentation and Support Services
Examples Overview
Prerequisites for Running Examples
Converting a DAT File to a Multi-File Project
Migrating Examples to TIBCO Business Studio
Calling a Process for a BusinessWorks 5 Example
Importing Examples to TIBCO Business Studio
Required Software
Starting the EMS Server
Working Through the Demo1 Example
Creating the Demo Tables
Specifying a Working Directory
Updating the Database Connection
Starting the Adapter Configurations
Inserting Data into the Source Table
Cleaning up the Database
Working Through the Operations Example
Sample Request Program
Creating the Demo Tables
Starting the Adapter
Testing the Example
Testing the RPC Standard Operation
Testing the RPC Custom Operation
Testing the Request-Reply Operation
Cleaning up the Example
Working Through the SalesOrder Example
Creating the Demo Tables
Starting the Adapter
Testing the Example
Cleaning up the Example
Installation
Important Information
TIBCO Documentation and Support Services
Installation Overview
Installation Modes
Installation Environment
Installation Components
Installation Requirements
Installation Account
System Requirements
Preinstallation Tasks
Installation
Installing in GUI Mode
Installing in Console Mode
Installing in Silent Mode
Uninstallation
Uninstalling in GUI Mode
Uninstalling in Console Mode
Installation Logging
No search has been performed.
