Configuring bwagent for Oracle and TIBCO FTL®

The bwagent can be configured to use Oracle 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.

Prerequisites

Install and configure TIBCO FTL on the same machine that you have installed 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.

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

Install Oracle Database 12c:

  1. Download and install Oracle Database 12c from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
  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 following 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:
    1. ojdbc7.jar from http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html
  5. Install the Oracle driver by running the command bwinstall oracle-driver from the /bin folder.
Note: If you are using Oracle Database 11g, execute the oracle11g_create.sql script at BW_HOME/config/dbscripts/admin/oracle and restart the bwagent.

Procedure

  1. After installing Oracle Database 12c, 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 located 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 '##' ( e.g. 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.