Installation
TIBCO Documentation and Support Services
Installation Overview
Installation Requirements
Installation Account
System Requirements
Prerequisites for Adapter to Plug-In Migration
Using TIBCO Universal Installer
Installer Overview
Installation Modes
Installation Environment
Installation Components
Installation
Installing in GUI Mode
Installing in Console Mode
Installing in Silent Mode
Uninstallation
Uninstalling in GUI Mode
Uninstalling in Console Mode
Uninstalling in Silent Mode
Using Update Site
Installing the Plug-in Using a Public Update Site
Installing the Plug-in Using a Local Update Site or Directory
Uninstalling the Plug-in
Installation Logging
Adding the Database Plug-in to TIBCO BusinessWorks Container Edition
Legal and Third-Party Notices
User's Guide
Plug-in Overview
Comparison between Adapter and Plug-In
Getting Started
Creating a Project
Creating a JDBC Connection Shared Resource
Creating an ADB Configuration Shared Resource
Configuring a Process
Testing a Process
Debugging and Running a Process
Deploying Applications
Generating an EAR File
ADB Configuration Shared Resource
User Interface Elements of the ADB Configuration Shared Resource
DBPoller Schema
DBMerger Schema
DBRequester Schema
Creating a Schema by Using the ADB Configuration Shared Resource
Table Reference
Publishing Table
Child Table
Exception Table
Using an Exception Table as a Source Table
Child Exception Table
Opaque Exception Table
ADB Palette
Data Event Poller Activity
Data Merger Activity
Data Merger Precommit Stored Procedure Call
Data Requester Activity
Migration
Migrating Adapter Projects Created on ActiveMatrix BusinessWorks 5.x to Plug-In Projects
Migrating Projects from Adapter to Plug-In
Migrating Active Database Adapter Configuration to JDBC Connection Resource and ADB Configuration Resource in the Plug-In
Migrating Projects with Adapter Subscriber Activity and Publication Service
Adapter Subscriber Activity Fields Not Supported for Migration
Publication Service Fields Not Supported for Migration
Migrating Projects with Publish to Adapter Activity and Subscription Service
Publish to Adapter Activity Fields Not Supported for Migration
Subscription Service Fields Not Supported for Migration
Migrating Projects with Publish to Adapter Activity and Request-Response Service
Publish to Adapter Activity Fields Not Supported for Migration
Request-Response Service Fields Not Supported for Migration
Migrating Projects with Invoke an Adapter Request-Response Server Activity and Request-Response Service
Invoke an Adapter Request-Response Server Activity Fields Not Supported for Migration
Request-Response Service Fields Not Supported for Migration
Working with the Preference File (JSON) for Migration
Migrating Adapter Projects Created on ActiveMatrix BusinessWorks 6.x to Plug-In Projects
Migrating Projects from Adapter to Plug-In
Migrating Active Database Adapter Configuration to JDBC Connection Resource and ADB Configuration Resource in the Plug-In
Migrating Projects with Adapter Subscriber Activity and Publication Service
Adapter Subscriber Activity Fields Not Supported for Migration
Publication Service Fields Not Supported for Migration
Migrating Projects with Publish to Adapter Activity and Subscription Service
Publish to Adapter Activity Fields Not Supported for Migration
Subscription Service Fields Not Supported for Migration
Migrating Projects with Publish to Adapter Activity and Request-Response Service
Publish to Adapter Activity Fields Not Supported for Migration
Request-Response Service Fields Not Supported for Migration
Migrating Projects with Invoke an Adapter Request-Response Server Activity and Request-Response Service
Invoke an Adapter Request-Response Server Activity Fields Not Supported for Migration
Request-Response Service Fields Not Supported for Migration
Working with the Preference File (JSON) for Migration
Advanced Topics
Output Mapping
Mapping Adapter Datatype to Plug-in XSD Type
Mapping DB2 Datatype to XSD Type
Mapping Microsoft SQL Server Datatype to XSD Type
Mapping MySQL Datatype to XSD Type
Mapping MySQL Server RDS Datatype to XSD Type
Mapping Oracle Datatype to XSD Type
Mapping PostgreSQL Datatype to XSD Type
Mapping Sybase Datatype to XSD Type
Mapping Teradata Datatype to XSD Type
Fault Tolerance
Load Balancing
Enabling Load Balancing
Disabling Load Balancing
Unlocking the MUTEX Table
Viewing Client Information Details
Refactoring a Project
Error Handling by Data Merger Activity
Normal Error Handling
Bulk Insert Error Handling and Applicable Restrictions
How Records are Handled by the Bulk Insert Error Handling Feature
Upsert Operation on Parent-Child Tables
Entity Naming Conventions
Configuring Sybase Database by Using Custom JDBC Driver
Configuring Teradata Database by Using Custom JDBC Driver
Deploying an Application with Teradata Database Through CLI
Hints Usage
Log Management
Setting Up Log Levels
Exporting Logs to a File
Error Codes
Examples
Examples Overview
Importing a Sample Project
Migrating a Sample Project
Data Event Poller Projects
Data Event Poller: Parent Projects
Data Event Poller: DB2UDBParent Project
Data Event Poller DB2UDBParent: Setting Up the Project
Data Event Poller DB2UDBParent: Running the Project
Data Event Poller: MSSQLServerParent Project
Data Event Poller MSSQLServerParent: Setting Up the Project
Data Event Poller MSSQLServerParent: Running the Project
Data Event Poller: OracleParent Project
Data Event Poller OracleParent: Setting Up the Project
Data Event Poller OracleParent: Running the Project
Data Event Poller: ParentChild Project
Data Event Poller: DB2ParentChild Project
Data Event Poller DB2UDBParentChild: Setting Up the Project
Data Event Poller DB2UDBParentChild: Running the Project
Data Event Poller: MSSQLServerParentChild Project
Data Event Poller MSSQLServerParentChild: Setting Up the Project
Data Event Poller MSSQLServerParentChild: Running the Project
Data Event Poller: OracleParentChild Project
Data Event Poller OracleParentChild: Setting Up the Project
Data Event Poller OracleParentChild: Running the Project
Data Event Poller: PublishByReference Project
Data Event Poller: DB2UDBPublishByReference Project
Data Event Poller DB2UDBPublishByReference: Setting Up the Project
Data Event Poller DB2UDBPublishByReference: Running the Project
Data Event Poller: MSSQLPublishByReference Project
Data Event Poller MSSQLServerPublishByReference: Setting Up the Project
Data Event Poller MSSQLServerPublishByReference: Running the Project
Data Event Poller: OraclePublishByReference Project
Data Event Poller OraclePublishByReference: Setting Up the Project
Data Event Poller OraclePublishByReference: Running the Project
Data Merger Projects
Data Merger: Parent Projects
Data Merger: DB2UDBDataMergerParent Process
Data Merger DB2UDBParent: Setting Up the Project
Data Merger DB2UDBParent: Running the Project
Data Merger: MSSQLServerDataMergerParent Process
Data Merger MSSQLServerParent: Setting Up the Project
Data Merger MSSQLServerParent: Running the Project
Data Merger: OracleDataMergerParent Process
Data Merger OracleParent: Setting Up the Project
Data Merger OracleParent: Running the Project
Data Merger: ParentChild Projects
Data Merger: DB2UDBDataMergerParentChild Project
Data Merger DB2UDBParentChild: Setting Up the Project
Data Merger DB2UDBParentChild: Running the Project
Data Merger: MSSQLServerDataMergerParentChild Project
Data Merger MSSQLServerParentChild: Setting Up the Project
Data Merger MSSQLServerParentChild: Running the Project
Data Merger: OracleDataMergerParentChild Project
Data Merger OracleDataMergerParentChild: Setting Up the Project
Data Merger OracleDataMerger ParentChild: Running the Project
Data Requester Projects
Data Requester DB2AS400DataRequester_CustomRPC Project
Data Requester DB2AS400DataRequester_CustomRPC: Setting Up the Project
Data Requester DB2AS400: Running the Project
Data Requester: MSSQLDataRequester Project
Data Requester MSSQLDataRequester: Setting Up the Project
Data Requester MSSQLDataRequester: Running the Project
DataRequester: MSSQLDataRequester_CustomRPC Project
DataRequester MSSQLCustomRPCDataRequester: Setting Up the Project
DataRequester: MSSQLCustomRPCDataRequester: Running the Project
Data Requester: OracleDataRequester Project
Data Requester OracleDataRequester: Setting Up the Project
Data Requester OracleDataRequester: Running the Project
Data Requester: OracleDataRequester_CustomRPC Project
Data Requester OracleDataRequester_CustomRPC: Setting Up the Project
Data Requester OracleCustomRPCDataRequester: Running the Project
Data Requester: SybaseDataRequester Project
Data Requester SybaseDataRequester: Setting Up the Project
Data Requester SybaseDataRequester: Running the Project