Installation and Configuration › How to Prepare Your DBMS Environment

Previous Topic: Specify Use of Foreign Characters With Microsoft SQL Server 2005

Next Topic: Tasks to Create a Microsoft SQL Server DBMS

How to Prepare Your DBMS Environment

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

  1. Install the DBMS.

    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 the supported versions of 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: Each user must have Windows authentication enabled (on databases that support Windows authentication) or a valid login name on the DBMS and permission to access the database in which the mart is stored. For more information, see your DBMS administrator's documentation.

  4. Install the DBMS client software on each client workstation.

    To connect a client workstation to the DBMS server, you must install the appropriate client connection software (for example, SQL*Net) on each workstation. The connection software you use depends on your DBMS type.

  5. Verify the client/server connection.

    Use a test command (for example, ping) to check 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 check the connection. For more information about testing the client/server connection, see your DBMS documentation.

  6. Install the client software on each workstation that needs to access the mart.

    Install the client so that any user with a mart login and password and the appropriate DBMS client connection software can connect to the mart from that client workstation.