Compatibility of databases with Enterprise Server

This article lists the compatibility of databases with Enterprise Server.

When the database and the Application Server run on different machines, Enterprise does not add extra restrictions to the operating system that runs the database. When both are running in the same box the choice of the operating system is limited, as specified for the Application Server.

Aside from the above, the following limitations exist:

To connect to Microsoft SQL Server, the Application Server must run on a Windows Server as well. This is because the database driver for Microsoft SQL Server is not maintained for Mac OS X and Linux.

There is no Oracle 11 or 12 for Mac OS X.

Microsoft SQL

Enterprise Server version

Database version

9.8.x

10.0.x – 10.1.x

10.2.x – 10.5.x

10.6.x or higher

Microsoft SQL Server 2012

Yes

Yes

-

-

Microsoft SQL Server 2014

Yes R

Yes R

Yes

-

Microsoft SQL Server 2016

-

-

Yes R

Yes

Microsoft SQL Server 2017

-

-

-

Yes

Legend: Yes = combination is supported. Yes R = recommended combination. - = combination of old and new software versions is not supported.

Older versions

Show the compatibility between older versions of Microsoft SQL and Enterprise Server

Enterprise Server version

Database version

9.0.x – 9.4.x

9.5.x – 9.7.x

Microsoft SQL Server 2008

-

-

Microsoft SQL Server 2008 R2

Yes

-

Microsoft SQL Server 2012

Yes R

Yes

Microsoft SQL Server 2014

-

Yes R

Legend: Yes = combination is supported. Yes R = recommended combination. - = combination of old and new software versions is not supported.

MySQL

Enterprise Server version

Database version

9.8.x

10.0.x – 10.5.x

10.6.x or higher

MySQL 5.5

Yes 1

-

-

MySQL 5.6

Yes R, 1

Yes

-

MySQL 5.7

-

Yes R

Yes

MySQL 8.0

-

-

Yes

Legend: Yes = combination is supported. Yes R = recommended combination. - = combination of old and new software versions is not supported.

1 Note that compared to MySQL 5.5, the performance of MySQL 5.6 has much improved.

Older versions

Show the compatibility between older versions of MySQL and Enterprise Server

Enterprise Server version

Database version

9.0.x – 9.4.x

9.5.x – 9.7.x

MySQL 5.1

-

-

MySQL 5.5

Yes R

Yes 1

MySQL 5.6

-

Yes R, 1

MySQL 5.7

-

-

Legend: Yes = combination is supported. Yes R = recommended combination. - = combination of old and new software versions is not supported.

1 Note that compared to MySQL 5.5, the performance of MySQL 5.6 has much improved.

Oracle

Enterprise Server version

Database version

9.8.x

10.0.x – 10.1.x

10.2.x or higher

Oracle 11 1, 2

Yes R

Yes

-

Oracle 12.1 1, 2

Yes

Yes R

-

Legend: Yes = combination is supported. Yes R = recommended combination. - = combination of old and new software versions is not supported.