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

 

Why Mertech?

Open Tables Directly

Open Tables Directly

You can open an SQL table without having an INT file by using the Open method. Although you don’t need the INT file, an FD file is still required to compile your DF/VDF application.


Open Method Syntax

Open "<DriverName>:\<ServerName><DataBaseName>*<Owner>*<TableName>" as <TableName>


Examples 
MySQLopen "MDSMYSQL:\localhostmertech*customer" as customer

 

MS SQLServerOpen "SQL_DRV:\MertechServerSQLServer2012MertechDB*dbo*customer"   as customer


PostGreSQL
open "MDSPGSQL:\localhostframework*customer" as customer


Oracle
open "ORA_DRV:\ora11gmertech*customer"     as customer



Open As Option in VDF

You can also open an SQL table directly using the "Open As" option in VDF dbExplorer by typing the complete SQL table path.

OpenAs

 

 

Hybrid Cloud Migration: Plan, Process and Advantages

Hybrid Cloud Migration: Plan, Process and Advantages

This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.

Read More
Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...

Read More

AWS Application Modernization: Best Practices & Tools

In the age of digital transformation, businesses are increasingly moving away from traditional on-premises systems, steering towards more dynamic,...

Read More