Wednesday, November 21, 2018

TIBCO Installation - JDBC driver configuration to connect to Database (Oracle)


      As we know, both TIBCO stack and database installation happens independently and both will have separate folders to maintain their binary after installation. Once you done with TIBCO and database installation, we have to configure JDBC lib/jars at below specified locations to make our TIBCO environment to communicate/connect to database.

1. Update TRA installation to find JDBC drivers is as follows :

In command prompt, Navigate to "<<TIBCO_HOME>>/tra/<<version>>/bin" directory and run below two commands.

traDBConfig -type OracleThin -dbpath <<ORACLE_HOME>>/app/user/product/11.2.0/dbhome_1/jdbc/lib -product tra

traDBConfig -type OracleThin -dbpath <<ORACLE_HOME>>/app/user/product/11.2.0/dbhome_1/jdbc/lib -product admin

NOTE : Here we consider Oracle DB driver to explain this scenario but we can configure JDBC lib directory corresponds to DB which you are trying to communicate.

2. designer.tra : --> Applications to connect to Database to perform CURD operations during design time.

a. Open "<<TIBCO_HOME>>/designer/<<version>>/bin/designer.tra" file using text/vi editor

b. Locate the Line : tibco.env.CUSTOM_CP_EXT (at Line no.37)

c. Append JDBC lib folder path to it as below :


NOTE : Here we consider Oracle DB driver to explain this scenario but we can configure JDBC lib directory corresponds to DB which you are trying to communicate.

3. bwengine.tra : --> BW Engine to communicate to Database to perform CURD operations during run time.

a. Open "<<TIBCO_HOME>>/bw/<<version>>/bin/bwengine.tra" file using text/vi editor

b. Locate the Line : tibco.env.CUSTOM_EXT_PREPEND_CP (at Line no.38)

c. Append JDBC lib folder path to it as below :


NOTE : Here we consider Oracle DB driver to explain this scenario but we can configure JDBC lib directory corresponds to DB which you are trying to communicate.

4. Before creating new TIBCO domain using database repository :

      An Administrator domain stores domain information in a database repository or file repository, depending on the tranport type. If TIBCO Rendezvous(RV) is set as the transport, you can store domain data in a database repository or file repository. If TIBCO Enterprise Message Service(EMS) is set as transport, you can only store domain data in a database repository.

      For database repository, While creating new TIBCO domain we might encounter issue to connect to DB, this is due to missing JDBC driver. This we can solve it with below configuration:

--> Copy "jdbc" folder from oracle installation directory to tpcl lib directory.

     From - <<ORACLE_HOME>>/app/user/product/11.2.0/dbhome_1
     To     - <<TIBCO_HOME>>/tpcl/<<version>>

NOTE : Here we consider Oracle DB driver to explain this scenario but we can configure JDBC lib directory corresponds to DB used while creating the domain.

and also look for :

1) File-based Domain VS Database-based Domain
2) TIBCO Administration Domain Creation using Domain Utility in GUI Mode



No comments:

Post a Comment

back to top