Open topic with navigation

TIBCO GridServer® 7.1.0

# Configuring the Reporting Database

To configure the reporting database, first install your Manager; second, configure the database; and third, configure the Manager to use the new database. Then, restart the Manager.

## Install the Manager

| 1. | Install and configure your GridServer Manager. Restart the Manager after completing the installation.

| 2. | Ensure that the `tables.<db>.sql` file needed by the `createdb` script is in the `DS_MANAGER``/webapps/livecluster/WEB-INF/etc/db` directory.

## Configure the database

Procedure

| 1. | Set the `CLASSPATH` on the Manager containing the Director that communicates with the database. The `CLASSPATH` must include the database driver JAR files applicable to your database. For example, to create an SQL Server database in a UNIX shell:

    export
       CLASSPATH=JDBCDriver/msbase.jar:JDBCDriver/mssqlserver.jar:\
       JDBCDriver/msutil.jar

replacing `JDBCDriver` with the actual path to the directory containing your driver JAR files.

| 2. | Run the `createdb` script provided in `DS_MANAGER``/webapps/livecluster/WEB-INF/etc/db` directory on your Manager. Pass the name of the database properties file as an argument. Before you run the script, change the property file settings to match those of your database.

## Configure the Manager

Procedure

| 1. | Log in to the GridServer Administration Tool with an account that has a Security Role with the Manager Reconfigure feature enabled.

| 2. | Go to Admin > System Admin > Manager Configuration > Database.

| 3. | Configure the values in the Reporting Database Connection section using the appropriate table below. Note that `hostname` is the hostname and `database` is the name of the database.

Property | Value
## Oracle
URL | `jdbc:oracle:thin:@``hostname``:1521/``database`
Driver | `oracle.jdbc.OracleDriver`
Transaction Isolation | `TRANSACTION_READ_COMMITTED`
## Microsoft SQL Server
URL | `jdbc:sqlserver://``hostname``:1433;DatabaseName=``dbName``;SelectMethod=cursor` (`SelectMethod=cursor` is required)
Driver | `com.microsoft.sqlserver.jdbc.SQLServerDriver`
Transaction Isolation | `TRANSACTION_SERIALIZABLE`
## PostgreSQL
URL | jdbc:postgresql://`hostname`:5432/`dbName`
Driver | org.postgresql.Driver
Transaction Isolation | `TRANSACTION_READ_COMMITTED`

| 4. | Copy the corresponding JDBC driver’s JAR file into the Manager’s `DS_MANAGER``/webapps/livecluster/WEB-INF/lib` directory.

| 5. | Restart the GridServer Manager.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO GridServer®

Copyright © 2001-2022. TIBCO Software Inc. All Rights Reserved.