Mart Architecture

Install and Configure a SQL Server Mart › How to Install and Configure a SQL Server Mart › Mart Architecture

Mart Architecture

In the previous versions, CA ERwin DM connected to the Mart database through the database client software. Now, the application connects to the Mart database through a web server. The database client software is no longer required. The web server includes a web-based administration console—CA ERwin Mart Administrator. If you are using the Workgroup Edition, you must install and configure CA ERwin Mart Administrator.

Database: Stores the user data for the Workgroup Edition. You can use a Microsoft SQL Server 2005, 2008, 2012, 2014, or 2014 SP1 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.

The following diagram shows the new architecture:

Mart architecture new

The new architecture has the following benefits:

Separate logical and physical users: In the previous versions, Mart (or Model Manager) users required database level privileges to access the Mart functionality. The Mart database administrators added or deleted users in the Mart database. This approach is changed now. The logical users are separated from physical users, so Mart Administrators can create the Mart users without creating the corresponding database users.
Authentication through Active Directory services: Earlier, if you wanted to provide access to a user group, you added each user individually. Now, because of the new architecture, you can use the Active Directory services and can provide access to the group. Anyone who is part of the group gets access.
Mart administration outside CA ERwin Data Modeler: In the previous versions, Mart Administrators used CA ERwin Data Modeler for administrative activities such as managing permissions. This required non-modelers to know how to use CA ERwin Data Modeler. In the new architecture, the administration component is built on a separate layer on top of CA ERwin Data Modeler and is hosted on a web server. Mart Administrators can access CA ERwin Web Admin from any computer and can perform administrative activities through a web console.