Configuring BWAgent for Oracle and TIBCO FTL®

The BWAgent can be configured to use the Oracle Database with TIBCO FTL for transport.

Note: Use of TIBCO FTL with ActiveMatrix BusinessWorks for configuring BWAgent and configuring group provider for BWEngine do 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 support the sharing of the same database.
Before you begin

Install and configure TIBCO FTL on the same machine where you have installed ActiveMatrix BusinessWorks 6.x. 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.

Ensure that you have installed FTL client libraries. For more information, see the "Integrating with TIBCO FTL" section in the TIBCO ActiveMatrix BusinessWorks™ Installation guide.

Install the latest Oracle Database:

  1. Download and install the latest Oracle Database from their official website.
  2. Configure the server configuration by following the prompts in the Oracle Configuration wizard.
  3. Accept the default port value 1521, or enter your own port number.
  4. Download the latest JDBC driver connector JAR files to the BW_HOME\config\drivers\shells\jdbc.oracle.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.oracle\lib folder for Windows or the ${BW_HOME}/system/lib for Unix.
  5. Install the Oracle driver by running the command bwinstall oracle-driver from the /bin folder.
Note: If you are using Oracle Database 11g, run the oracle11g_create.sql script at BW_HOME/config/dbscripts/admin/oracle and restart the BWAgent.
    Procedure
  1. After installing the Oracle Database, create a database bwadmindb and grant privileges to the default database owner bwuser as described in the following steps:
    1. Run the following commands in SQLPlus as a root user: 
      CREATE DATABASE bwadmindb;
create USER C##bwuser identified by "bwuser";
GRANT CREATE SESSION TO C##bwuser;
grant create sequence to C##bwuser; 
ALTER USER C##bwuser quota unlimited on USERS;
grant create table to C##bwuser;
  2. Stop the BWAgent if it is running.
  3. Open the bwagent_ftl.json file in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name Oracle Value
    dbtype oracle
    dbdriver oracle.jdbc.OracleDriver
    dbconnectionurl jdbc:oracle:thin:@db:1521:bwadmindb
    dbuser Cbwuser
    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
    Note: If you are creating a user with '##' (for example, c##bwuser), then you need to keep the username field as empty in the bwagent_db.json file and later update the bwagent.ini file manually.
  6. Restart the BWAgent.