CA ERwin Model Manager › Connect to the CA ERwin MM Mart

Connect to the CA ERwin MM Mart

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

1. Click Connection on the Services menu.

   The Connection Manager dialog opens.

2. Complete the following information:
   • Database

     Identifies the type of relational database management system (DBMS) you will connect to. Select from the current list of supported databases.

   • Authentication
   • Windows Authentication

     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.)

   • Database Authentication

     Specifies the use of a local user name and password for the connection.

   • Parameters/Value Options
   • Connection Type (Microsoft SQL Server 2005 Only)

     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.

   • Server

     Identifies the server name.

   • Database

     Identifies the name of the CA ERwin MM database or mart.

   • Connection String (Oracle Only)

     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.