Current Products List

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

DataFlex 2017/19.0 Supported Environments as of the latest build:

• Windows 10
• Windows 8.x (32 & 64 bit but not RT)
• Windows 7 (Home premium or higher, 32 & 64 bit)
• Windows Server 2016 & 2012 (32 & 64 bit)
• When using DataFlex Connectivity Kit v6.2.0.42 or higher
  • Microsoft SQL Server 2017, 2016, 2014 & 2012 (including LocalDB) using ODBC Driver 13.1 for SQL Server
  • Microsoft SQL Server 2016 (including LocalDB) using ODBC Driver 13 for SQL Server
  • Microsoft SQL Server 2014 (including LocalDB) using ODBC Driver 11 for SQL Server
  • Microsoft SQL Server 2012 (SP2 including LocalDB) using SQL Native Client 11.0
    • See notes below regarding Microsoft SQL Server Express LocalDB
  • IBM DB2 v10.1 and higher
  • ODBC Data Sources
• When using Pervasive PSQL Connectivity Kit v5.0.0.53
  • Pervasive PSQL v11, Vx11
  • Pervasive PSQL v12, Vx12
• Windows Terminal Services (on Windows Server 2016 and 2012)
• Citrix XenApp when used in conjunction with other supported Windows operating systems
• Web Browsers supported in the DataFlex 2016/18.2 Framework:
  • Microsoft Internet Explorer 11 and Edge
  • Chrome, Firefox, Safari, and other modern browsers

 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 all DataFlex Studio, Windows Client and WebApp Server releases. Recent DataFlex versions include the following SQL database drivers:

• DataFlex 2021 - 20.0 June: SQL Drivers 20.0.10.93
• DataFlex 2021 - 20.0 April: SQL Drivers 20.0.10.91
• DataFlex 2021 - 20.0 March: 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 2017 - 19.0 December Build: SQL Drivers 6.2.0.42
• DataFlex 2017 - 19.0 August Build: SQL Drivers 6.2.0.40
• DataFlex 2016 - 18.2: SQL Drivers 6.1.0.27
• DataFlex 2015 - 18.1: SQL Drivers 6.1.0.18

DataFlex SQL Drivers 20.0 are Unicode and can only be used with DataFlex 2021 - 20.0. No standalone installation is available since the drivers are delivered with DataFlex. Those drivers support the same databases as the DataFlex SQL Drivers 6.3.

The newest standalone installation of DataFlex SQL Drivers (6.3.0.22) for DataFlex 19.1 (and lower) support the following databases:

• Native database drivers
  
  • Microsoft SQL Server 2019 (including LocalDB) using ODBC Driver 17 for SQL Server or higher
  • Microsoft SQL Server 2017 (including LocalDB) using ODBC Driver 17 for SQL Server or higher
  • 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
  • IBM DB2 v11.5 and higher
• Enhanced ODBC
  • The DataFlex ODBC driver has been specially tuned to optimize performance with various databases using their corresponding ODBC connectors and drivers.Those databases 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
• 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.

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.

How to get the latest DataFlex SQL Drivers

We publish DataFlex SQL Driver updates that contain the latest drivers packaged in a ZIP file designed to apply these drivers to properly licensed deployment environments that already have prior DataFlex SQL drivers installed.

Download the DataFlex SQL Driver Update 6.3.0.22 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 lower) 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 driver will be installed. 

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

Released: August 15, 2018

DataFlex Reports v6.2.0 Supported Environments

• Microsoft Windows 10 (32/64 bit)
• Microsoft Windows 8 excluding RT (32/64 bit)
• Microsoft Windows 7 Home Premium or higher (32/64 bit)
• Microsoft Windows Server 2012 including R2 (32/64 bit)
• Microsoft Windows Server 2008 including R2 (32/64 bit)
• Windows Terminal Services when using Windows Server 2012 or Windows Server 2008
• Citrix 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