Installation Notes for ER/Studio Team Server

From TeamServer ER/Studio
Jump to: navigation, search

Go Up to Getting Started with ER/Studio Team Server

These notes provide important information about installing ER/Studio Team Server. You should read this document in its entirety before any install or uninstall procedure.

Minimum Requirements

ER/Studio Team Server is a 32-bit server application that runs in a Microsoft Windows environment. Before installing ER/Studio Team Server, verify that your environment meets the hardware and operating system requirements.

Hardware Requirements

The minimum hardware requirements are:

Hardware Minimum Requirement


4 GB


2 x 3.0 Ghz - Dual Core

Disk Space

740 MB for program installation. You will need additional space available for data storage, for example 100mb per diagram.

Notepad blue icon 2.pngNote: Should you be running the minimum spec requirements, it is advised to reduce the maxThreads to a single thread. To do this, edit ...tomcat>webapps>api>WEB-INF>ersportal-app.xml and change the line <property name="maxThreads" value="2" />, to have a value of "1" (a restart is required after saving the change).

Recommended hardware:

  • CPU: 4 x 3.0 Ghz
  • RAM: 8 GB

System Requirements

Your machine must be running the Microsoft Windows operating system. The following versions of Microsoft Windows are supported:

  • Microsoft Windows 2012 R2 Server (64-bit only)
  • Microsoft Windows 2012 Server
  • Microsoft Windows 2008 R2 Server
  • Microsoft Windows 2008 Server (32-bit or 64-bit)
  • Microsoft Windows 2003 Server (32-bit only)

Notepad blue icon 2.pngNote: ER/Studio Team Server can run on Windows XP, Windows Vista and Windows 7-8, but this is not recommended for an operational system, only for testing purposes.

  • To install ER/Studio Team Server on Windows 7, you need to run the installer in Windows XP or Windows Vista compatibility mode.
  • If the SQL server is also running when installing on Windows 8, the instance needs to be part of the SQL server name. The services and protocols also need to be running or enabled as documented below for SQL Server 2014.

ER/Studio Repository

ER/Studio Team Server works against an installation of ER/Studio Repository. Prior to installing ER/Studio Team Server, you need a working installation of ER/Studio Repository. ER/Studio Team Server supports versions 6.0, and 6.5 of ER/Studio Repository.

If you have enough RAM for both applications, we recommend that you install ER/Studio Team Server on the same machine where the ER/Studio Repository server is installed. Otherwise, the machine where you install ER/Studio Team Server must have network access (over a local network or over the Internet) to the machine where ER/Studio Repository is running.

Supported Database Platforms

The Reporting Repository is the database that ER/Studio Team Server uses to store the information that it gathers from the ER/Studio Repository. The Reporting Repository database also stores the reports from previous queries and the metadata they rely on.

The Reporting Repository database may run on any of the following database platforms:

  • Oracle 9i, 10g, and 11g (Not supported on Microsoft SQL Server 2012 environments)
  • IBM DB2 UDB 8.x, 9.x and 10.x Server
    Notepad blue icon 2.pngNote: Before installing ER/Studio Team Server on the DB2 platform, you must first create the Reporting Repository database. Allocate 32K for the tablespace pagesize. Also UTF-8 should be selected when configuring your DB2 DB.
  • Microsoft SQL Server 2005 to 2014

Important Information

Ensure that the database is set to case-insensitive, as case-sensitive is not supported. Also set the SQL Server Configuration Properties to allow SQL Server authentication. ER/Studio Team Server only supports SQL Server Authentication.

When installing over SQL Server 2014 (any Operating System), use the SQL Server Configuration Manager and make sure that the following services are running:
SQL Server
SQL Server Agent
Also that following protocols are enabled:
Shared Memory
Named Pipes

Supported Web Browsers

The following web browsers are tested to work with ER/Studio Team Server. Other browsers may work, but are not officially supported:

  • Mozilla Firefox
  • Google Chrome
  • Microsoft Internet Explorer (9.0 or later)


Do not install ER/Studio Team Server on a system where ER/Studio Data Architect, ER/Studio Business Architect or a previous version of ER/Studio Team Server is installed. If the ER/Studio Team Server installer detects an installation of any of these applications, the installer asks you to uninstall these applications before you proceed.

There may be naming conflicts between the ER/Studio Repository and the Reporting Repository. If both repositories are installed on the same database server, you should use different schema owners.


To install ER/Studio Team Server:

  • The installation user account must have local administrative privileges.
  • The ER/Studio Repository server and the database server to be used for the ER/Studio Team Server Reporting repository must be running.
  • In order to install, you need to create first an empty database for ER/Studio Team Server, unless you already have a database and will be reinitializing it during the install.

Optional Features

Active Directory Users Support

The installation must include configuration of LDAP functionality to allow directory service users to log in to ER/Studio Team Server. You can alternatively enable LDAP authentication after the installation.

Email Support

SMTP server configuration must be done in order to fully support email notifications based on user activity. You can alternatively enable email support after the installation.

Third-Party Software That Is Installed with ER/Studio Team Server

ER/Studio Team Server depends on some third-party software that the ER/Studio Team Server installation wizard installs automatically on your system. That third-party includes:

Installing and Upgrading

If you meet the minimum requirements, you can proceed to install ER/Studio Team Server. See Installing ER/Studio Team Server.

If you have installed a previous version of ER/Studio Team Server (for example, any version of Embarcadero CONNECT or ER/Studio Portal), see Upgrading ER/Studio Team Server.

After Installing

After the installation is complete, you must synchronize the ER/Studio Team Server database with the ER/Studio Repository database to ensure that it is up to date.

See Installing ER/Studio Team Server, Next Steps for more information.

See Also