Username Password
Search

DataFlex ("DF") is a suite of software design  tools, a development methodology, application deployment components, a transaction processing DBMS and scaleable client server options built around a mature object-oriented 4GL. 

Professional developers worldwide use DataFlex to develop high-performance, database independent applications for manufacturing, financial services, accounting, distribution, health care, insurance, agriculture, food service, transportation, hospitality and government industry sectors.

With DataFlex, you can: 

  • Produce database applications faster with DataFlex Studio - an IDE and other tools specifically tuned for developing database applications.
  • Extend application functionality through a mature and proven object-oriented 4GL.
  • Deploy Windows applications using the DataFlex Client Engine
  • Deploy web applications using the scalable, secure DataFlex WebApp Server 
  • Connect applications to industry leading database servers - including Pervasive.SQL, MS-SQL, IBM DB2, Oracle, or any ODBC compliant database.
  • Report on application data using DataFlex Reports or DataFlex’s built-in report writer, WinPrint

Applications built with DataFlex Studio are database independent.  They can be easily deployed on the DBMS of your choice without needing code-changes using "Connectivity Kits".  These kits provide application transparent database connections and they also will convert your data from one DBMS to another.  Connectivity Kits are available for Microsoft SQL-Server, IBM DB2 Universal Database, Pervasive.SQL (Btrieve), Oracle and MySQL. An ODBC Connectivity Kit provides access to any ODBC-compliant connection...

DataFlex Client Engines include an embedded DBMS, providing developers with a powerful, high performance workgroup database solution "in the box".

Supported Operating System and Browser Enviroments

DataFlex 2019 Studio, Windows Client and WebApp Server are supported on:

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

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.

Web Browsers supported in the DataFlex Framework

  • Microsoft Interner Explorer 11 and Edge
  • Chrome, Firefox, Safari and other modern browers

Database & Connectivity

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

  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014
  • IBM DB2 10.5 (and higher)

ODBC Connectivity Kit

 

A variety of data sources can be accessed through ODBC. These include enterprise database servers such as Microsoft SQL Server, MySQL, Oracle and PostgreSQL, flat file databases like dBase and even non-database data like Excel and ASCII files. Use of the DataFlex ODBC Connectivity Kit also requires the installation of a specific ODBC Driver for the target data source.

You can find ODBC configuration information specific to 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.

Connectivity Entitlements

While the connectivity components are installed with DataFlex, their use is based on the particular DataFlex license purchased. SQL database connectivity is ON or OFF for installed DataFlex software as follows:

  • DataFlex Studio – always ON
  • DataFlex WebApp Server
    • ON if purchased with the WebApp Server. If connectivity entitlements are not purchased with the server, the default is OFF. Connectivity entitlements can be bought later for a fee and activated with the installation of a different registration code (reinstallation is not required).
  • DataFlex Windows Client
    • ON if purchased with the Windows Client. If connectivity entitlements are not purchased with the client, the default is OFF. Connectivity entitlements can be bought later for a fee and activated with the installation of a different registration code (reinstallation is not required).

DataFlex Studio, WebApp Server and Windows Client also include the free DataFlex embedded flat file database. Special configuration of local area networks is required for the reliable use of the embedded database in production application environments. For details, see: http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html

 Use of an SQL server is highly recommended for production DataFlex applications.

 

Home