Previous Topic: Transact-SQL CommandsNext Topic: Use Mart Server as a Windows Service

Install and Configure a Sybase Mart › How to Install and Configure a Sybase Mart › Install CA ERwin Mart Server

Install CA ERwin Mart Server

The Mart Server and Mart Admin war files are deployed on a Web server. You can either use an existing web server, or install the web server through the CA ERwin MartServer r9.64 Installation Wizard. You must install CA ERwin Mart Server and configure it regardless of whether you use Mart Server as a Windows service.

Note: Ensure that you have reviewed the Install a Mart or Upgrade a Mart topic before proceeding.

  1. Do one of the following tasks:

    The CA ERwin MartServer r9.64(32-bit or 64-bit) Installation Wizard appears.

  2. Go through the wizard steps to install CA ERwin Mart Server.

    Depending on the options you select, CA ERwin Mart Server and/or Java Runtime Environment (JRE) and Tomcat are installed.

    Note: If Java (any version) is already available in the computer and the environment variable JRE_HOME is set, the installer overwrites JRE_HOME with the new Java path. The JRE version that is shipped with the installer is 1.8.

  3. 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 PostgreSQL as the Mart database. Enter the name of the computer where PostgreSQL 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.

    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

Enable SSL for Tomcat

SSL enables you to access the Mart through a secured connection. You can enable SSL for Tomcat--the default web server, when you are installing the Mart for the first time.

Follow these steps:

  1. If the Mart Server service is running, stop it. 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 web server.
  2. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64 (32-bit or 64-bit), Enable SSL for Tomcat Webserver.

    SSL is enabled for Tomcat and a security certificate is created. You must install this security certificate on all the computers from where you want to access the Mart.

  3. 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.

  4. Go to the Mart Administrator tab and select the Transport Layer Security check box.
  5. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64 (32-bit or 64-bit), Start Mart Server Service.
  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).

    The CA ERwin Mart Administrator home page appears and displays HTTPS in the address bar. If a certificate error appears, click Proceed Anyway to begin the session.

Important! If you want to connect to an SSL enabled Mart through API or the Mart Upgrade utility, you must first install the security certificate on the corresponding computer. Install the certificate through the data modeling tool. If you do not install the security certificate, the Mart Upgrade utility and the API will not be able to connect to the SSL enabled Mart.

Disable SSL and Access the Mart Through a Normal Connection

You can disable SSL at any time and access the Mart through a normal connection.

Follow these steps:

  1. If the Mart Server Service is running, stop it. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64(32-bit or 64-bit), Stop 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), Disable SSL.
  3. 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.

  4. Go to the Mart Administrator tab and clear the Transport Layer Security check box.
  5. From the Windows Start menu, click All Programs, CA, ERwin, CA ERwin Mart Server r9.64 (32-bit or 64-bit), Start Mart Server Service.
  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).

    The CA ERwin Mart Administrator home page appears and displays HTTP in the address bar.