Skip to the main content.
Downloads Try Thriftly
Downloads Try Thriftly
Group 762

Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL &  MariaDB.

flex2Crystal

Stuck in Crystal XI?  Upgrade and use the latest versions of Crystal Reports with DataFlex applications. 

BTR2SQL

Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL

thriftly-1

Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP,  Thrift, and gRPC.

 Group 671-1

 

  Education
Why Mertech?
FASTEST CONNECTIVITY SOLUTIONS FOR DATAFLEX DEVELOPERS

Give new life to your DataFlex applications!

Migrate your DataFlex database to  Oracle, MS SQL Server,  MySQL ,  Maria DB and PostgreSQL. Run your application with zero  changes to your code base.

Read Whitepaper 

flex2sql

Easy conversion from DataFlex

Flex2SQL’s plug-in architecture ensures your application effortlessly works with a SQL backend. Migrate your DataFlex database to SQL (creating tables, indexes, relationships, and other components) using Flex2SQL’s GUI migration tool. Post-migration, Flex2SQL’s database driver works alongside your application, connecting your app to your new backend and translating DataFlex API calls into optimized SQL queries.

Group 664-1

Lower your database costs

Connect to open-source MySQL and PostgreSQL databases without using slow Open Database Connectivity (ODBC) drivers. Flex2SQL’s native MySQL and PostgreSQL support provides your DataFlex application with a fast, reliable connection to the leading no-license databases.

Group 643-1

Fastest connectivity drivers  for DataFlex!

Flex2SQL outperforms competing products in every aspect of database management and operations, including finding, inserting, deleting, and replacing records. That’s why most major DataFlex-using independent software vendors (ISVs) and enterprises have already chosen Flex2SQL to connect their applications with SQL databases.

Group 650-1

Quick and easy migration

Flex2SQL’s database migration toolset includes a GUI that helps you migrate your data and a verifier that ensures the migrated data matches what came from your DataFlex database. Flex2SQL takes maximum advantage of SQL’s database structure, creating tables and indexes during migration, as well as supporting failover and mirroring.

Group 765-3

Key features

check-1 Native, optimized connections with both your existing Btrieve database and SQL.

check-1 Quick and easy migration, utilizing a GUI migration tool, DDFs, and database validation.

check-1 Full support for Btrieve-style locking (outside of transactions).

check-1 Advanced tracing support for easy troubleshooting using startup trace or trace API.

check-1 Support for Data Table Index (DTI) functions.

Group 766-3
Group 604-1

Supported Oracle Versions

Oracle 11g and later


Supported DataFlex Versions

DataFlex 6.x and later ( Windows GUI )
DataFlex 3.1c and later ( Windows Console Mode )
DataFlex 3.1d and later for Linux

About

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.

 

Requirements

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.

Group 604-1

Supported MS SQL Server Versions

MS SQL Server 2012 and later versions for LocalDB, SQL Express, SQL Standard, SQL Azure, and SQL Enterprise.


Supported DataFlex Versions

DataFlex 6.x and later ( Windows GUI )
DataFlex 3.1c and later ( Windows Console Mode )
DataFlex 3.1d and later for Linux

About

Flex2SQL is a high-performance ISDBC driver for connecting to Microsoft’s 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.

 

Requirements

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.

Group 604-1

Supported PostgreSQL Versions

Version 9.1 and above


Supported DataFlex Versions

DataFlex 6.x and later ( Windows GUI )
DataFlex 3.1c and later ( Windows Console Mode )
DataFlex 3.1d and later for Linux

About

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.

 

Requirements

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.

Group 604-1

Supported MySQL Versions

MySQL 5.7 and above
Maria DB v10 and above


Supported DataFlex Versions

DataFlex 6.x and later ( Windows GUI )
DataFlex 3.1c and later ( Windows Console Mode )
DataFlex 3.1d and later for Linux

About

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.

 

Requirements

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 website for more information on purchasing commercial licenses. Please see Mertech’s software license agreement for using MySQL commercial licenses.

 

Learn more about the product or download your free trial today.  

Read Documentation    Download your free trial