Previous Topic: Initialize a Sybase MartNext Topic: Troubleshooting


Log In to CA ERwin Mart Administrator and Configure Settings

After the Mart is initialized, the user who initialized must log in first. When you log in to Mart for the first time, configure it per the requirements of your organization. You can configure the following settings:

Follow these steps:

  1. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), CA ERwin Mart Administrator r9.64(32-bit or 64-bit).

    The CA ERwin Mart Administrator home page appears. If you have implemented SSL, HTTPS appears in the address bar.

  2. Use the credentials with which you initialized the Mart and log in.
  3. Click Settings.
  4. Complete the following fields:
    Default profile for model creator

    Specifies the profile that is assigned to a user on a model. This profile is assigned whenever a user creates a model and saves it to Mart for the first time. The user inherits the permissions of the default profile selected here on the model that is saved. For example, suppose that User1 is assigned with Modeler profile and the System Administrator selects Architect as the default profile for model creator. If User1 creates Model1 and saves it to Mart, for Model1, User1 inherits the permissions of Architect. Now, suppose that the System Administrator selects Viewer as the default profile for model creator, and suppose that User1 creates Model2 and saves it to Mart. For Model2, User1 inherits the permissions of Viewer.

    Use Default Password

    Specifies the default password that you want to use for new users and for resetting passwords, in the absence of an SMTP server for emails.

    Note: Select this option only if you do not have an SMTP server that is configured for emails.

    SMTP host name

    Specifies the name of the SMTP host. Enter the name in the mail.domain.com format. Notification emails are sent from this server.

    Port number

    Specifies the port number of the SMTP server. The default port number is 25. If your company is using an alternate port number for the mail server, specify that port number.

    Authenticate

    Specifies whether transactions with the SMTP server are authenticated. Select the check box to authenticate.

    User name

    Specifies the user name to authenticate the SMTP server. Select the Authenticate check box to enable authentication.

    Password

    Specifies the password to authenticate the SMTP server. Select the Authenticate check box to enable authentication.

    Administrator email

    Specifies the email ID of the Mart administrator. Notifications to Mart users are sent from this ID.

    No-reply email from

    Specifies the email ID from which administrative emails such as the password reset email are sent.

  5. Click Save.

    Mart options are configured.

You have installed and configured CA ERwin DM Mart.

Back to Top

How to Upgrade any r9 Series Mart to the Current Version

If you are using any earlier release of r9 series and you want to upgrade it to the latest release, upgrade the Mart Server and the Mart database. The Mart server program is upgraded, so you must implement the upgraded software.

Important! The current Mart is designed to work with only the current version of CA ERwin Data Modeler. If you try to connect the current Mart with an older version CA ERwin Data Modeler such as r9.0.0, it may corrupt the Mart and cause unexpected behavior.

The following diagram illustrates how System Administrators can upgrade a Mart from any earlier release of r9 series to the latest release:

Illustrating  how to upgrade a 9.0 Mart to the latest release

Complete the following tasks to upgrade a Mart of any earlier release of r9 series to the latest release:

  1. Review the prerequisites.
  2. Upgrade the Mart Server.
  3. Configure the Mart Server.
  4. Restart the Mart Server service.
  5. Log In to CA ERwin Web Admin.

Back to Top

Review the Prerequisites

Review the following prerequisites before you start the upgrade process:

If the Mart database is an Oracle database, the default tablespaces that were used for initializing the any earlier release of r9 series Mart are available for the latest release.

Back to Top

Upgrade the Mart Server

If you are upgrading a Mart from any earlier release of r9 series to the latest release, upgrade the Mart Server.

Note: See the Install a Mart or Upgrade a Mart topic before proceeding.

Follow these steps:

  1. If you are running MartServer as a Windows service, stop the service.

    Note: If you upgrade the Mart Server without stopping the service, Mart Server may not start after you complete the upgrade process.

  2. Download and run the CAEDMMS964(32-bit or 64-bit).exe file from the CA Support site.

    The CA ERwin Mart Server r9.64(32-bit or 64-bit) Install Shield Wizard dialog appears.

  3. Follow the wizard.

    The Mart Server is upgraded.

  4. Restart your computer.

Back to Top

Configure the Mart Server

To connect to the latest Mart, you must configure the Mart Server. Use the same database that you have used for the r9.0.0 Mart (or any earlier release of r9 series Mart).

Note: See the Upgrade Considerations topic before proceeding.

Follow these steps:

  1. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), Configure MartServer.

    The CA ERwin Mart Configuration dialog appears.

