Installing and Configuring Mart › Prepare Your DBMS Environment

Prepare Your DBMS Environment

Perform the following setup tasks in your DBMS environment before you can install and use the software:

1. Install the DBMS on the server where you plan to store the mart.

   For more information about memory and disk space requirements, see the system requirements for each DBMS (Microsoft SQL Server, Sybase, and Oracle).

2. Create the mart.

   Use the DBMS features to create or identify the required storage objects and the mart. The specific requirements vary depending on your DBMS type.

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, 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.