System Information › CA ERwin Data Modeler Workgroup Edition Requirements › DBMS Requirements

DBMS Requirements

Before you install CA ERwin Data Modeler r8.1 to use in a workgroup environment, ensure you are using a supported DBMS as your host server. r8.1 supports the following host DBMSs:

• Oracle 10g/11g
• SQL Server 2000/2005/2008
• Sybase 12.x/15

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.

Before you can install the mart on the server, you must verify that the DBMS environment is prepared for the installation, and that the server system requirements meet at least the minimum specifications. The administrator of the DBMS must also set up user permissions for the mart.

Note: The dbo role for Microsoft SQL Server or Sybase is necessary only during the installation or upgrade. You can strip the installer of the dbo role after the installation or upgrade is complete.

For more information about preparing the DBMS environment, see the CA ERwin Data Modeler Workgroup Edition Implementation Guide.