Notes on Configuring an Adapter

Required and Optional Settings

You must set correct database relevant information, which you can load the database tables, procedures, and functions when configuring the adapter services.
The remaining tabs are optional, and are customized for your adapter or services only if you want.

You must be aware of the following rules before starting or configuring an adapter:

A database account must be created for running the adapter. See TIBCO ActiveMatrix Adapter for Database Installation for details.
If you are using a remote repository, you must run the database server process and the repository server process to start an adapter instance.
Data source connection parameters for an adapter instance can be specified in the adapter properties file and in TIBCO Designer. Values given in the properties file override the same values specified in TIBCO Designer.
An adapter instance name is defined in TIBCO Designer. Names must be alphanumeric and less then 80 characters, and can contain underscores (_) and hyphens(-).
When configuring Subscription Service, if you select JMS as transport type and Topic as the connection factory type, you must change the durable name in the sessions setting.
Multiple subscribers of the same instance cannot be configured to listen on the same subject.
Multiple subscribers in different instances can be configured to listen on the same subject, but cannot write to the same destination table.
If an adapter instance cannot access the database at startup, the adapter will not start. If the connection fails after startup, you can configure the adapter to attempt automatic reconnections. See the Run-time Connection Tab. You can also build a TIBCO Hawk rule to restart the adapter instance after the database is restarted.
Do not use ADB_ to prefix columns in the database. The prefix is reserved for this product.