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!
v4.0 [Nov 3, 2015]
New System Heater/Function
The System Heater makes it possible to select from the system information available and returns a string you can use dynamically in an import/export Definition. At present the Heater can deliver the following information.
The FlowHeater version number currently in use
Whether it is a 32-bit or 64-bit FlowHeater variant (x86 | x64)
Environment variables: you select one of the variables available
The filenames presently in use on one of the Adapters. Not only does it return the filename for CSV, Excel or XML files, but also, for example, the Access database file or the effectively used SQLite database file. Naturally, this does not extend to server-based databases!
The currently used FlowHeater Definition filename (.fhd | .fhrt)
New Path Heater/Function
With the Path Heater you can be used to concatenate several incoming elements into a complete path and filename string as well as making it possible to extract particular components of a path and filename string. The following components can be extracted:
Complete (absolute) path
Filename (with extension)
Filename (without extension)
Extension (such as .csv)
Folder (directory) name
Further enhancements
The Batch Module (FHBatch.exe) now issues a warning when a parameter name is defined using the option “/SetParameter name=value” that has not previously been defined for the FlowHeater Definition using the Designer “Menu -> Edit -> Parameter ” option. Of course, the batch run will continue with the Parameter added automatically to the list of Parameters.
In the String Split Heater you can now decide whether or not the string search is applied case sensitive. In addition, the String Split Heater settings have been extended to support embedded FlowHeater Parameters and environment variables. Moreover, you are now able to select whether a warning is given when the returned column size exceeds the column width defined.
Feature-rich relational database known for its high performance and excellent concurrency
