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.  more »

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

Each Adapter can be connected to any other, in any combination you want.

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 OLEDB, 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
• Internal data type RAW – in this way it will be possible to work with binary data such as images, graphics and completely unknown database data types
• 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 :-)

_{Microsoft®, Windows®, SQL Server®, Access®, Excel® are registered trademarks of Microsoft Corporation
Oracle® is a registered trademark of Oracle Corporation
MySQL®, MySQL Enterprise are registered trademakrs of MySQL AB}