- From the Control Panel start MDS Configuration or start MetaManager.
- In the Logon dialog box, click the Configure button.
- In the Teradata Meta Data Services Configuration dialog box:
- At Data Source Name, enter the ODBC system Data Source Name (DSN) to use to connect to the Teradata Database system that contains the MDS repository.
- At Database User Name, enter the user name that MDS will use to log on to the
Teradata Database system.The user must have specific permissions for various actions:
- The user must have permission to access the MDS database tables.
- To browse the MDS repository, SELECT privileges to the database that contains the MDS repository are required.
- To load or update the MDS repository, INSERT, UPDATE, and DELETE privileges are required.
- To create an Application Information Metamodel, CREATE TABLE privileges are required.
- To create the MDS repository, GRANT ALL PRIVILEGES privileges are required.
- At Database User Password, enter the password that MDS will use to log onto the Teradata Database system.
- At Database Name, enter the name of the Teradata Database within the Teradata Database system where the MDS repository is stored.
This can be the same as the Database User Name.
If omitted, the Database Name defaults to the default Database Name in the ODBC DSN for that Teradata Database system where the database is housed.
If the DSN does not have a default Database Name, the connection is made to the default database of the Database User. - Click Apply or OK to save your changes to the registry. If you are connected to MetaManager or Repository Explorer when you change these settings, the changes will not take effect until the application is restarted.