Use the Connection Manager with CA ERwin MM to connect to the mart to access models and perform administrative functions.
To connect to the mart
The Connection Manager dialog opens.
Identifies the type of relational database management system (DBMS) you will connect to. Select from the current list of supported databases.
Specifies the use of Windows user names and passwords to secure database access. You must be logged on to your computer as the user who is the dbo of the database. (Available only for Oracle and SQL Server.)
Specifies the use of a local user name and password for the connection.
Specifies the use of Native Connection to connect using the API provided by the SQL Server Native client software or ODBC data to connect using the ODBC data source you have defined.
Identifies the server name.
Identifies the name of the CA ERwin MM database or mart.
Specifies the connection string (TNSNames entry).
You can select a database connection from the Recent Connections panel to automatically populate the Database or Connection String previously used.
Click Connect.
The connection dialog closes. If the mart has been initialized, you are connected and remain connected until you click the Disconnect button on the Connection Manager dialog. If the mart has not been accessed yet, the CA ERwin Model Manager dialog opens to initialize the mart.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |