How to Initialize (create) an Oracle erwin Model Manager mart? Versions r8 and earlier? (4310789)

Solution

Part I. Preliminary Steps (Oracle DBMS):

NOTE: You will need DBA authority to take some of these steps.
During these instructions the optional names are contained in parentheses (e.g. MMADMIN, MMDATA, MMINDEX).
You may change those names to names of your choice.

1. Create a new database on Oracle.
2. Create two tablespaces, one for data (MMDATA) and one for the indexes (MMINDEX).

   * Make sure there is ~ 70 MB of free space in each tablespace.

3. Create the roles and grant the privileges (you must be logged in as SYS user to perform):

   create role MMUSER;
   create role MMINSTALL;
   grant create sequence to MMINSTALL;
   grant create table to MMINSTALL;
   grant drop public synonym to MMINSTALL;
   grant create public synonym to MMINSTALL;
   grant create procedure to MMINSTALL;
   grant create view to MMINSTALL;
   grant select on dba_roles to MMINSTALL;
   grant select on dba_tablespaces to MMINSTALL;
   grant select on dba_free_space to MMINSTALL;
   grant select on dba_indexes to MMINSTALL;
   grant create session to MMUSER;
   grant MMUSER to MMINSTALL;
    

4. Create the Model Manager (MM) installer user (MMADMIN).

   Make the MM installer user's default tablespace the data tablespace (MMDATA).

    

   
   Figure 1

   Grant the installer user (MMADMIN) the roles DBA, CONNECT, RESOURCE, and MMINSTALL. NOTE: MMUSER is optional.

   
   Figure 2

5. Create the MM users.
   Grant the MM Users the roles CONNECT, RESOURCE, and MMUSER.

   Part II. Installing the MM Software:

   NOTE: the MM software is typically installed on one PC only, usually the MM Administrator's PC or the DBA's PC.

6. Install the erwin MM software. Either,
   1. Launch the one-click (CAEMM73pr10-b2496.exe, or similar).
   2. OR launch setup.exe from the DVD.
7. Follow the prompts to complete the installation of the software.
   
   

   Part III. Initing (creating) the Mart:

   The 'mart' is a repository of tables, indexes, stored procedures, and views on a database. It is stored on the MM installer user's schema.
   He is how you can INIT the mart.

8. On the PC where you installed the MM software (part II), go to Start | Programs | ERwin | ERwin Model Manager (r7.3) | Model Manager.

    

   
   Figure 3

9. The ERwin MM Connection Manager comes up.
   Login as the MM Installer user (MMADMIN).

    

   
   Figure 4

   Press Connect.

   NOTE: at this point two tables will automatically be created on the database: M7master and M7License. These are the initial steps the MM software takes to prepare the mart for the rest of the creation.

10. In the ERwin Model Manager dialog select,

     
    ERwin MM Role:     MMUSER (this is important to make sure the proper privileges are granted to the MM users).
    Table Tablespace:  MMDATA
    Index Tablespace:  MMINDEX
    

    
    Figure 5

11. Press Create.
    
    

    The install chugs along. At the end you are prompted with the ERwin MM Security Manager.

12. In the ERwin MM Security Manager, assign the users to their appropriate MM Security Profiles.
    
    

    NOTE: be sure to assign the MM Installer User (MMADMIN) the MM Administrator profile.

    
    Figure 6

    Press OK.

    You should get a message confirming that your MM creation is now complete.

    
    Figure 7

    Press OK.

    You are done. The individual modelers should now be able to connect to and use the Model Manager mart using their particular copy of CA ERwin Data Modeler.

    NOTE: Each of the individual modelers will also need a copy of the Oracle client software installed.