Creating and Using 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
  1. Load the sample database by doing one of the following:
    • Use the Sample Database Loader, which is a tool in the Schema Workbench Toolbox, to load a sample database named TAADemo. See Loading the Sample Database.
    • Manually load the supplied database archive, named ARCTAA, using the ARCMAIN utility.

      The default location for this archive file is:

      (On 32-bit machine): C:\Program Files\Teradata\Client\15.10\Teradata Schema Workbench\Samples\database

      (On 64-bit machine): C:\Program Files (x86)\Teradata\Client\15.10\Teradata Schema Workbench\Samples\database

      Be sure to create the database before running ARCMAIN. Also, you need to create a simple script to do the load. ARCMAIN is a Teradata Tools and Utilities product. For more information, see Teradata Archive/Recovery Utility Reference (B035-2412).

  2. Load the TAADemoSchema.biml file. (See Opening a Cube Schema). The default location of the TAADemoSchema.biml file is:
    • (On 32-bit machine): C:\Program Files\Teradata\Client\15.10\Teradata Schema Workbench\Samples\schema
    • (On 64-bit machine): C:\Program Files (x86)\Teradata\Client\15.10\Teradata Schema Workbench\Samples\schema
  3. Publish the TAADemoSchema. (See Publishing a Schema to the Database).
  4. Configure your BI client application to use this new cube data source. Refer to the Teradata OLAP Connector User Guide (B035-4105) or the Teradata OLAP Server User Guide (B035-4109).