Visual Data Pump is a tool from Data Access Worldwide that simplifies the process of running, regular data exports from the DataFlex embedded database to a Microsoft SQL Server database (including the Express Edition).
With Visual 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.
Why use Visual Data Pump?
Despite the many benefits of the DataFlex embedded database, it doesn’t have the standard access methods like ODBC that many tools require. Therefore, Visual DataFlex developers have to write special applications or workarounds for common tasks such as connecting to Microsoft Office products, Business Intelligence & reporting tools, etc.
By exporting DataFlex data to Microsoft SQL Server, Visual Data Pump makes the DataFlex data more accessible for other tools to use. In addition, 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.
Used in combination with Dynamic AI for Business Intelligence, Visual Data Pump can opens up new opportunities for BI reporting, query and analysis quickly giving your applications exciting new capabilities without introducing system changes. Visual 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.
Try Visual Data Pump Today
You can try out Visual Data Pump using an Evaluation Licence. The limitations are it will run for 60 days only and it will only “pump” data from the first 10 tables in your file list. Note, that Visual Data Pump is a “one-way” data pump; the result is non-real-time data in the SQL database.
Learn more and download Visual Data Pump at www.VisualDataPump.com.