Switch effortlessly from DataFlex to industry standard databases with Mertech’s FLEX2SQL database driver.

Mertech’s Flex2SQL is a database connectivity solution that allows an existing application currently working exclusively with DataFlex transactional engines to function with more scalable and secure relational database engines such as PostgreSQL, Oracle, MS SQL, and MySQL. Flex2SQL’s plug-in architecture enables companies to quickly switch over without altering the application or incurring high re-engineering costs. Flex2SQL includes a migration tool that creates tables and copies data with all of the needed indexes and a database driver which allows applications to execute database processes with a new SQL backend.

Flex2SQL seamlessly operates with the latest versions of industry standard databases. Not only are these databases interoperable with third-party tools and operating systems, they can also easily scale to thousands of users to support a business’ ongoing growth.

For those seeking support for stored procedure and functions, PostgreSQL provides an enterprise level database with absolutely no licensing fee. Mertech’s driver provide access to stored procedures and functions from within a DataFlex program by using embedded SQL calls. For developers looking to adopt an enterprise level database with absolutely no license fee or royalty, PostgreSQL is the solution.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views and synonyms as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any Windows version of DataFlex, the user needs to install or have access to PostgreSQL client libraries and client networking utility, properly configured to access the PostgreSQL server. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported PostgreSQL Versions

Version 8.4 and above

Supported DataFlex Versions

DataFlex® 5.x and above for Windows 2000 and above

DataFlex® 3.1c and above Console Mode for Windows 2000 and above

DataFlex® 3.1d for Linux and above

Please Contact Us for additional Unix platforms

Flex2SQL for Oracle allows existing DataFlex® applications to connect to an Oracle® database server without requiring application level changes. The product uses Oracle’s Oracle Call Interface (OCI) for communicating and accessing the Oracle database, which is much faster than using an ODBC-based product.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views and synonyms as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any platform and connect to an Oracle database server, the user needs to install or have access to the Oracle SQL*Net client, properly configured to access the Oracle server. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported Oracle Versions

Oracle® 9i and above, Oracle Express Edition

Supported Platform & DataFlex Versions

DataFlex® 5 and above, DataFlex® 3.1c and above

Windows, Linux, HP and AIX

Please Contact Us for additional Unix platforms

Flex2SQL® is a high-performance ISDBC driver for connecting to Microsofts MS SQL Server® database from DataFlex programs. The driver uses Microsoft’s SQL Server Native Client for communicating with and accessing the MS SQL Server database. We ship the SQL Server Native client and it is also available as a free small download from Microsoft. There is no need to buy additional drivers from other vendors, like in the case of ODBC.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views and synonyms as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any Windows version of DataFlex the user needs to have the SQL Server Native client installed. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Supported MS SQL Versions

MS SQL Server 2005 and above (including LocalDB)

Supported DataFlex Versions

DataFlex® 5.x and above, DataFlex® 3.1c and above

Windows 2000 and above

Developed using MySQL’s C API, Mertech’s ISDBC driver for MySQL provides complete support for various table handlers, file creation parameters, support for uppercase or lowercase object names and fast loading of data into tables using text files. DataFlex programs can take advantage of MyISAM tables which offer low-level ISAM access.

Product Highlights

  • Support for overlap/partial overlap fields
  • Complete support for case sensitive indexes
  • Complete support for mixed ascending and descending index segments
  • Preservation of RECNUM values during data migration
  • High-speed data migration
  • Record Locking instead of file locking
  • Complete Support for Transaction
  • Access views and synonyms as DataFlex files
  • Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views
  • NO CODE RECOMPILATION! The table structure is exactly like DataFlex!
  • Support for DataFlex restructure commands
  • Detailed migration report
  • Generate SQL Script for creating tables and indexes

Required Components

To be able to run a DataFlex program from any version of DataFlex, the MySQL client library, libmysql.dll in Windows or libmysql.so in Linux should be placed in the same directory as Mertech’s driver and license file.

Furthermore, since Mertech’s product is not open source and does not follow the GPL licensing, users of MySQL with Mertech’s driver will have to purchase a commercial version of MySQL. Users are advised to check MySQL’s web site for more information on purchasing commercial licenses. Please see Mertech’s software license agreement for using MySQL commercial licenses.

Supported MySQL Versions

MySQL 5.0 and above.

Supported DataFlex Versions

DataFlex® 5.x and above for Windows 2000 and above

DataFlex® 3.1c and above Console Mode for Windows 2000 and above

DataFlex® 3.1d for Linux and above

Please Contact Us for additional Unix platforms