Installation and Configuration › How to Prepare Your DBMS Environment

How to 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.

3. Create a user profile for each CA ERwin Data Modeler Workgroup Edition user.

   Use the DBMS features to create a user profile for each user in the database where the mart is stored.

   Note: Users must have Windows authentication enabled on databases that support Windows authentication. In addition, users must have valid user accounts and permissions to access the database where the mart is stored. For more information, see your DBMS documentation.

4. Install the DBMS client software on each client workstation that has to access the mart.

   To connect a client workstation to the DBMS server, install the appropriate client connection software (for example, SQL*Net) on each workstation. The connection software you use depends on your DBMS type. Install the client so that any user with a mart user account and the appropriate DBMS client connection software can connect to the mart.

5. Verify the client/server connection.

   Use a test command (for example, ping) to verify the client/server connection between each client workstation and the DBMS server. Alternatively, use another application on a client workstation (for example, ISQL/W, SQLPLUS, or PowerBuilder) to verify the connection. For more information about testing the client/server connection, see your DBMS documentation.