Adding a Teradata Database System - Teradata Meta Data Services

Adding a Teradata Database System

To use MetaManager to add a Teradata Database System:

1 Click System > Add System.

The Add System dialog box appears.

2 Type the system information and click OK.

System Name – is limited to 30 characters and must be unique.

Each system usually represents a Teradata Database System which will have database metadata loaded into the MDS repository.

Description – enter or change a description of the system. The description is limited to 1024 characters.

Security Profile – choose or change the security profile for the System.

Security Propagation Type – choose to apply the Security Profile by Database or Class.

Connection Information – is used by the MDS metaload utility to connect to this Teradata Database System to load or resynchronize database information in the MDS repository. Every workstation that will load, unload or resynchronize Teradata Database Systems will need connection information for each Teradata Database System.

ODBC Data Source Name (DSN) – is used to connect to this specific Teradata Database System. The DSN name is limited to 30 characters.

Teradata User Name – (limited to 30 characters).

The user login requires privileges to connect to the Teradata Database to load, unload, and resync databases. There are two options for granting permissions.

Create the MDS views that reference the DBC tables:

Click Start > All Programs > Teradata Meta Data Services > Create MDS Views.

Run the metaviews command line program.

If the MDS views are created, no Teradata privileges are required by the user on the DBC tables for loading, unloading, and resyncing databases.

If the MDS views are not created, MDS will access the DBC tables and the user requires SELECT privilege on DBC

The Teradata SELECT privilege on databases containing stored procedures is required to load all information on stored procedures.

If Automatic DIM Update is configured on the Teradata system, the user login also requires SELECT and DELETE privileges on the dbc.mdsrecoverytbl.

Teradata User Password – (limited to 30 characters).