You might be asked to login to access a document. If after logging in you receive a message indicating that you do not have sufficient permissions or the page does not exist, you need a higher access level to access the document. Please go to and click the Help with.
Create the CA ERwin MM Mart - CA › 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. You must install or upgrade the license key before you create the CA ERwin MM mart. To create the mart • 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. • 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.
THE OLDEST MILITARY TREATISE IN THE WORLD. 
• 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 ERwin Model Manager dialog opens.
• 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.
• Click Create. The CA ERwin MM objects are created and the Security Manager dialog opens. 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. • 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. The mart is created.
Copyright © 2010 CA. All rights reserved.
Download Setup+Crack Mirror Link Dailyuploads / Uploads.to / DropBox Features Erwin Data Modeler 7.3 CA ERwin Data Modeler Standard Edition is a industry-leading data modeling solution that enables you to manage business data through an intuitive and graphical interface.Workgroup EditionCA ERwin Data Modeler Workgroup Edition is designed for collaborative modeling for data modeling teams. Provides conflict resolution, version control, security and standardization of multi-user modeling. Through a central repository model, the assets of the model can be inventoried and reused throughout the organization.