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.

• b、Right click 〝New partition〞for further action c、“Next” - 12. Sata hdd drivers download.

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

ERwin Data Modeler Download the latest version for Windows. It is separate installation configuration without complete connection ERwin-Data Modeler for 32 and 64 bits. Erwin Data-Modeler is an impressive tool that provides data modeling environment for collaborative data management company through a graphic and simple interface.

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.

ScreenShots: Software Description: ERwin Data Modeler is an industry-leading datamodeling solution that provides a simple, visual interface tomanage your complex data environment. The ERwin Data Modeler familyof products is made up of a number of distinct editions that aredesigned to meet the needs of a variety of stakeholders across theorganization. ERwin Data Modeler (ERwin) is a software tool for data modeling(data requirements analysis, database design etc.) of customdeveloped information systems, including databases of transactionalsystems and data marts. ERwin’s data modeling engine is based uponthe IDEF1X method, although it now supports diagrams displayed withinformation engineering notation as well. ERwin Data Modeling provides a collaborative data modelingenvironment to manage enterprise data through an intuitive,graphical interface.