Database Connection Information - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

Database Connection Information

When creating a System with Automatic DIM Updates enabled, a DSN, user name and password for the DDL Gateway to use to connect to the system are specified in MetaManager.

The Gateway Server process uses these settings to resync a database during recovery and to access the MDS Recovery Table. The Gateway Integrity Servers use these settings to connect to the system to get information from the DBC tables.

If the DDL Gateway is running on Linux, the Gateway uses the Teradata user name specified in mdsconfig to connect to the MDS repository. The Gateway uses the Teradata user name specified in MetaManager’s system configuration to connect to other Teradata systems.

The DDL Gateway on Windows systems runs as a service. A service can run as the LocalSystem Account or as a specified account name and password. If the MDS repository Database Configuration is configured for Teradata Single Sign On (SSO) where no username and password is specified, then the DDL Gateway Service MUST NOT be configured to run with the LocalSystem Account. If the MDS repository Database configuration is configured for SSO where no username and password is specified, there must be a Teradata user account with the same name as the user account in which the Gateway is run.