Previous Topic: Install and Configure a SQL Server MartNext Topic: Mart Architecture


How to Install and Configure a SQL Server 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 Microsoft SQL Server 2005, 2008, 2012, or 2014 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.

Note: CA ERwin Data Modeler does not support creating a database in a Server Cluster environment.

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.

The following diagram illustrates how to install and configure a Mart:

Illustrating how to install a SQL Server Mart

Complete the following steps in the same order to install and configure the Mart:

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

Back to Top