Configure the CA ERwin Mart Server

  1. Complete the following fields in the Mart Server tab:
    Database Type

    Specifies the database server type.

    Port No.

    Specifies the port number of the database server.

    Server Name

    Specifies the name of the database server where you have installed the Mart database. For example, suppose that you are using SQL Server 2008 as the Mart database. Enter the name of the computer where SQL Server 2008 is installed.

    Instance Name

    Specifies the name of the database instance.

    Database Name

    Specifies the name of the Mart database.

    Note: If you are installing the Mart for the first time, use a new database. Do not use an existing database that was created for r7.3 through r8.2.9 Mart. If you are upgrading the Mart from any earlier release of r9 series to the latest release, use the corresponding Mart database.

    User Name

    Specifies the user name to connect to the Mart database. Enter the name of a user that is authenticated by the Mart database.

    Password

    Specifies the password to connect to the Mart database.

    Note: The following fields--Domain Controller Name, Domain/User Name, and Password are required only if you are using the Active Directory authentication. You can use the Active Directory authentication to initialize the Mart and to log in to CA ERwin Mart Administrator.

    Domain Controller Name

    Specifies the fully qualified name of the Active Directory Server (Domain Controller). Enter the name in the following format:

    LDAP://server/distinguished-name
    

    Example: ldap://mktgna:3268/dc=abc, dc=com

    Here, mktgna is the server name. You can provide either the name of the server or the IP address. 3268 is the port number to which the server listens.

    dc=abc, dc=com is the distinguished-name. The distinguished name is the full path of the object.

    Note: If you do not know the Domain Controller Name, use the Nltest command or talk to your System Administrator.

    Domain/User Name

    Specifies the domain name and user name in the <domain name>/<user name> format.

    Password

    Specifies the password of the domain user.

Configure CA ERwin Mart Administrator

  1. Enter the following information in the Mart Administrator tab:
    Server Name

    Specifies the name of the computer where the Web Server is present. For example, if you are using Tomcat, enter the name of the computer where Tomcat is installed.

    Default: localhost

    Port Number

    Specifies the port number on which the Web Server is running.

    Default: 18170

    Application Name

    Specifies the application name with which the Web Server is identified.

    Default: MartServer

    Transport Layer Security

    Specifies if you want to connect to the Mart through a secured connection (SSL). Select this check box if you have implemented SSL.

    Hosting Server

    Specifies that you want to use the IIS web server to connect to the Mart. Select this check box only if you have configured IIS.

  2. Click Configure.

    The CA ERwin Mart Administrator and the Mart Server are configured.

Back to Top

Restart the Mart Server Service

When you modify the details of the Mart Server and Mart Administration programs, restart the Mart Server service.

Follow these steps:

  1. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), Stop MartServer Service to stop the Mart Server service.
  2. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), Start MartServer Service to start the Mart Server service.

Back to Top

Log In to CA ERwin Mart Administrator

Log in to CA ERwin Mart Administrator to verify if you have successfully upgraded the Mart Server from any earlier release of r9 series to the latest release.

Follow these steps:

  1. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), CA ERwin Mart Administrator r9.64(32-bit or 64-bit).

    The CA ERwin Mart Administrator log in page appears. If you have implemented SSL, HTTPS appears in the address bar.

  2. Use the credentials with which you initialized the Mart and log in.

    The CA ERwin Mart Administrator home page appears.

The models that are created in any earlier release of r9 series are upgraded when a user connects to the latest release Mart and opens the models.

Back to Top

Change the Mart Database Server

Sometimes, you may change the server on which the Mart database is installed, or you may restore the Mart database with a new name. When there is a change the server name or database name, reconfigure the MartServer.

Follow these steps:

  1. Back up your Mart database.
  2. Restore the database on the designated server.
  3. If you use the same computer for Mart Server and restore the database in a different name, include the new database name in the CA ERwin Mart Configuration dialog.

    From the Windows Start menu, open the CA ERwin Mart Configuration dialog. In the Mart Server tab, Database Name field, enter the new name with which the database is restored. Enter the current user name and password to access the database. If wrong information is provided here, you may be able to install the Mart, but you cannot log in and cannot use it.

  4. If you use a different computer for Mart Server and restore the database in the same name, install the Mart Server on the new computer.

    Use the Install CA ERwin Mart Server procedure and install the Mart Server. In the Mart Server tab, Server Name field, enter the name of the new server where the database is restored. Enter the current user name and password to access the database. If wrong information is provided here, you may be able to install the Mart, but you cannot log in and cannot use it.

  5. Stop the MartServer service and start it again.
  6. From the Windows Start menu, click All Programs, CA, ERwin, ERwin Mart Server r9.6, CA ERwin Mart Administrator r9.6.

    Enter the credentials of the Mart administrator and log in.