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


Connect to Mart

If you are using CA ERwin Data Modeler Workgroup Edition, you connect to the Mart to access models and perform administrative functions.

The way CA ERwin Data Modeler connects to the Mart has been redesigned now. In the previous versions, CA ERwin Data Modeler would connect to the Mart (database) server directly. Now, CA ERwin Data Modeler connects to the Mart through a web server. You can connect multiple instances of CA ERwin DM to the Mart from your computer.

At the time of logging on to Mart, you must provide the details about the web server and the Mart.

Follow these steps:

  1. Click Mdl Mgr Connection icon on the toolbar, or click File, Mart, Connection.

    The Connect to Mart dialog opens.

  2. Complete the following fields:
    Server Name

    Defines the name of the web server where you have installed the Mart.

    Port

    Specifies the port number to access the web server.

    Use IIS

    Specifies that you want to use the IIS web server to connect to Mart. This check box is enabled only if you have configured IIS. For more information about configuring IIS, see the Implementation Guide (Workgroup Edition).

    Use SSL

    Specifies that you want to connect to the Mart through a secured connection. SSL lets you access the Mart through a secured connection. This check box is enabled only if you have configured SSL on your web server. For more information about configuring SSL, see the Implementation Guide (Workgroup Edition).

    Application Name

    Defines the application name of the Mart that you want to connect to.

    Authentication

    Specifies the type of authentication you want to use.

    User Name

    Defines the name of the user.

    Password

    Defines the password of the user.

  3. Click Connect.

    If you have selected Use SSL and the security certificate is installed, you are connected to the Mart.

    Note: After you connect to the Mart, if you click Connect to Model Manager again, a dialog opens seeking your permission to disconnect from the Mart.

    If your security certificate is not installed, the message The certificate authority is invalid or incorrect appears. You must install the security certificate to proceed.

    1. Click OK on the message.

      The SSL Certificate Install dialog appears.

    2. Click Install.

      The Certificate dialog appears.

    3. Click Install Certificate.

      The Certificate Import Wizard dialog appears.

    4. Click Next.
    5. Click the Place all certificates in the following store option button and click Browse.
    6. In the Select Certificate Store dialog, select Trusted Root Certification Authorities and click OK.
    7. Click Finish.

      The security certificate is installed and you are connected to the Mart.

More information:

Mart Architecture

Disconnect from Mart

SSL Security Certificate

If your Mart is SSL security-enabled, you must install the security certificate, when you access the Mart for the first time. The System Administrator creates the security certificate while implementing SSL. Install the certificate on every computer that you use to connect to the Mart.

Be sure to install the certificate under the Trusted Root Certification Authorities certificate store.