Databases - j5 - 28.0 - Reference - Hexagon

j5 Hardware and Software Requirements

Language
English
Product
j5
Search by Category
Reference
j5 Version
2019

The following tables describes the database versions supported by the j5 Operations Management Solution:

Microsoft SQL Server

Name

j5 2017

j5 2017.2

j5 2018

j5 2019

Microsoft SQL Server 2019

No

No

No

Yes

Microsoft SQL Server 2017

No

Yes

Yes

Yes

Microsoft Azure SQL Database V12

Yes

Yes

Yes

Yes

Microsoft SQL Server 2016

Yes

Yes

Yes

Yes

Microsoft SQL Server 2014

Yes

Yes

Yes

Yes1

Microsoft SQL Server 2012

Yes

Yes

No

No

Microsoft SQL Server 2008 R2 and older

No

No

No

No

1 This is supported until 28.0 update 36.

  • j5 version 26 (2018) requires MS ODBC Driver version 17.3.1.1 and doesn't support future versions.

  • j5 version 28 (2019) requires MS ODBC Driver version 17 (minimum patch version is 17.3.1.1).

    • You are prompted to install the required MS ODBC Driver during j5 Setup. It's installed automatically when you give j5 Setup permission to process with the installation.

  • Future patch versions of each applicable version can be installed, but they might not be fully tested by the j5 Product Team.

  • The latest Service Packs of older Microsoft SQL Server releases must be used.

Oracle

Name

j5 2017

j5 2017.2

j5 2018

j5 2019

Oracle 19c

No

No

No

Yes

Oracle 18c

No

No

No

Yes

Oracle 12c

Yes

Yes

Yes

Yes

Oracle 11g Release 2

Yes

Yes

No

No

Oracle 11g Release 1

No

No

No

No

PostgreSQL

Name

j5 2017

j5 2017.2

j5 2018

j5 2019

PostgreSQL 13

No

No

No

No

PostgreSQL 12

No

No

No

Yes

PostgreSQL 11

No

No

No

Yes

PostgreSQL 10

No

Yes

Yes

Yes

PostgreSQL 9.6

Yes

Yes

Yes

Yes

PostgreSQL 9.5

Yes

Yes

Yes

Yes

PostgreSQL 9.4

Yes

Yes

Yes

Yes

PostgreSQL 9.3

Yes

Yes

Yes

No

PostgreSQL 9.2

Yes

No

No

No

PostgreSQL 9.1

No

No

No

No