Backing Store Tutorial : Ensure DBMS Software and Driver are in Place and Edit the TRA

Ensure DBMS Software and Driver are in Place and Edit the TRA
Not all tasks must be done in the exact order shown in the tutorial, but following the tutorial steps ensures success.
If you are using Oracle Database, you don’t have to edit the TRA, for tutorial purposes, that is.
 
Task A Ensure DBMS Software and Driver are in Place and Edit the TRA
Before you begin to configure the backing store, ensure that you have done the following:
1.
Install and start a supported DBMS product. See the product readme file for a list of supported products. This tutorial uses Oracle 10G Express Edition. If you use a different supported database product, adapt the instructions accordingly.
2.
Copy the appropriate JDBC drivers file (for example, ojdbc6.jar) to BE_HOME/lib/ext/tpcl.
3.
Restart TIBCO BusinessEvents Studio. The Test Connection feature will now work (after you run the scripts to create the database user and schema.)
The driver must be in the above location for run time. It is also required for the design-time "Test Connection" feature to work (as long as the database is running, of course). You can try this feature out after you set up the database.
If you want to use the tester or debugger feature in TIBCO BusinessEvents Studio, see Working with External Library and Custom Function Paths in TIBCO BusinessEvents Developer’s Guide for an additional action you must take.
4.
Only if you are using SQL Server: Open the BE_HOME/bin/be-jdbcdeploy.tra file for editing. Specify sqlserver. The default value is oracle so if you are using Oracle Database you can skip this step. Do not change the other configuration properties shown:

 
#
# Base type schema/keyword files:
# Valid database types: oracle, sqlserver
#
java.property.jdbcdeploy.bootstrap.basetype.file %BE_HOME%/bin/base_types.xml
java.property.jdbcdeploy.bootstrap.keyword.file %BE_HOME%/bin/dbkeywordmap.xml
java.property.jdbcdeploy.database.type [oracle | sqlserver]

 
Summary and Next Steps
You have taken care of some prerequisite steps: ensured you can access a supported DBMS product, copied its driver file so that TIBCO BusinessEvents can access it, and checked that the backing store setup utility’s TRA file is set to your DBMS. Next step is to configure the TIBCO BusinessEvents Studio project.