Overview of Sample Applications

Integration Services provides sample applications that consists of the following features:

A database for a fictitious company called The Beverage Company (TBC)
A sample OLAP model and metaoutline created from the TBC database
A Hybrid Analysis-enabled OLAP model and metaoutline
A special OLAP Metadata Catalog to store the sample OLAP models and metaoutlines and any additional OLAP models and metaoutlines that you create using the sample data

Preparing the sample application consists of three tasks:

Setting up the standard sample application
Optional: Setting up the Hybrid Analysis sample application
Optional: Setting up the Unicode sample application

You can set up the standard sample application automatically using Integration Services Console (see Setting Up the Standard Sample Application Automatically), or you can set up the standard sample application manually (Setting Up the Standard Sample Application Manually. Using either method, setting up the standard sample application involves two main tasks:

You create two relational databases: one for the data in the TBC sample application and one for the OLAP Metadata Catalog database (TBC_MD).
Note:
Creating the relational databases is a manual task that you must perform prior to setting up the standard sample application, regardless of whether you choose the automatic or manual method.
You then create tables in each of these databases and load data into them, using scripts provided with Integration Services. You can create tables either automatically, through the use of Integration Services Console, or manually.

When you finish setting up the standard sample application, the OLAP Metadata Catalog database (TBC_MD) will contain an OLAP model (TBC Model) and a metaoutline (TBC Metaoutline) based on data in the sample TBC relational data source.

You create the Hybrid Analysis sample application manually by completing the tasks in Setting Up the Hybrid Analysis Sample Application. Upon completion of these tasks, the sample TBC relational data source will contain Hybrid Analysis data. The OLAP Metadata Catalog will contain a Hybrid Analysis-enabled OLAP model (HA TBC Model) and metaoutline (HA TBC Metaoutline).

You create the Unicode sample application manually by completing the tasks in Setting Up the Unicode Sample Application. Upon completion of these tasks, the sample TBC_U relational data source will contain Unicode enabled data. The Unicode TBC_MD_U OLAP Metadata Catalog will contain Unicode-enabled OLAP model (TBC_Model_Unicode) and metaoutline (TBC_Metaoutline_Unicode).

Caution!

If you have installed the sample application from a previous release of Integration Services, you should back up and preserve your existing sample database, OLAP Metadata Catalog, and the OLAP models and metaoutlines that OLAP Metadata Catalog contains. You can then upgrade your existing catalog to be compatible with the current release of the software (see Upgrading OLAP Metadata Catalogs Manually). You cannot, however, store newly created OLAP models and metaoutlines in your previous catalog.