Install and Configure a Sybase Mart › How to Install and Configure a Sybase Mart › Review the Prerequisites for a Sybase Mart

Review the Prerequisites for a Sybase 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.
• Install CA ERwin Data Modeler and the MartServer on one computer, and install the Mart database 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 7
• Microsoft Windows 8.1
• Microsoft Windows 10
• Microsoft Windows 2012
• Microsoft .NET Framework 3.5 and above
• 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 Sybase Adaptive Server Enterprise 15.0 through 15.7 and SAP Adaptive Server Enterprise 16 database.
• The dbo role is necessary only during the installation or upgrade. You can revoke the dbo role for the installer after the installation or upgrade is complete.

(Optional) To use the Korean language, configure the server manually to use Cp949, Utf8, or eucksc character set. These character sets apply to a 64-bit Windows 7 computer running the Korean language pack. When you configure the server, help ensure that you perform the following tasks:

1. Add the language and set it as default.
2. Select the character set and set it as default.

   Note: PC (MS) Korean stands for cp949 character set. Extended Unix Code for KSC-5601 stands for eucksc character set. Unicode 3.1 UTF-8 Character Set stands for utf8 character set.

3. Select the default sort order.

   For more information, see the Sybase documentation. Create the Mart database after you perform the tasks that are mentioned earlier.

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:

• If you want to use Microsoft IIS as the web server, you have configured it.
• The DBMS is installed and prepared for creating the Mart Database.
• The Mart database is created. At least one user with administrator privileges is present.
• If you want to add Windows Group users as Mart users, you have the Active Directory Server details.

  Note: You can add Windows Group users as normal Mart users, but not the Mart administrator. A Mart administrator must be a database-authenticated user.

Important disclaimer notice on all requirements

1. 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.
2. 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