Installation and Configuration › Prepare for the Installation

Prepare for the Installation

Review the hardware and software requirements and the list of supported databases in the Release Notes before you install the program. You must verify that your system requirements meet at least the minimum specified requirements, and that you have verified and prepared your DBMS environment for installation.

Before you can install CA ERwin Data Modeler Workgroup Edition in your DBMS environment you must do the following:

1. Create the database on your DBMS server.
2. Install or upgrade your license permitting access to and initialization of the mart.
3. Create the mart or upgrade your current version of software when a newer version is available.

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

If you installed an earlier version of the product (before r8, such as CA ERwin Model Manager) it is not necessary to remove that version. Because this version is installed to a new folder, you can continue to work with the earlier version, if you have sufficient disk space on your PC for both versions. However, when you upgrade to r8, you must be at r7.x or later in order to convert existing models to r8. Additionally, before you can use the Submodel Manager to work with models in the mart, you must first upgrade each r7.x model to r8.