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 CA ERwin Data Modeler 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.

Review the installation and licensing information in the CA ERwin Data Modeler Installation Guide. All of the information necessary to properly install and license this product is in this guide.

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 in CA ERwin Data Modeler Workgroup Edition, 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 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.