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

DBMS Requirements

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

• Oracle 10g and 11g
• Microsoft SQL Server 2000, 2005, 2008, and 2012
• Sybase 15.x

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 2005, 2008, and 2012 you must be the database owner (dbo).

  Notes:

  • The dbo is no longer required to have the sysadmin role.
  • The SQL Server 2005, 2008, and 2012 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 install Mart on the server, verify that the DBMS environment is prepared for the installation, and that the server system requirements meet at least the minimum specifications. At least one user with administrative privileges is available on the DBMS.

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.