Before using Teradata OLAP Connector and Teradata Schema Workbench, the metadata repository utilized by these products must be created and configured. In addition, the roles and permissions related to users of the Teradata Schema Workbench and Teradata OLAP Connector need to be set up. Following the Wizard user interface style, the Schema Workbench Repository Setup tool gathers environment information and sets up the Schema Workbench repository.
The Teradata Schema Workbench requires Java Runtime Environment (JRE) for Windows version 5 or higher.
- From the Windows Start menu, click .
-
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. -
Click Next, then type the repository 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.
-
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 BIM_REPOSITORY should not exist before setting up the Schema Workbench Repository. If the BIM_REPOSITORY already exists, a message appears. Click OK to exit the Schema Workbench Toolbox.
-
Type the service account information.
Field Description Service Account Service account that will be used internally to manage access to the repository and the target Teradata Database Password Password Retype Password Password -
Click Next.
The Setup Information dialog box appears, where you can verify the database server, port, permanent space, repository owner, and service account.
Click Back to modify any information you entered in previous steps.
- [Optional] Click Preview script to view the scripts that will be executed after setting up.
- Click Finish to execute the setup scripts. A The repository is successfully setup dialog box appears.
-
Read the information, and then click Close.
If an error occurs during setup, the BIM_REPOSITORY database will be deleted and dropped so you can rerun Schema Workbench Repository Setup after the issue is fixed.
