Running the Batch File

To set up the Hybrid Analysis sample application on Microsoft SQL Server, you first run the install_sqlsrv.bat file. This batch file creates tables in the sample database, loads metadata into the dimension tables, and loads sample data into the fact table. Run the install_sqlsrv.bat file located in:

EPM_ORACLE_HOME\products\Essbase\eis\server\Samples\tbcdbase

This file sends commands to the Interface SQL (ISQL) command line interface. These commands install the sample application to the sample database TBC.

Pass the following three parameters to install_sqlsrv.bat:

The user ID that you use to connect with the Microsoft SQL Server (TBC)
Your password
The Microsoft SQL Server name (name of machine where the SQL Server is installed)

Metadata Load Script

The install_sqlsrv.bat file runs the ISQL utility, which executes the ha_create_sqlsrv.sql metadata load script file. This file performs the following tasks:

Deletes any existing tables in the sample TBC database
Creates a new set of tables in the TBC database
Inserts records into the dimension tables
Creates the ha_results_createtables.txt file

The ha_results_createtables.txt file contains the results of the table-creating operation.

Sample Data Load Script

After loading the metadata into the dimension tables, the install_sqlsrv.bat file runs the BCP (Bulk Copy) utility which performs the following tasks:

Loads the sample data into the fact table
Creates the ha_results_loadfact.txt file

The ha_results_loadfact.txt file contains the results of the data-loading operation.