You must perform the following setup tasks in your DBMS environment before you can install and use the software:
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).
Use the DBMS features to create or identify the required storage objects and the mart. The specific requirements vary depending on your DBMS type.
Use the DBMS features to create a user profile for each CA ERwin MM user in the database where CA ERwin MM 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.
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.
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.
Install the client software using the CD-ROM that shipped with each client (CA ERwin Data Modeler or CA ERwin Process Modeler). Then, any user with a CA ERwin MM login and password and the appropriate DBMS client connection software can connect to the mart from that client workstation.
| Copyright © 2010 CA. All rights reserved. | Email CA about this topic |