News
IF-THEN-ELSE Heater additional checks
Release notes for version 2.2.2 on November 28, 2011
IF-THEN-ELSE Heater has additional checks
You can now check whether one of the following conditions applies to the incoming value when using the IF-THEN-ELSE Heater.
- IsNull – checks whether the value is NULL or DBNULL
- IsEmpty – checks whether the value is empty or has no content
- IsNumber – checks whether the value is numeric
- IsDateTime – checks whether the value contains a date and/or time
Executing user-defined SQL statements
Release notes for version 2.2.1 on October 24, 2011
New SQL Heater
User-defined SQL statements can be executed with the help of the SQL Heater. In addition to simple SELECT statements substituting the Database Lookup Heater, you can also execute INSERT, UPDATE and DELETE statements. Dynamic SQL statements can be composed using placeholder parameters.
e.g. SELECT id from Product_Table where Product_Name = ‚$PRODUCTNAME$‘
More dynamism with parameters
Release notes for version 2.2.0 on October 17, 2011
More dynamism with parameters
This version integrates a further level of flexibility and performance to FlowHeater. Parameters can now be defined and used in a variety of ways, for example in the Batch Module command line options /SetParameter Name=Value can be passed to FlowHeater.
e.g. FHBatch.exe /SetParameter DATABASE=Import-DB YourDefinition.fhd
You can retrieve this value in the Definition using the new Parameter Heater or alternatively using a placeholder $DATABASE$ somewhere in the configuration. In the case of a database name, you would use it simply enter $DATABASE$ to substitute the value of the text field for the database name. You can use placeholder parameters almost anywhere that free text entry is offered. The Designer also offers you the possibility to define default values for parameters. As a simple example, you could checkout an import/export Definition in a testing environment, then when you are ready to go live, simply switch the relevant parameters.
e.g. FHBatch.exe /SetParameter DATABASE=production /SetParameter Server=obelix import-export.fhd
GroupBy Heater with InString grouping
Release notes for version 2.1.0 on August 1, 2011
GroupBy Heater with InString grouping
In earlier versions of FlowHeater, the GroupBy Heater only grouped data for an identical series of incoming field values. As of this version, the GroupBy Heater also supports grouping on a substring of the input values. A new group is started for each occurrence in the incoming data of a substring specified in the GroupBy Heater properties.
e.g.
From: import@daten.local
Name: import
Info: Yes
From: export@daten.local
Name: export
Info: No
In this case, entering the value “From:” as the grouping condition in the GroupBy Heater will cause the blocks/groups to each commence with the “From:” substring.
Templates
Release notes for version 2.0.7 on July 4, 2011
Templates
This version of FlowHeater introduces support for templates for the first time. Any FlowHeater Definition can now be saved as a Template using the menu option "File -> Save as a Template ..." As many Template files as you wish may be saved this way, catering for the most diverse of requirements. The storage location of Template files is freely selectable. The file extension for a Template file is .fhdt (FlowHeater Definition Template).
