Previous Topic: Create a Pluggable DatabaseNext Topic: Troubleshooting

Install and Configure an Oracle Mart › How to Install and Configure an Oracle Mart › Log In to CA ERwin Mart Administrator and Configure Settings › Install CA ERwin Mart Server with a Pluggable Database

Install CA ERwin Mart Server with a Pluggable Database

The procedure to install CA ERwin Mart Server for a pluggable database is same as the procedure for a normal database. This topic describes only those fields that need different values for a pluggable database. For more information on how to configure the CA ERwin Mart Server, see the Install CA ERwin Mart Server topic.

The following fields on the Configure the CA ERwin Mart Server dialog need different values:

Server Name

Specifies the name of the database server where you have installed the Mart database. Enter the name of the computer where Oracle 12c is installed and the pluggable database erwin_test is created.

Database Name

Specifies the name of the pluggable Mart database. For example, erwin_test.

User Name

Specifies the user name to connect to the Mart database. Enter mmadmin or any other user account that you have created when you ran the script.

Password

Specifies the password to connect to the Mart database. Enter mmadmin or any other password that you have created when you ran the script.

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, CA ERwin Mart Server r9.64(32-bit or 64-bit), CA ERwin Mart Administrator r9.64(32-bit or 64-bit).

    Enter the credentials of the Mart administrator and log in.