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.

The advanced configurations include:
  • Starting an Adapter Configuration with Adapter Launcher
    If you did not specify a working directory for an adapter configuration, you can use the Adapter Launcher tool to perform the configuration before you start the adapter configuration.
  • Configuring Load Balancing
    To improve the performance of an adapter service in heavy load scenarios, TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) supports the configuration of load balancing to distribute workload across services. Load balancing is supported for Publication Service, Subscription Service, and Request-Response Service.
  • Batch Processing
    TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) supports batch processing for Publication Service and Subscription Service.
  • Configuring Batch Commit for Subscription Service
    In TIBCO ActiveMatrix Adapter for Database 7.2, the adb.<default_session_name>.subBatchCommitTimeout and adb.<default_session_name>.subBatchCommitSize properties were added to configure batch commit for Subscription Service with the default session.
  • Handling Passwords
    You can use the obfuscate utility installed with TIBCO Runtime Agent to encrypt confidential information, such as passwords in property files, with an encryption key. The obfuscate utility rewrites a Java property file by encrypting property values that start with a #!! or #! prefix. The utility is located in the TIB_TRA_HOME/bin directory.
  • Subject and Destination Names
    An adapter configuration uses a subject name or destination name to send and receive messages. When you enable the TIBCO Rendezvous transport type, the adapter configuration uses a subject name to transmit messages; when you enable the JMS transport type, the adapter configuration uses a destination name to transmit messages.
  • Preregistering a Certified Subscriber
    You can add one or more certified subscribers or listeners for the publisher adapter that sends messages on subjects using the TIBCO Rendezvous Certified (RVCM) quality of service. The name of the subscriber is added to the preregistered list of the publisher adapter. The subscriber can be a TIBCO ActiveMatrix Adapter for Database subscriber, or any other TIBCO Rendezvous subscriber.
  • Changing the Location of the Ledger File
    The ledger file provides temporary storage for published messages that are sent by a publisher adapter using the TIBCO Rendezvous certified messaging quality of service. Each message is held in the ledger file until an acknowledgment that the message has been consumed is received by the subscriber.
  • Sending DateTime Data to an Adapter Configuration
    When TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) publishes messages including datetime data, the wire format is handled implicitly since because Publication Service and Subscription Service use the same format.
  • Using the User Callout Java Library
    The user callout Java library is used to transform a message that the adapter publishes into a structure that you want to publish. The user callout Java library can be customized to apply limited transformations to outgoing and incoming messages.
  • Using Database Deployment and Cleanup Scripts
    Changing an existing adapter configuration typically generates legitimate changes in a connected database. During this change process, the adapter creates a SQL script for changing the database objects and an associated cleanup script and stores them in the TIB_ADADB_HOME\sql directory. If the legitimate database changes result in error messages, you have to execute these scripts.
  • OS Authentication
    This release of the adapter provides SQL Server OS Authentication on Windows. Microsoft SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The Microsoft SQL Server system administrator must have associated your Windows network ID with a Microsoft SQL Server login ID.
  • Runtime Schema
    In the case where the schema names of the table objects are different between the development and production environments, you can use TRA properties to specify schema configurations.
  • Runtime Table Schema Configuration
    You can specify the runtime schema module properties in the administrator console during the deployment of the adapter. In this way, the adapter can use these schemas at run time, which are different from the design-time schema configurations. By specifying the runtime schema module properties, you can easily move from one environment to another, most likely from the test environment to the product environment.
  • Specifying Query Timeout
    The adapter provides the query timeout function on all databases. When a database server is busy and the polling operation fails to be completed, the adapter returns an error instead of hanging.
  • Compressing JMS Messages
    A client can use TIBCO Enterprise Message Service (EMS) to compress the body of a message before sending the message to the server. JMS compression is specified for individual messages. It is especially useful when messages are to be stored on the EMS server, including persistent queue messages and topics with durable subscribers.
  • Configuring RVCMQ Backlog Size
    The Rendezvous Distributed Queue (RVCMQ) scheduler receives inbound messages and assigns them to the worker. The scheduler stores tasks in a message queue.
  • Implementing Refresh Connection
    After extensive use of an adapter, the performance of the adapter might deteriorate. If you restart the adapter, its performance recovers. To resolve this issue, TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) supports the new refresh connection function. The connection between the adapter and database can be refreshed after a specified time elapses.
  • Error Handling by Subscription Service
    When Subscription Service inserts data into a database and an error occurs, the subscriber endpoint rolls back all previous operations on the database to the original status. Subscription Service handles error data in two ways: normal error handling and bulk insert error handling.
  • Using Opcodes to Set Operations for Subscription Service
    In TIBCO Business Studio, when you use a Publish to Adapter activity to publish messages to Subscription Service, you can set the ADB_OPCODE field to specify insert, update, delete, and upsert operations for Subscription Service.
  • Configuring Publish by Reference Object
    When source data is stored in a view or a different database object, you can publish the data by using a referred object. Publish by Reference Object is an extension of the Publish by Reference feature.
  • Setting Maximum Rows in the Operation Level
    For custom RPC Service, you can specify the maximum number of rows to be fetched in the operation level. At run time, the adapter fetches the number of rows according to the value set in the operation level instead of the service level.
  • Using Hints (Publication Service Only)
    Hints help improve the performance of your queries. When Publication Service performs a poll operation to fetch data from a table, using hints greatly enhances the query.
  • Configuring the Internal Message Queue
    When TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) interacts with a TIBCO environment, the adapter first retrieves messages from a transport queue and caches them in the internal message queue for processing. You can configure the internal message queue to cater to the performance of the adapter.