A simple yet powerful tool to import, export and/or dynamically convert data
The FlowHeater functionality closely resembles the concept of a continuous-flow water heater. A wide variety of data sources can be interconnected with FlowHeater and by making use of exchangeable adapters, there is no restriction to the data flow.
For example, the data in an Oracle database tables can be copied directly and without manual intervention into an MS SQL Server database. Furthermore, while the copy proceeds the data can be "heated", i.e. converted, amended, transformed, manipulated and additional dynamic or static data injected, as predetermined by a definition set.
Think of all those time-consuming and error-prone manual imports and exports of CSV text files and databases you have done over the years. FlowHeater makes your life really simple and each conversion can be reused over and over.
Adapters available include
The Adapter supports Excel/Office versions 97, 2000, 2002 (XP), 2003, 2007 and 2011.
flowheaterMS Access
Specially designed for import/export of data to or from Microsoft Access MDB, MDE, ACCDB, ACCDE databases. The Adapter supports Access/Office versions 97, 2000, 2002 (XP), 2003, 2007 and 2011.
Any desired OleDB data source can be integrated into FlowHeater with this adapter. The only prerequisite is the installation of an OleDB driver for your data source.
Supports dBASE (dbf) data files!
This adapter generates test data. Any desired number of test data records comprising any chosen static or dynamic content can be created.
This Adapter is intended especially for the .NET developers among us. With this you can integrate your own Adapter into FlowHeater or make use of the FlowHeater engine in your own programs.
flowheater.
Possible extensions to functionality
* Print function for the Definition set
* Synchronization of data source/target
* More than two Adapters in one Definition, in this way several tables can be imported or exported simultaneously and/or combined with one another using relations
* Read/write unstructured text data e.g. headers and footers, one record split across several lines, etc.
* Possibly a wizard feature, in order to make it even simpler (can it be any simpler?)
* Further Adapters, such as PostgreSQL, Informix, DB2, Sharepoint, dBase, XML, Email, Datanorm, ...
* Further functions (Heater) such as subroutines, loop controls (for, foreach, while), ...
* Audit function for validation of the import/export data prior to actual processing
* Passing parameters for Heaters over Pipes: This will achieve a level of flexibility that practically reaches that of individual programming, without having to actually resort to programming
* Starting of external programs before, during and after execution of the Definition
* Visual Studio add-in for the integration of the DataTable Adapter
* Debugging to simplify tracing of errors
* Workflows
* and so on :-)
FlowHeater 100% CLEAN Certification
FlowHeater has been tested by Soft82.com team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. Our editors will recheck this software periodically to assure that it remains clean.