Current Products List

DataFlex 2022/20.1 Supported Operating System and Browser Environments:

• Windows 11
• Windows 10
• Windows Server 2022
• Windows Server 2019
• Windows Server 2016

Web Browsers supported in the DataFlex Framework:

• Microsoft Chromium-based Edge and Internet Explorer 11
• Chrome, Firefox, Safari and other modern browsers

Database & Connectivity

Application connectivity to leading SQL databases is essential for creating reliable, high-performance business applications. Each DataFlex 2022/20.1 installation file includes Connectivity Kits for the SQL databases listed below.

• Native database drivers
  • Microsoft SQL Server 2017 and higher
  • IBM DB2 11.5 (and higher)
• Enhanced ODBC - especially tuned to work effectively with the following:
  • MySQL 8.0.19 and higher
  • MariaDB 10.5.4 and higher using the MySQL Connector/ODBC 8.0.17 (or later)
  • Amazon Web Services’ Aurora 2.07.2 (based on MySQL 5.7)
  • PostgreSQL 12.3
  • Oracle 18c and higher

ODBC Connectivity

A variety of additional data sources can be accessed through ODBC including SQLite, SQLBase, Microsoft Access, flat file databases and even non-database data like Excel and ASCII files. Use of the DataFlex ODBC Connectivity Kit requires the installation of a specific ODBC Driver for the target data source.

Note that to work with Unicode data in SQL databases, the character set and collating settings of the database can be an important part of the environment set up. See the Help for more information.

Full details of database and driver support are below in the Current Products List. See: DataFlex SQL Driver Support & Updates

Notes on Installation Environments
When used in conjunction with Windows Server 2019 and Windows Server 2016, DataFlex Studio and Windows Client are supported on Windows Terminal Services and Citrix Virtual Apps and Desktops (formerly XenApp and XenDesktop).

Microsoft Internet Information Services (IIS) must be installed and operational to run DataFlex WebApp Server.

Documentation

• DataFlex 2022 Online Help
• Installation & Environment Guide
• Quick Introduction to DataFlex for:
  • Windows
  • Web
  • Mobile Web

DataFlex 2021/20.0 Supported Operating System and Browser Environments:

• Windows 10
• Windows Server 2019
• Windows Server 2016

Web Browsers supported in the DataFlex Framework:

• Microsoft Chromium-based Edge and Internet Explorer 11
• Chrome, Firefox, Safari and other modern browsers

Database & Connectivity

Application connectivity to leading SQL databases is essential for creating reliable, high-performance business applications. Each DataFlex 2021/20.0 installation file includes Connectivity Kits for the SQL databases listed below.

• Native database drivers
  • Microsoft SQL Server 2017 and higher
  • IBM DB2 11.5 (and higher)
• Enhanced ODBC - especially tuned to work effectively with the following:
  • MySQL 8.0.19 and higher
  • MariaDB 10.5.4 and higher using the MySQL Connector/ODBC 8.0.17 (or later)
  • Amazon Web Services’ Aurora 2.07.2 (based on MySQL 5.7)
  • PostgreSQL 12.3
  • Oracle 18c and higher

ODBC Connectivity

A variety of additional data sources can be accessed through ODBC including SQLite, SQLBase, Microsoft Access, flat file databases and even non-database data like Excel and ASCII files. Use of the DataFlex ODBC Connectivity Kit requires the installation of a specific ODBC Driver for the target data source.

Note that to work with Unicode data in SQL databases, the character set and collating settings of the database can be an important part of the environment set up. See the Help for more information.

Full details of database and driver support are below in the Current Products List. See: DataFlex SQL Driver Support & Updates

Notes on Installation Environments
When used in conjunction with Windows Server 2019 and Windows Server 2016, DataFlex Studio and Windows Client are supported on Windows Terminal Services and Citrix Virtual Apps and Desktops (formerly XenApp and XenDesktop).

