

Install and Configure a SQL Server Mart › How to Install and Configure a SQL Server Mart › Review the Prerequisites for a SQL Server Mart
Review the Prerequisites for a SQL Server Mart
Before you install the Mart components, help ensure that the minimum system requirements that are outlined in this topic are met.
You can use any of the following combinations to install CA ERwin Data Modeler, the Mart database, and the MartServer application:
- Install CA ERwin Data Modeler, the Mart database, and the MartServer application on the same computer.
- Install CA ERwin Data Modeler, the Mart database, and the MartServer application on different computers.
- Install CA ERwin Data Modeler and the Mart database on one computer, and install the MartServer application on a different computer.
- Install CA ERwin Data Modeler on one computer, and install the Mart database and the MartServer application on a different computer.
Help ensure that you always install the MartServer application on the Windows operating system.
System requirements to install the MartServer application
Hardware requirements (based on physical hardware performance, not a virtual environment):
- 2 GHZ or higher dual core processor
- 4 GB RAM (8 GB or more for large marts)
- 4 GB of disk space or more as required to support your specific mart
Operating system:
- Microsoft Windows Vista
- Microsoft Windows Server 2008 SP2
- Microsoft Windows Server 2003 SP2
- Microsoft Windows XP SP3
- Microsoft Windows 7
- Microsoft Windows 8
- Note: CA ERwin Data Modeler has only been certified on the 32-bit versions of the Windows operating systems described in the preceding list. CA ERwin Data Modeler is a 32-bit application, so you may experience problems running this application on a 64-bit operating system.
- Microsoft .NET Framework 3.5 or higher
- All current Microsoft Windows critical updates are applied
Database:
- The Mart Server can use a standalone or can share an existing database server for a Microsoft SQL Server 2005, 2008, or 2012 database.
- The SQL Server 2005, 2008, and 2012 TRUSTWORTHY database property is no longer required for the mart. After you install this product, you can optionally reset this property to OFF.
- The dbo role for Microsoft SQL Server is necessary only during the installation or upgrade. You can strip the installer of the dbo role after the installation or upgrade is complete.
CA ERwin Mart Administrator web client:
- Supported browsers:
- Microsoft Internet Explorer 8® or newer
- Mozilla Firefox® v.9.0 or newer
- Google Chrome 14 or newer
- Apple Safari 5 or newer
- Adobe Flash plug-in version 8 or newer for the respective browser
Other requirements
Help ensure that the following additional requirements are met:
Important disclaimer notice on all requirements
- The requirements that are mentioned previously define the minimum requirements which permit the application to run with reasonable performance based on a small business use case scenario. The actual requirements for an enterprise-wide use case based on larger models and configurations require significantly greater resources to obtain acceptable performance.
- These requirements are based on actual physical hardware (no virtual environment) and the following assumptions:
- Minimal to no network overhead (both the database and application servers are locally installed)
- Vendor's default install of the current version of their software (with all current service or fix packs)
- No other applications sharing the defined hardware configuration (for example, a “clean” machine)
Any other hardware/software configurations are acceptable as long as they provide the same (or better) performance characteristics identified.
Back to Top
Copyright © 2013 CA.
All rights reserved.
 
|
|