Database Requirements for TopTeam Repository

Overview

TopTeam application supports the following databases:

• Oracle
• Microsoft SQL Server
• Firebird

This article explains the compatible database versions and requirements for connecting TopTeam Application Server and TopTeam Web Server with the databases listed above.

Who should read this?

• TopTeam Administrators
• IT Support

Oracle Database

1. Compatible Versions

TopTeam is compatible with the following version of Oracle Database of any edition i.e. Standard, Enterprise, and Express editions:

1. Oracle 19c
2. Oracle 18c
3. Oracle 12c
4. Oracle 11g

For TopTeam Desktop App and Oracle Server compatibility, refer to TopTeam Desktop App Compatibility Guide.

2. Connection Requirements

1. TopTeam Application Server and TopTeam Web Server can connect to Oracle Server in the following ways:

• When Oracle Server is running on the same computer on which TopTeam Application Server and/or TopTeam Web Server is installed.
• When Oracle Server is running on a remote computer that is different from the one on which TopTeam Application Server and/or TopTeam Web Server is installed.

2. If TopTeam Application Server/TopTeam Web Server is running on a computer on which Oracle Server is not installed, the Oracle Client libraries compatible with Oracle Server should be installed.

3. TopTeam Application Server/TopTeam Web Server and TopTeam Database Schema installer cannot connect to 64 bit Oracle Server using 64 bit Oracle Client. However, 32 bit Oracle Client can interface with 64 bit Oracle Server. In that case, you need to install 32 bit Oracle Client on the computer on which TopTeam Application Server for Oracle or TopTeam Web Server for Oracle is being installed.

4. If TopTeam Server components are being installed on the same computer on which Oracle 64 bit Server is installed, you need to install Oracle 32 bit Client on it, however, in a separate Oracle Home. The 32 bit Client can co-exist with 64 bit Oracle installation when it is installed in a separate Oracle Home directory.

5. Oracle Instant Client is not supported by TopTeam.

3. Configuration Requirements

TopTeam does not support Multibyte/Unicode Oracle character sets. “WE8MSWIN1252” is the recommended Oracle character set. You can choose any single-byte character set depending on your organization’s standards.

Microsoft SQL Server

1. Compatible Versions

TopTeam is compatible with the following versions of SQL Server Database of any edition .i.e. Standard, Workgroup, Enterprise, or Express editions:

1. SQL Server 2022
2. SQL Server 2019
3. SQL Server 2017
4. SQL Server 2016
5. SQL Server 2014
6. SQL Server 2012

For TopTeam Desktop App and SQL Server compatibility, refer to TopTeam Desktop App Compatibility Guide.

2. Connection Requirements

TopTeam Application Server and TopTeam Web Server can connect to SQL Server and requires:

1. The computer on which TopTeam Application Server is installed should have MDAC (Microsoft Data Components) version 2.8 or higher. You can verify this by connecting to TopTeam SQL Server Database using SQL Server Management Studio from the computer on which TopTeam Application Server is being installed.
2. The computer on which TopTeam Web Server is installed should have SQL Server Native Client component installed. For more information on SQL Server Native Client, refer to the article Requirements for TopTeam Web Server for SQL Server Database.
3. When TopTeam Application Server is running as a Windows Service and is configured to connect to SQL Server using Windows Authentication, ensure that the credentials under which the TopTeam Application Server service is running have privileges to access SQL Server.
4. Ensure that SQL Server user password which is used to connect to the database in TopTeam Application Server and TopTeam Web Server, will not expire or should not have an expiry. When a user connects to TopTeam Server, a database connection gets created on TopTeam Server for that user. If SQL Server user password has expired, the TopTeam user will not be able to connect to TopTeam Servers.

3. Configuration Requirements

1. TopTeam requires that row versioning based isolation levels should be enabled.
2. The “Allow Triggers to Fire Others” (Recursive Triggers) setting should be enabled, which is an SQL Server instance level setting.
3. Default schema of the database user who is either installing or upgrading TopTeam Database should be “dbo” (Database Owner).
4. TopTeam Database should not be a Contained Database. Contained Database is one of the SQL Servers features which isolates a database with other databases in the same SQL Server instance.

Firebird Database

NOTE: TopTeam version 11 or higher does not support Firebird Database. If you use Firebird as your database and wish to upgrade to version 11 or higher of TopTeam, you need to migrate your database to Oracle or Microsoft SQL Server. Please contact TechnoSolutions Support who will provide you with the utility to perform this migration.

1. Compatible Versions

TopTeam is compatible with the following version of Firebird Database:

1. Firebird 1.5.5

2. Connection Requirements

TopTeam requires Firebird Database version 1.5.5. You can install this version of Firebird Database using the installer for TopTeam Application Server for Firebird.

See Also

System Requirements for TopTeam Components

How to establish a connection with SQL Server instance configured to listen on non-standard port

Revised: November 20th, 2023