Previous Topic: Install and Configure a Sybase MartNext Topic: Mart Architecture


How to Install and Configure a Sybase Mart

In the previous versions, CA ERwin Data Modeler connected to the Mart server directly. Now, CA ERwin Data Modeler connects to the Mart server through a web server.

The Mart comprises the following components:

Database

Stores the user data for the Workgroup Edition. You can use a Sybase Adaptive Server Enterprise 15.0 through 15.7 database for the Mart database. You must use a new database and not an existing database that was created for an older version of the data modeling tool.

Applications

Includes a web-based component named CA ERwin Mart Administrator that helps you manage the Mart through a web console.

Web server

Hosts CA ERwin Mart Administrator. You can use a web server of your choice. If you have not installed a web server, use the ERwin Mart Server option and install Tomcat.

If you are using the Workgroup Edition, you must install and configure CA ERwin Mart Administrator.

Note: The procedure to upgrade a Mart from r9.0.0 to r9.2.0 is different from the procedure to upgrade from r7.3 through r8.2.7 to r9.2.0. If your Mart version is r9.0.0, use the How to Upgrade a Mart from r9.0.0 to r9.2.0 procedure to upgrade your Mart to r9.2.0. The models that are created in r9.0.0 are upgraded when a user connects to the r9.2.0 Mart and opens the models. If your Mart version is r7.3 through r8.2.7, use the Installing and Configuring the Mart procedure and install the r9.2.0 Mart. After installing the Mart, use the Upgrade Mart utility to upgrade the Mart models from r7.3 through r8.2.7 to r9.2.0.

The following diagram illustrates how to install and configure Mart:

Illustrating how to install a Sybase Mart

Complete the following steps to install and configure a Mart:

  1. Review the prerequisites for a Sybase Mart.
  2. Create a Sybase Database.
  3. Install CA ERwin Mart Server.
  4. Use MartServer as a Windows Service.
  5. Initialize Mart.
  6. Log in to CA ERwin Mart Administrator and configure settings.

Complete the following steps to upgrade a Mart from r9.0 to r9.1:

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

Back to Top