This software allows for easy import and export of text files (CSV, XLS, XML, DBF, ASCII, SQL) between various databases (MS Access, MS Excel, MS SQL Server, MySQL, SQLite, PostgreSQL, Oracle, OleDB, ODBC), with a user-friendly graphical interface for defining the process.

The available adapters are Text file (CSV, TXT, ASC, Flat File, ...), MS Excel, XML Files, MS Access, MS Sql Server, MySQL, SQLite, PostgreSQL, Oracle, any ODBC Datasources, any OleDB Datasources, supports dBASE (dbf) databases, .NET DataTable, for your Adapter, and generate test data.
The software has several main features that include intuitive graphical model controls for the transformation process, SQL insert/update script generation, If/then/else conditional branching (*), Comprehensive filtering and consolidation functions (*), Incorporation of .NET scripts code (*), Supports binary data, BLOB's, ... (*), Support for diverse locale combinations (de-DE, en-GB, etc.), Support for different encoding schemes (codepages ASCII, ANSI , Unicode, EBCDIC , etc.), and Batch module for scheduled and background automated execution (*).
However, some functions are not available in the freeware version, which is limited to 100,000 records. In conclusion, FlowHeater is an efficient and effective software solution ideal for data management and conversion tasks.
Version 4.1.3: Support for several processing steps in a Definition