Teradata Schema Workbench Toolbox tips to configure TAADemo database

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Teradata Schema Workbench Toolbox tips to configure TAADemo database

The Teradata Schema Workbench product provides a utility program that facilitates the proper definition and configuration of the metadata repository database (BIM_REPOSITORY) and associated tables required by the Schema Workbench, Teradata OLAP Connector and Teradata OLAP Server products. While it is possible to use tools such as Teradata Studio or Teradata SQL Assistant to manually define and configure the metadata repository, it is strongly advised that you utilize the Schema Workbench Toolbox.

Launching the Toolbox

The toolbox can be launched from the Start menu via the All Programs->Teradata Client 14.10->Teradata Schema Workbench/ Workbench Toolbox shortcut.  Alternatively, you can run the executable directly. The executable file is located in the <Teradata Schema Workbench install location>\Tools\WorkbenchToolbox directory. Unless the installation location was altered, on a 64-bit machine this, should equate to C:\Program Files (x86)\Teradata\Client\14.10\Teradata Schema Workbench\Tools\WorkbenchToolbox.  To launch the toolbox from the toolbox directory, double click the WorkbenchToolbox.exe executable file. When the toolbox starts, you are presented with the following screen.

Launching Metadata Repository Creation

Initiate the repository creation process by pressing the Setup Schema Workbench Repository button. The Repository Setup screen displays. This screen provides important information about prerequisite work you must perform to prepare to complete the repository creation process.

Construct the Metadata Repository

Prior to clicking the Next button, you must ensure you have created a database user that will be the owner of the BIM_REPOSITORY repository database. Enter the database user you defined to own the repository for the User Account value.  Press Next.

Create the Service Account Database User and Repository Roles

Once the Teradata server name and the repository database owner are provided, the toolbox prompts you to enter a user name to be associated with the Service account that will be used to retrieve data from source databases on behalf of user account. Press Next.

Setup information prior to create the BIM_Reporitory and the Service account

The toolbox shows setup information prior to initiate the operations to create the BIM_REPOSITORY database and the associated tables, views and triggers, the Service Account database user and the TBI_SERVICE, TBI_WORKBENCH and TBI_USER database roles. The Service Account database user is automatically assigned the TBI_SERVICE role. Press Finish.

Note: You can see what the toolbox will be creating from Preview Script button.

Success message after completion of creating the BIM_Repository, the Service account and configuring roles

Assigning Required Permissions to TBI_SERVICE

Note: The TBI_SERVICE role MUST be given SELECT permission on any database to be modeled in the Schema Workbench or queried by the Teradata OLAP Connector or Teradata OLAP Server.

Example: GRANT SELECT ON [Model Database] TO TBI_SERVICE;

Installing and Populating the Sample Database

The Schema Workbench comes with a sample database (TAADemo) and schema (TAADemoSchema.biml) that can be used for experimentation. To initiate the sample database creation process, launch the toolbox utility and click on the Load Sample Database button. The Welcome to the Sample Database Loader screen displays. This screen provides important information about prerequisite work you must perform to prepare to complete the sample database creation process.

Construct the Sample Database

Prior to clicking the Next button, you must ensure you have created a database user that will be the owner of the TAADemo sample database. Press Next.

Note: Enter the folder path where the SQL scripts reside that will be executed to create the database. This folder path resides within the Schema Workbench installation location at <Teradata Schema Workbench install location>\Tools\WorkbenchToolbox\SampleLoaderData\TAADemo.  Unless the installation location was altered, on a 64-bit machine, this should equate to C:\Program Files (x86)\Teradata\Client\14.10\Teradata Schema Workbench\Tools\WorkbenchToolbox\SampleLoaderData\TAADemo. Note: the folder location documented in the Teradata Schema Workbench 14.10 User Guide is incorrect. Please substitute the information above.

Provide the Teradata server and the User Account value

To see Sample Database Loading Information prior to complete loading TAADemo database, press Next or to complete the database creation process, press Finish.

Sample Database Loading Information

Assigning Required Permissions to TBI_SERVICE

Note: The TBI_SERVICE role MUST be given SELECT permission on the TAADemo sample database before you will be able to access the database via the Schema Workbench, Teradata OLAP Connector or Teradata OLAP Server. Run the following SQL to grant this permission

GRANT SELECT ON TAADemo TO TBI_SERVICE;

The sample database should now be ready for experimentation.

2 REPLIES

Re: Teradata Schema Workbench Toolbox tips to configure TAADemo database

Could you please provide the link to download teradata schema workbench? or steps to configure AAPdemo database using teradata studio express or SQL Assistent.

Teradata Employee

Re: Teradata Schema Workbench Toolbox tips to configure TAADemo database

Teradata Schema Workbench comes with Teradata Schema Workbench Toolbox which the article describes for BI repository installation and TAADemo database.

Teradata Schema Workbench package contains DDLs and data for TAADemo database population which you can utilize them for your Teradata Studio Express or SQL Assistant although using Teradata Schema Workbench Toolbox is recommended because the tool creates roles, users and etc that reduces configuration mistakes.

Please contact PS organization or Product Manager - Mark Hasenstab for Teradata Schema Workbench package.

Thanks,

--Geonil