Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 30 JDBC Backing Store Setup : DBMS Software Requirements and Installation

DBMS Software Requirements and Installation
Database Location
Instructions in this chapter assume you are working with a local database for testing purposes. Adapt the instructions if you are working with a remote database. For example, in production environments, you might have to ask a database administrator to create a database user for you. You should then be able to run the other SQL scripts yourself, logged on as the user created by the administrator.
Minimum User Permissions
By default the TIBCO BusinessEvents user permissions are set to DBA privileges. At a minimum, the user must be able to create tables and views. For example for an Oracle database you could use the following:

 
DROP USER BE_USER CASCADE;
CREATE USER BE_USER IDENTIFIED BY BE_USER;
GRANT CONNECT TO BE_USER;
GRANT RESOURCE TO BE_USER;
GRANT CREATE ANY VIEW TO BE_USER;
GRANT CREATE ANY TABLE TO BE_USER;

 
 
Task A Ensure DBMS Software and Drivers are in Place
Before you begin to configure the backing store, you or your DBA must do the following:
Copy the appropriate JDBC drivers file to BE_HOME/lib/ext/tpcl. You must restart BusinessEvents Studio Explorer after copying the drivers file. This step is required before you can use the design-time Test Connection feature. It is also required for runtime.
The remainder of this section provides a few tips for each supported DBMS.
SQL Server
Here are a few helpful points about SQL Server:
Microsoft SQL Server 2008 has added a new data type, datetime2, which has a date range of 0001/01/01 through 9999/12/31. Therefore, if you are using Microsoft SQL Server 2008, then you can manually change the generated SQL script (DDL) for your backing store, and replace any affected columns’ data type from datetime to datetime2.
Use the SQL Server JDBC driver, sqljdbc4.jar. You can download this driver from:
http://msdn.microsoft.com/en-us/data/aa937724.aspx
Oracle Database
Here are a few helpful points about Oracle Database:
Use ojdbc6.jar drivers file.You can download this file from the following location:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved