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
|
Create the Unicode TBC_U
database in the same way that you create any database using an RDBMS:
- Create a database device or tablespace named TBC_U.
- Allocate 20 MB for storage.
- Create a user TBC_U who can drop and create tables.
- Grant user privileges or permissions to create and drop tables.
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.
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.
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 tbc_create_database_name_unicode.sql
- Importing the Unicode sample model
- Importing the Unicode sample metaoutline
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:
- Deletes any existing tables in the Unicode sample database
- Creates a new set of tables in the Unicode sample database
- Loads Unicode sample metadata into the dimension tables
- Loads Unicode sample data into the fact table
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:
- Start Integration Services Console and log in to the Unicode catalog.
- Select File > XML Import/Export.
The XML Import/Export
dialog box is displayed.
- Select the Import tab.
- 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
- Select the file and click Import to Catalog.
A message is displayed when the import is complete.
- Click OK.
To import the Unicode sample metaoutline:
- If necessary, select File > XML Import/Export.
The XML Import/Export dialog box is displayed.
- Select the Import tab.
- 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
- Select the file and click Import to Catalog.
A message is displayed when the import is complete.
- Click OK.
- Click Close to close the XML Import/Export dialog box.