MySQL | Oracle - Drivers Installation in BW 6.X

MySQL, Oracle drivers (jars)installation in TIBCO BW 6.X is different from TIBCO BW 5.X

If you want to use a databases other than PostgreSQL or Microsoft SQL Server, you must add them for run time separately. This is a one time process for every installation of TIBCO ActiveMatrix Businessworks. 

MySQL Driver Installation: 

Note: Search  and download jars, based on your target system compatible jars. Better read product readme guides.

mysql-connector-java-5.1.47.jar 
ojdbc6.jar

Place:  mysql-connector-java-5.1.47.jar    Under

C:\tibco_inst_6.9.0\bw\6.9\config\drivers\shells\jdbc.mysql.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.mysql\lib

C:\tibco_inst_6.9.0\bw\6.9\config\design\thirdparty

Oracle Driver Installation:

Place:  ojdbc6.jar  Under

C:\tibco_inst_6.9.0\bw\6.9\config\drivers\shells\jdbc.oracle.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.oracle\lib

C:\tibco_inst_6.9.0\bw\6.9\config\design\thirdparty

Once you have placed jar files in two locations, then install them by using bwinstall.exe command.

Go to : C:\tibco_inst_6.9.0\bw\6.9\bin>

For Oracle:

C:\tibco_inst_6.9.0\bw\6.9\bin>bwinstall oracle-driver

For MySQL

C:\tibco_inst_6.9.0\bw\6.9\bin>bwinstall mysql-driver

Then, create a JDBC connection and specify all required parameters and then test the connection.

That's all.

Thanks for reading :-)