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).
The primary benefit of using Data Pump is to make your DataFlex data more freely available for other tools to use. But why do you need it?
Exports DataFlex Data for Easy Access by other Tools
Despite the many benefits of the DataFlex embedded database, it doesn’t 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 data is automatically converted to a SQL Server database, i.e., hourly, nightly, weekly, or whenever you need it.