Setting Up the Standard Sample Application Manually

To set up the standard sample application manually, you begin by creating two databases in a supported RDBMS: TBC (the sample database) and TBC_MD (an OLAP Metadata Catalog). You then create tables in each of these databases and load data into them, using scripts provided with Integration Services. The names and directory locations of these scripts are detailed in the topics that follow.

Note:

strongly recommends that you use the automatic installation process to install the standard sample applications (see Setting Up the Standard Sample Application Automatically).

After you create the TBC and TBC_MD databases in a supported RDBMS, you use several scripts and files to create the standard sample application:

A script for creating the TBC sample database tables
This script is located in the samples\tbcdbase directory.
A script for loading the TBC sample database data
This script is located in the samples\tbcdbase directory.
A script for creating the TBC_MD OLAP Metadata Catalog database tables
This script is located in the ocscript directory.
XML files for importing a sample OLAP model and metaoutline in the TBC_MD OLAP Metadata Catalog database
These XML files are located in the samples\tbcmodel directory.

The scripts for creating the standard sample application and OLAP Metadata Catalog are installed with the server software during Integration Services installation. Different versions of the scripts are provided for each of the supported RDBMSs.

Note:

Some of the standard sample application scripts require slightly different procedures, depending on the RDBMS that you are using.