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.3FlowHeater 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.
Operating System: Windows
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
- any ODBC Datasources
- any OleDB Datasources, Supports dBASE (dbf) databases .
- NET DataTable, for your own Adapter
- generate test data
- 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!
Version 4.1.3: Support for several processing steps in a Definition
Version 188.8.131.52: AutoID Heater with new option - count just on every X records
Version 4.1.0: New CMD Heater - Running external programs or scripts
Version 184.108.40.206: Database adapter - tables schema readout optimized
Version 220.127.116.11: - Excel Adapter with update and lookup functions - Updated third party database drive - Bug Fix: Access Database Adapter
Version 4.0.9: Excel Adapter with update and lookup functions
Version 18.104.22.168: XML Export with grouping data, X-Value Heater with multi-line Support, Adapter with extended logging
Version 22.214.171.124: XML Export with grouping data, X-Value Heater with multi-line support
Version 4.0.8: XML Export with grouping data