Loading the Sample Database - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
A sample database is provided for educational purposes and can be used with a cube schema.
The default location of the cube schema is as follows:
  • 32-bit architecture Windows machine:

    C:\Program Files\Teradata\Client\15.10\Teradata Schema Workbench\Samples\schema\TAADemoSchema.biml.

  • 64-bit architecture Windows machine:

    C:\Program Files (x86)\Teradata\Client\15.10\Teradata Schema Workbench\Samples\schema\TAADemoSchema.biml.

Users can publish this schema after loading the sample database and then use Microsoft Excel, with an OLAP Connector configured data source, to perform queries against the defined cube. The repository should be set up before publishing the schema.

The Teradata Schema Workbench installation contains sample database files to be loaded.

To manually load the sample database, use ARCMAIN to load a supplied database archive instead of using the sample database loader. See Creating and Using the Sample Database.
  1. From the Windows Start menu, click All Programs > Teradata Client 15.10 > Teradata Schema Workbench > WorkbenchToolbox.
  2. Click Load Sample Database.
  3. Click Setup Schema Workbench Repository. The program starts with an instruction page.

    Schema Workbench Toolbox creates database objects, roles and sets up the appropriate permissions. Therefore, you must create a database user as the owner of the repository database, with the permissions specified on this page. This must be completed before continuing to the next step.

    Clicking Scripts to Set security Permissions for Repository Owner displays a sample script you can edit to set the Teradata Database owner.
  4. Click Next.
  5. Type the sample database information. For informative descriptions, you can position the mouse so the cursor is over each box.
    Field Description
    Teradata Server Name of the Teradata server
    Port Port
    User Account Name of the user account that will become the owner of the repository database
    Password Password
    Perm Space (KB) Amount of permanent space you want to allocate for the repository database.

    The repository database contain tables, views, macros, and triggers associated with Teradata Schema Workbench.

  6. Click Next. If the specified perm space is too large in your environment and an error message appears, click OK, decrease the perm space, and click Next.
    The sample database should not exist before setting up the Schema Workbench Repository. If the database already exists, a message appears, for example Database: TAADemo exists. The tool cannot create the database. Click OK to exit the Schema Workbench Toolbox.
  7. Click Select Folder and browse to the folder containing the sample database, select the folder, and click OK. The default location of the Sample Loader database folder is:
    • 32-bit architecture Windows machine:

      C:\Program Files\Teradata\Client\15.10\Teradata Schema Workbench\Tools\WorkBenchToolBox\SampleLoaderData\TAADemo

    • 64-bit architecture Windows machine:

      C:\Program Files (x86)\Teradata\Client\15.10\Teradata Schema Workbench\Tools\WorkBenchToolBox\SampleLoaderData\TAADemo

  8. Click Next. The sample database loading information appears, where you can verify the database server, port, permanent space, database name and database owner.
  9. Click Back to modify any information you entered in previous steps.
  10. Click Finish to execute the setup scripts. A status message appears: The sample database is successfully loaded.
  11. Click OK. If an error occurs during setup, the sample database is deleted and dropped so you can rerun Load Sample Database after the issue is fixed.