FlowHeater

Import / export of text files (CSV, XLS, XML, DBF, ASCII, SQL) from / to MS Access, MS Excel, MS SQL Server, MySQL, SQLite, PostgreSQL, Oracle, OleDB and ODBC data streams. A graphical interface to define the import / export process makes it very simple.

Version: 4.1.3
License: Free
Operating System: Windows
Homepage: flowheater.net
Developed by: FlowHeater GmbH

FlowHeater is a powerful tool for connecting widely differing data sources and targets using a flexible graphically defined conversion. CSV (text) import / export becomes childs play.

Adapters are available for import / export / update of MS Access, MS Excel, MS SQL Server, MySQL, SQLite, PostgreSQL, Oracle, OleDB and ODBC data sources as well as text formats (CSV, TXT, ASC, ASCII, Flat File...). The individual adapters can be used in any combination with one another.

Adapters available include:

• 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 own Adapter
• generate test data

Main features

• Intuitive graphical model controls the transformation
• 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 the most diverse locale combinations (de-DE, en-GB, etc.)
• Support for different encoding schemes (codepages ASCII, ANSI , Unicode, EBCDIC , etc.)
• Batch module for scheduled and background automated execution

Function not available in freeware version, the freeware version is limited to 100, 000 records!