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.
Before you begin
  • 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.