Microsoft Internet Information Services (IIS) must be installed and operational to run DataFlex WebApp Server.

Documentation

• DataFlex 2021 Online Help
• Installation & Environment Guide
• Quick Introduction to DataFlex for:
  • Windows
  • Web
  • Mobile Web

DataFlex 2019/19.1 Supported Operating System and Browser Environments:

• Windows 10
• Windows Server 2019 (including x64)
• Windows Server 2016 (including x64)

Web Browsers supported in the DataFlex Framework:

• Microsoft Internet Explorer 11 and Edge
• Chrome, Firefox, Safari and other modern browsers

Database & Connectivity

Application connectivity to leading SQL databases is essential for creating reliable, high-performance business applications. Each DataFlex 2019/19.1 installation file includes the connectivity components for the SQL databases listed below.

• Native database drivers
  • Microsoft SQL Server 2019
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014
  • IBM DB2 10.5 (and higher)
• Enhanced ODBC
  • MySQL 8.0.17 and compatibles - The DataFlex ODBC driver has been specially tuned to optimize performance with MySQL 8.0.17 and compatible databases (Amazon Web Services Aurora and MariaDB) using the MySQL Connector/ODBC 8.0.17 (or later).
• ODBC Connectivity

A variety of additional data sources can be accessed through ODBC including Oracle, PostgreSQL, SQLite, SQLBase, Microsoft Access, flat file databases like dBase and even non-database data like Excel and ASCII files. Use of the DataFlex ODBC Connectivity Kit  requires the installation of a specific ODBC Driver for the target data source.

Full details of database and driver support are below in the Current Products List. See: DataFlex SQL Driver Support & Updates

Notes on Installation Environments
When used in conjunction with Windows Server 2019 and Windows Server 2016, DataFlex Studio and Windows Client are supported on Windows Terminal Services.

When used in conjunction with other supported Windows operating systems, DataFlex Studio and Windows Client are supported on Citrix Virtual Apps and Desktops (formerly XenApp and XenDesktop).

Microsoft Internet Information Services (IIS) must be installed and operational to run DataFlex WebApp Server.

Documentation

• Installation & Environment Guide 
• Quick Introduction to DataFlex for:
  • Windows
  • Web
  • Mobile Web

SQL database drivers are an integral part of the DataFlex environment. The drivers are included in the installation of current DataFlex Studio, Windows Client and WebApp Server products. DataFlex includes:

Native database drivers that support

• IBM DB2 v11.5 and higher
• Microsoft SQL Server 2019 (including LocalDB) using ODBC Driver 17 for SQL Server 
• Microsoft SQL Server 2017 (including LocalDB) using ODBC Driver 17 for SQL Server 
• Microsoft SQL Server 2016 (including LocalDB) using ODBC Driver 13.1 for SQL Server or higher
• Microsoft SQL Server 2014 (including LocalDB) using ODBC Driver 11 or 13 for SQL Server or higher
• Microsoft SQL Server 2012 (SP4 including LocalDB) using SQL Server Native Client 11.0 or higher

Enhanced ODBC driver

The DataFlex ODBC driver has been specially tuned to optimize performance with specific databases using their corresponding ODBC connectors and drivers. Databases supported via ODBC are:

• MySQL 8.0.19 and higher
• MariaDB 10.5.4 and higher
• Amazon Aurora 2.07.2 (based on MySQL 5.7)
• PostgreSQL 12.3
• Oracle 18c and higher

You can find ODBC configuration information specific to certain database backends, like MySQL (MySQL.int) and Oracle (Oracle.int), in the \Bin directory. These files should be modified according to your specific installed version of the target database.

To better understand the various ODBC pieces that work together to make access to your data possible, read our blog, A Closer Look Into the ODBC World.

Other ODBC Data Sources

A variety of additional data sources can be accessed through ODBC including SQLite, SQLBase, Microsoft Access, flat file databases like dBase and even non-database data like Excel and ASCII files. The use of the DataFlex ODBC driver requires the installation of a specific ODBC driver for the target data source.

