Database with TIBCO FTL for bwagent

The bwagent can be configured to use TIBCO FTL for transport among bwagents. PostgreSQL, MySQL, Microsoft SQL, Oracle, and DB2 are the supported databases.

Note: Use of TIBCO FTL® with TIBCO ActiveMatrix BusinessWorks™ for configuring bwagent and for configuring group provider for engine does not require TIBCO FTL® licenses.
Note: Regularly back up domain data using the bwadmin backup command. For more information about backing up and restoring domain data, see Backing up and Restoring a Domain

For a multi-agent, multi-machine environment using an external database and TIBCO FTL, modify the following properties in the bwagent.ini file .

bwagent properties for Multi-Agent, Multi-Machine Environments using Database/FTL
Property Name Description
bw.agent.technology.dbftl.db.provider Set one of the following supported database providers:
  • postgresql
  • mysql
  • mssql
  • oracle
  • db2
bw.agent.technology.dbftl.db.driver The database driver.
bw.agent.technology.dbftl.db.connectionURL The URL to connect to the database.
bw.agent.technology.dbftl.db.userName The user name to authenticate to the database.
bw.agent.technology.dbftl.db.password The password to authenticate to the database.
bw.agent.technology.type Set dbftl as the technology type for the bwagent to use.
bw.agent.technology.dbftl.ftl.realmserver Set The FTL realm server.

Example: bw.agent.technology.dbftl.ftl.realmserver= http://localhost:8070

In case of FTL 6.x server in FT mode, set multiple realmserver values separated by pipe. (|).

For example: bw.agent.technology.dbftl.ftl.realmserver= http://10.97.240.76:8050 | http://10.97.240.76:8051 | http://10.97.240.76:8052
bw.agent.technology.dbftl.ftl.application Set the application name.

Example: bw.agent.technology.dbftl.ftl.application=bwadmin
bw.agent.technology.dbftl.ftl.identifier Set the FTL identifier.
bw.agent.technology.dbftl.ftl.secondary Set the secondary realm server. This property is optional for FTL 5.x.

Important: This property is available in the bwagent.ini file only when you set the ftlsecondary property to true in the bwagent_ftl.json file. By default, the property is set to false.

bw.agent.technology.dbftl.ftl.username Set the FTL user name.
bw.agent.technology.dbftl.ftl.password Set the FTL password.
bw.agent.technology.dbftl.ftl.endpoint Set the FTL endpoint.

Example: bw.agent.technology.dbftl.ftl.endpoint=bwadmin-endpoint
bw.agent.technology.dbftl.ftl.dataformat Set the FTL data format.

Example: bw.agent.technology.dbftl.ftl.dataformat=bw-format
bw.agent.technology.dbftl.ftl.inbox Set the FTL inbox.

Example: bw.agent.technology.dbftl.ftl.inbox=bw-inbox
bw.agent.technology.requestTimeout Timeout for requests sent to other BWAgents.

The default value is 6000 milliseconds.

bw.agent.technology. remote.status.requestTimeout Timeout for requests sent to BWAgents to find the status of AppNodes, applications, and other BWAgents.

The default value is 3000 milliseconds.

For information about setting properties, see: