DataFlex Data Pump is a tool produced by Data Access Worldwide to simplify the process of running, regular data exports from the DataFlex embedded database to a Microsoft SQL Server database (including the Express Edition).
Note: DataFlex Data Pump was formerly known as Visual Data Pump.
The primary benefit of using DataFlex Data Pump is to make your DataFlex data more freely available for other tools to use. But why do you need it?
Despite the many benefits of the DataFlex embedded database, it doesnt have the standard access methods like ODBC that many tools require. Therefore, DataFlex developers have to write special applications or workarounds for common tasks such as connecting to Microsoft Office products, Business Intelligence & reporting tools, etc.
Used in combination with Dynamic AI for Business Intelligence, DataFlex Data Pump opens up new opportunities for BI reporting, query and analysis quickly giving your applications exciting new capabilities without introducing system changes. DataFlex Data Pump also makes it easy for developers to begin exploring their DataFlex data in a live SQL Server environment, and to help prepare their applications for migration from the DataFlex embedded database to a SQL database.
In addition, to being more accessible, your converted data can benefit from the improved performance that SQL Server provides for large data sets and more complex reporting requirements. Microsoft SQL Server Express can be downloaded for free and offers enough capabilities to handle most situations that developers face. Full commercial versions of Microsoft SQL Server are fully supported as well.
With DataFlex Data Pump installed in the same environment as your Microsoft SQL Server database, you can schedule when your DataFlex data is automatically converted to a SQL Server database, i.e., hourly, nightly, weekly, or whenever you need it.