Recent DataFlex releases include the following SQL database driver revisions:

• DataFlex 2022 - 20.1 April Build: SQL Drivers 20.1.31.10
• DataFlex 2021 - 20.0 April 2022 Build:  SQL Drivers 20.0.10.103
• DataFlex 2021 - 20.0 September Build: SQL Drivers 20.0.10.99
• DataFlex 2021 - 20.0 June Build: SQL Drivers 20.0.10.93
• DataFlex 2021 - 20.0 April Build: SQL Drivers 20.0.10.91
• DataFlex 2021 - 20.0 March Build: SQL Drivers 20.0.10.84
• DataFlex 2019 - 19.1 October Build: SQL Drivers 6.3.0.15
• DataFlex 2019 - 19.1 April Build: SQL Drivers 6.3.0.13

DataFlex SQL Drivers 20.0 and later are Unicode drivers and cannot be used with non-Unicode DataFlex 2019 - 19.1 and older. To acquire the most current SQL Drivers for Unicode environment (DataFlex 2021 - 20.0 and newer), simply install the latest DataFlex build, which also includes the newest drivers.

How to get the latest DataFlex SQL Drivers for DataFlex 2019 - 19.1 (and older)

For older DataFlex releases, we publish a DataFlex SQL Driver update ZIP file that contains the latest drivers ready to install in properly licensed deployment environments that already have prior DataFlex SQL drivers.

Download the DataFlex SQL Driver Update 6.3.0.25 ZIP. See the ReadMe.

You can determine the driver version installed in your DataFlex environments by clicking Help | About | System Information in the DataFlex Studio. Unless you have specific reason not to, we recommend that you update your installation to the latest DataFlex SQL Drivers available along with the corresponding ODBC driver (e.g. ODBC Driver 17 or MySQL Connector/ODBC 8) available for the target database or data source.

By installing the above update, DataFlex 2019 - 19.1 (and older) will be considered supported for the databases listed above when used with the newest DataFlex SQL Drivers and corresponding ODBC drivers.

For supported OS versions, please refer to the DataFlex environment where the database drivers will be installed. 

DataFlex Reports v8.1 Supported Environments

• Microsoft Windows 10
• Microsoft Windows Server 2019
• Microsoft Windows Server 2016
• All of the above are supported in 32 and 64 bit editions
• Windows Terminal Services when using Windows Server 2016 or Windows Server 2019

DataFlex Reports v8.0 Supported Environments

• Microsoft Windows 10
• Microsoft Windows Server 2019
• Microsoft Windows Server 2016
• All of the above are supported in 32 and 64 bit editions
• Windows Terminal Services when using Windows Server 2016 or Windows Server 2019

Released: March 13, 2019

DataFlex Reports v7.0 Supported Environments

• Microsoft Windows 10
• Microsoft Windows Server 2019 (including x64)
• Microsoft Windows Server 2016 (including x64)
• Windows Terminal Services when using Windows Server 2019 or Windows Server 2016
• Citrix Virtual Apps and Desktops (formerly XenApp) when used in conjunction with other supported Windows operating systems

Operating Systems / Web Servers

• Microsoft Internet Information Server 7 through 10 (with 32 bit support enabled)
• Microsoft Windows 7 / Server 2008 through Windows 10 / Server 2016 (32/64 bit)

DBMS Servers / Drivers

• All DBMS servers (32/64 bit) with 32 bit OLE-DB or ODBC drivers available for Windows OS versions listed above
• Other data sources such as Microsoft Access, Excel, or delimited text (CSV, TSV, Fixed, etc.) for which ODBC drivers are available for Windows versions listed above

Web Browsers

• All popular desktop browsers including:
  • Microsoft Internet Explorer versions 7 through 11
  • FireFox, Chrome, Safari, Silk
  • Safari on iPad, iPhone