Database Management Systems (DBMSs)

Lists supported and tested DBMSs along with the Enterprise Test Server features that use them.

All RDBMS testing is done on both 32- and 64-bit platforms based on RDBMS client software availability.

With regard to support for each of these third-party RDBMS supported version, Micro Focus :

  • Provides support until the standard end-of-service (EOS) date provided by the RDBMS vendor
  • If your deployment requires support for a given RDBMS beyond the vendor's EOS dates, check with Customer Care for availability of Extended Support Plus options.
  • Encourages you to include third-party RDBMS consideration when planning an upgrade to your Micro Focus product

With regard to resolving reported issues with Micro Focus software while using a third-party RDBMS, Micro Focus :

  • Attempts to resolve issues for supported DBMSs on tested or untested platforms
  • Investigates issues involving planned but not yet supported RDBMSs, and attempts to resolve non-architectural issues that also occur in the latest supported RDBMS version

This version of Enterprise Test Server supports the following Database Management Systems:

COBSQL (Pro*COBOL)

Back to Top

Before deploying a COBSQL application, be sure to install and configure all applicable third-party software.

Note: COBSQL (Pro*COBOL) is supported for native COBOL only.
Availability
Feature/Platform 32-bit 64-bit
x86-64 running Windows X X
XA Switch Module
The Oracle XA switch module is provided for COBSQL (Pro*COBOL), and is available on the same platforms as are indicated in the Availability section above. Oracle Instant Client fully supports all 1PC functionality with Pro*COBOL applications.
Restriction: The Oracle Instant Client does not support the 2PC functionality of the Oracle XA switch module. To use 2PC functionality with Pro*COBOL applications, you must install Oracle Client, not Instant Client.
Testing
For this version, COBSQL was tested with Oracle Pro*COBOL versions 18c and 19c.

Data Manager

Back to Top

Restriction: Data Manager is available in Enterprise Test Server Premium only. To obtain a license for Enterprise Test Server Premium, contact Micro Focus Customer Care.

The following third-party software is required:

  • IBM DB2
    Note: Although not explicitly required, we recommend that your Windows machine have a direct connection to the DB2 database through DB2 Connect.
    • When using Gateway DB2 Connect Enterprise Edition to directly connect, you must also use IBM DB2 Connect Personal Edition version 6.1 or later
    • If not using Gateway DB2 Connect Enterprise Edition, use either IBM DB2 Client Application Enabler for Windows version 6.1 or later, or IBM DB2 Connect Personal Edition version 6.1 or later
  • Borland Database Engine
    Important: Install this software after installing Enterprise Test Server.

HCO for DB2 LUW

Back to Top

Before deploying an HCO for DB2 LUW application, be sure to install and configure all applicable third-party software.

Note: HCO for DB2 LUW is supported for native COBOL only.
Availability
XA Switch Module
The DB2 XA switch module is provided and is available on the same platforms as are indicated in the Availability section above.
Host Compatibility Option (HCO)
Host Compatibility Option requires that you have one of the following software products installed and configured:
  • IBM DB2 Connect - Personal, Enterprise, Application Server or Unlimited Edition
  • IBM DB2 LUW - Workgroup or Enterprise Server Editions including Advanced versions
  • IBM DB2 LUW - Express or Express-C Edition
  • IBM Data Server Client (assumes installation of a remote DB2 LUW Server product)
Testing
For this version, HCO for DB2 LUW was tested with versions 10.5 and 11.1, and 11.5

HCO for SQL Server (HCOSS)

Back to Top

Before deploying an HCOSS application, be sure to install and configure all applicable third-party software.

Availability
Feature/Platform 32-bit 64-bit
x86-64 running Windows X X
Database Migration
HCOSS Client Host node
  • SQL Server 2014 or later [15]
  • Microsoft .NET Framework 4.7.2
  • Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)
    Note: Microsoft recommends MSOLEDBSQL only, as all other versions are deprecated or are no longer maintained. However, if MSOLEDBSQL is not installed, SQL Server Native Client (SNAC) is used if available.
  • Microsoft OLE DB Provider for DB2 version 5.0 or later
    Notes:
    • Be sure to configure the OLE DB Provider to connect to the mainframe. See your Microsoft documentation for details.
    • When using Microsoft OLE DB Provider for DB2 version 6.0, set the Extract Schema Cast STATEMENT column to VARCHAR during SysViews extract option.
SQL Server Target Host node
SQL Server 2014 or later [15]
Mainframe DB2
IBM-supported z/OS DB2 versions only
Note: If you intend to develop applications on your local machine, but deploy applications to a SQL Server database on a remote machine, configure the remote machine using the requirements listed in the Deploying Native Applications > Deployment Machine section later in this topic.
Application Migration
ADO.NET applications
ADO.NET applications require SQL Server 2014 or later and SqlClient Data Provider in .NET Framework 4.x
Note: Microsoft recommends .NET Framework 4.5.2

OpenESQL

Back to Top

Before deploying an OpenESQL application, be sure to install and configure all applicable third-party software.

Availability
XA Switch Module
The ODBC One-phase Commit, SQL Server, and PostgreSQL (early adopter program) switch modules are provided and available on the same platforms as are indicated in the Availability section above.
Native COBOL
  • OpenESQL supports access to relational databases using ODBC 3.0-compliant drivers
  • Refer to your driver vendor's documentation to determine whether your driver is suitable for use with OpenESQL
.NET COBOL
  • OpenESQL supports access to relational databases using compliant .NET framework drivers
  • OpenESQL has been tested against the following ADO.NET data providers:
    • Microsoft provider for SQL Server
    • Microsoft provider for Oracle
    • IBM DB2
    • Oracle Data Provider for .NET (ODP.NET) - fully managed and unmanaged providers
    • OleDb
    • Managed ODBC .NET providers
    • Npgsql 3.2.2 for EDB PostgreSQL
Testing
For this version, OpenESQL was tested with:
  • Oracle 18c and 19c
  • DB2 LUW 10.5, 11.1, and 11.5
  • SQL Server 2014, 2016, 2017, and 2019
  • PowerLinux LE on remote Linux server using DB2 LUW 10.5 only
  • EDB PostgreSQL 10.x (where x>=5), and 11.x
  • MySQL 5.7 (5.3 ODBC drivers only)
Note: Micro Focus provides compatibility for PostgreSQL and MySQL but does not directly contribute to or support either open source project. Any issues relating to the functionality of either DBMS should be addressed through an open source support vendor.
Planned
Support for the following is planned for future release:
  • Azure SQL Database (Managed Instance)
  • Azure SQL Database (Logical server)
  • Amazon Aurora PostgreSQL-Compatible Edition

SQL Option for DB2

Back to Top

Availability
Feature/Platform 32-bit
x86-64 running Windows X
XA Switch Module
XDB XA switch modules are provided and are available for the Windows x86-64 32-bit platform.
Parent topic: Additional Software Requirements
Related information
JCL