Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!

New Stop Heater/Function

Release notes for version 2.2.3 on January 02, 2012

 

Terminate a Import/Export definition
Terminate a Import/Export definition

Stop Heater for controlled termination of Definition execution

By making use of the new Stop Heater you can prematurely terminate an import/export run.

Two kinds of termination are possible:

  • normal termination after processing of a specified number of rows
  • immediate termination with a specified error message

 

IF-THEN-ELSE Heater additional checks

Release notes for version 2.2.2 on November 28, 2011

 

IF-THEN-ELSE Heater has additional checks
IF-THEN-ELSE Heater has additional checks

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

Continue Reading

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$‘

Continue Reading

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

Continue Reading

GroupBy Heater with InString grouping

Release notes for version 2.1.0 on August 1, 2011

 

GroupBy Heater with InString grouping
GroupBy Heater with InString grouping

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: This email address is being protected from spambots. You need JavaScript enabled to view it.
Name: import
Info: Yes
From: This email address is being protected from spambots. You need JavaScript enabled to view it.
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.

Continue Reading