Configuring bwagent for PostgreSQL and TIBCO FTL®

The bwagent can be configured to use PostgreSQL database with TIBCO FTL for transport.

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: The database name must be unique per agent network if multiple networks share the same physical database. bwagent and bwengine supports sharing the same database, users and schemas.

Prerequisites

  • Install and configure TIBCO FTL on the same machine that you have installed TIBCO ActiveMatrix BusinessWorks™ 6.x on. For more information, see the "Setting Up TIBCO FTL® for bwagent Transport" topic in the TIBCO ActiveMatrix BusinessWorks™ Installation guide.
    Important: For the version of TIBCO FTL that is supported with the version of ActiveMatrix BusinessWorks™ 6.x, see the ActiveMatrix BusinessWorks™ readme.
  • Install PostgreSQL. The PostgreSQL driver is available by default.

Procedure

  1. After installing PostgreSQL, create a database bwadmindb and the database owner, bwuser as described in the following steps:
    1. Run the following commands on the psql terminal: 
      > psql -p 5432 -c "CREATE USER bwuser WITH CREATEDB PASSWORD 'bwuser';"
> psql -p 5432 -c "CREATE DATABASE bwadmindb WITH OWNER bwuser;"
    2. Open the pgAdmin III utility and expand Schemas > Tables in the Object Browser to view the tables in the database.
    3. To add a password for the database owner, expand Login Roles > bwuser, right-click and choose Properties. Choose the Definition tab and create and save a password.
  2. Stop the bwagent if it is running.
  3. Open the bwagent_ftl.json file located in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name PostgreSQL Value
    dbtype postgresql
    dbdriver org.postgresql.Driver
    dbConnectionURL jdbc:postgresql://localhost:5432/bwadmindb
    dbuser bwuser
    dbpassword bwuser
  5. Run the bwadmin config command with the -cf option to push the changes from the JSON file to the bwagent.ini file. 
    BW_HOME\bin>bwadmin config -cf ../config/bwagent_ftl.json agent
  6. Restart the bwagent.