Enabling Database/EMS

After you have installed TIBCO ActiveMatrix Adapter Framework, you have to enable the Oracle database and the Enterprise Message Service (EMS) for persistence and transport.

Prerequisites

You should have installed the Enterprise Message Server and the Oracle database. For details about the installation, see Installing Database/EMS. Also, you must have the privileges to create and to update a database.

Procedure

  1. Create a new database in an Oracle instance.
    Note: Do not use the same database as the TIBCO BusinessWorks database.
  2. Modify the {TIBCO_HOME}\afx\1.3\config\adapteragent.ini file as shown to enable the Enterprise Message Service and the database for persistence and transport. Also SSL support is now provided, modify the settings as required.
    Note: If you want to obfuscate the password of the database, the Enterprise Message Service, or the Enterprise Message Service SSL connection, use the bwobfuscator command provided by BW from the command line. Then enter the generated encrypted text as the password.
    Note: To avoid timeouts from the Enterprise Message Service, increase and set a suitable value as required in admin.technology.dbems.ems.requestTimeout(Default is 60000 ms). 
    admin.persistence.type=dbems

admin.technology.dbems.ems.ServerUrl=tcp://localhost:7222
admin.technology.dbems.ems.UserName=<UserName>
admin.technology.dbems.ems.Password=<Password>
requestQueueName=afx.admin.operations.queue.<machinename>
admin.technology.technology.dbems.ems.qin.EMSPrefix=EMSGMS
admin.technology.dbems.ems.requestTimeout=60000
admin.technology.dbems.ems.reconnection.interval=30000

admin.technology.dbems.ems.ssl.trust.identity={EMS_HOME}/samples/certs/client_identity.p12
admin.technology.dbems.ems.ssl.trust.cert.location={EMS_HOME}/samples/certs/server_root.cert.pem
admin.technology.dbems.ems.ssl.trust.password=<password>
admin.technology.dbems.ems.ssl.disable.verify.host.name=true
#admin.technology.dbems.ems.ssl.disable.verify.host=false

admin.technology.dbems.db.driver=oracle.jdbc.OracleDriver
admin.technology.dbems.db.connectionURL=jdbc:oracle:thin:@localhost:1521:adfauto
admin.technology.dbems.db.userName=<userName>
admin.technology.dbems.db.password=<password>
  3. Run tibhawkagent.exe present in {TIBCO_HOME}\afx\1.3\bin from the command line.
    Note: Check if tibhawkagent is started. Only after tibhawkagent is started, adapteragent can be started successfully.
  4. Run adapteragent.exe present in {TIBCO_HOME}\afx\1.3\bin from the command line and check the version and date. For example: TIBCO Adapter Framework version 1.3.1, build V5, 2017-03-01
    Note: Do not connect to the adapter agent until the you see the following message on the console: TIBCO-AFX-AGENT-300002: TIBCO ActiveMatrix Adapter Agent started successfully.
  5. Run adapteradmin from the command line and check the version and date. For example: TIBCO Adapter Framework version 1.3.1, build V5, 2017-03-01