Setting up the Unicode sample application

Setting up the Unicode sample application is a manual process.

The utilities listed in Table 28 are required for running the various batch files and SQL scripts used in creating the Unicode sample application.

Table 28. Required Utilities for Setting Up the Unicode Sample Application
Database Required Utilities
Oracle
  • SQL*Plus
  • SQL*Loader command line utility

Creating the Unicode TBC_U database

Create the Unicode TBC_U database in the same way that you create any database using an RDBMS:

CAUTION:
You should create the tables for the Unicode-enabled database as user TBC_U, or portions of the Unicode sample application may not work.

Creating the Unicode TBC_MD_U OLAP Metadata Catalog

Create the Unicode TBC_MD_U OLAP Metadata Catalog by following the steps in Setting up the TBC_MD OLAP Metadata Catalog, using the file oc_create_database_name_unicode.sql.

Setting up the Unicode sample application

You use several files to create the Unicode sample application:

Setting up the Unicode sample application consists of performing the following tasks:

Running the SQL file

The first task in setting up the Unicode sample application consists of running the tbc_create_database_name_unicode.sql file using one of the utilities listed in Table 28.

Note:
Make sure you have created a Unicode-enabled database for your sample application as described in Creating the Unicode TBC_U database.

Run the tbc_create_database_name_unicode.sql file located in:

\is\samples\tbcdbase\

The tbc_create_database_name_unicode.sql file performs the following tasks:

Importing the Unicode sample model and metaoutline

The final task in setting up the Unicode sample application consists of importing the XML file for the Unicode sample model:

To import the Unicode sample OLAP model:

  1. Start Integration Services Console and log in to the Unicode catalog.
  2. Select File > XML Import/Export.

    The XML Import/Export dialog box is displayed.

  3. Select the Import tab.
  4. In the XML File Path text box, enter the file path for the Unicode sample OLAP model or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\TBC_Model_Unicode.xml
  5. Select the file and click Import to Catalog.

    A message is displayed when the import is complete.

  6. Click OK.

To import the Unicode sample metaoutline:

  1. If necessary, select File > XML Import/Export.

    The XML Import/Export dialog box is displayed.

  2. Select the Import tab.
  3. In the XML File Path text box, enter the file path for the Unicode sample metaoutline or click the Open XML File button and navigate to the following file:
    \is\Samples\tbcmodel\TBC_Metaoutline_Unicode.xml
  4. Select the file and click Import to Catalog.

    A message is displayed when the import is complete.

  5. Click OK.
  6. Click Close to close the XML Import/Export dialog box.