CA ERwin Data Modeler Workgroup Edition › The Administrator's Tasks › Convert or Update a Mart

Convert or Update a Mart

The model is not fully converted or updated until you initialize the mart and initially open and save the model in the mart with CA ERwin Data Modeler.

Note: When you first open the model, it can take a few minutes longer to complete the process.

To convert a mart

1. Log on to your DBMS that contains the mart. 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).

     Notes:

     • The dbo is no longer required to also have the sysadmin role.
     • The SQL Server 2005/2008 TRUSTWORTHY database property is no longer required for the mart. After you install this product, you can optionally reset this property to OFF.
   • For Oracle, you must be the database schema owner and have the DBA role.
2. Click Mart, Initialize Mart on the File menu.

   The Connection Manager dialog opens.

   

3. Complete the following information:

   Database

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

   Authentication

   Windows Authentication

   Specifies the use of Windows user names and passwords to secure database access.

   Database Authentication

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

   Parameters/Value Options

   Connection Type (Microsoft SQL Server 2005/2008 Only)

   Specifies the use of Native Connection to connect using 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 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 populate the Database or Connection String previously used automatically.

4. Click Connect.

   The Mart dialog opens.

   

5. Select from the following options:

   Database (SQL and Sybase DBMS)

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

   CA ERwin Data Modeler Workgroup Edition Role (Oracle DBMS)

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

   Table Tablespace

   Indicates where you want to store the mart tables.

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

   Index Tablespace

   Indicates where you want to store the mart 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.

6. Select one of the following after verifying the mart name in the Status window:

   Create

   Creates an empty mart. You can manually open and save existing CA ERwin Data Modeler models to this new mart.

   Update

   Creates a new mart with the current version and updates the data from the old mart to the new mart. The Update button is enabled only when an earlier version of the software is detected. When you update your mart, the old mart is no longer usable in the previous version.

   Note: The Create and Update buttons are mutually exclusive and the text of the button changes depending if a previous version of the mart is detected. If the Create button is not enabled, then a previous version of a mart is detected.

   Convert

   Creates a new mart with the current version and copies the data from the old mart to the new mart. The old mart is retained in the same database.

   The dialog displays conversion progress messages.

7. Click OK in the Upgrade has Successfully Completed message dialog.

   The Mart dialog displays the status.

   

8. Click Close.

   The administrative setup is complete.

9. Click OK on the Setup Complete dialog.

   The conversion is complete.

The same user profile assignments exist as before the conversion. If you must make changes to user profiles, click Mart, Security Manager on the File menu to open Security Manager.