Installation and Configuration › Create the CA ERwin MM Mart

Create the CA ERwin MM Mart

After you create the CA ERwin MM database on your DBMS and install the administrative files, you must create the CA ERwin MM mart to create the tables, install the stored procedures that manage client workgroup models in the mart, and prepare the mart for use with CA ERwin Data Modeler and CA ERwin Process Modeler. To create, update, or delete a mart you must have the following database rights:

• For Microsoft SQL Server 2000/2005/2008, you must be the database owner (dbo).

For Oracle, you must be the database schema owner and have the DBA role.

Note: The CA ERwin MM mart and the CA ERwin MM Control Tables (m7Master and m7License) must be installed on the same database for Microsoft SQL Server or Sybase DBMS.

Important! You must install or upgrade the license key before you create the CA ERwin MM mart.

To create the mart

1. Log on to your DBMS that contains CA ERwin MM as the dbo or schema owner. Click Programs, CA, ERwin, ERwin Model Manager r7.3, Model Manager on the Start menu.

   The Connection Manager 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.

3. The ERwin Model Manager dialog opens.

   

4. Select from the following options:
   • Database (SQL and Sybase DBMS)

     Identifies the master database name to create the tables and stored procedures.

   • CA ERwin MM Role (Oracle DBMS)

     Identifies the Oracle MMUSER security role. This role is created in the procedure for creating the CA ERwin MM database on Oracle. Other user roles can connect to CA ERwin MM, but they will encounter access problems.

   • Table Tablespace

     Indicates where you want to store the CA ERwin MM tables.

     Note: The drop-down box is not active if there is only one tablespace.

   • Index Tablespace

     Indicates where you want to store the CA ERwin MM indexes.

     Note: You can store tables and indexes in the same tablespace or in different tablespaces.

   • Truncate Log Before Any Action

     Specifies to remove the database transaction log. Truncating the database transaction log is especially important for Microsoft SQL Server and Sybase users since a large transaction log can cause the database to hang.

     Note: When you initialize a Microsoft SQL Server 2008 database, it is not necessary to select the "Truncate Log Before Any Action" option. If you select this check box, and click Create, the following error message displays: "Incorrect syntax near the keyword 'TRANSACTION'." To avoid this message, clear the check box for "Truncate Log Before Any Action" before you click Create.

5. Click Create.

   The CA ERwin MM objects are created and the Security Manager dialog opens.

   Important! If you do not see the Security Manager dialog, it can be hidden behind other open applications. Minimize all applications or use the Alt-Tab keys until you find it.

   Your user name is automatically added to the Administrator profile in the Security Profile list.

6. Use the controls in the Security Manager dialog to assign additional security profiles. Click OK when complete.

   Note: You can also do this later from CA ERwin Data Modeler or CA ERwin Process Modeler.

   The Setup Complete message opens.

   

7. Click OK.

   The mart is created.