CloverETL - All Releases

Use this list as a quick reference of new features and upgrade notes.
Get detailed information for each version by opening full release notes.

CloverETL 4.6

View full release notes for 4.6 – Released June 13, 2017

Major Production Release

Auto-debugging on edges; all edges now collect a sample of 1,000 records during development
Event listeners monitoring details
Performance increase in Executions History view
Salesforce bulk read deleted records
Filter dialog shows Dictionary entries
Edit Component dialog cleanup
Quick tutorial for new users

Compatibility / Upgrade Notes

New projects in Designer are set to UTF-8 encoding by default
Designer installation package updated to JDK 8u121
FlatFileReader behavior changed for encoding-related errors with Controlled policy in effect.

CloverETL 4.6.0.M2

View full release notes for 4.6.0.M2 – Released May 16, 2017

Milestone

SalesforceBulkReader ability to read deleted records
Filter editor has Dictionary available
Edit component dialog cleanup

CloverETL 4.6.0.M1

View full release notes for 4.6.0.M1 – Released April 11, 2017

Milestone

Automatic edge debugging (first 1,000 records)
Monitoring Details for Event Listeners
Performance improved for Executions History
Quick tutorial for newcomers

Compatibility / Upgrade Notes

New projects in Designer are set to UTF-8 encoding by default
Designer installation package updated to JDK 8u121

CloverETL 4.5

View full release notes for 4.5 – Released March 14, 2017

Major Production Release

Salesforce Wave connector
Event listeners overhaul
Restart jobs on Server

Compatibility / Upgrade Notes

Removed CTL1 support
JSch library updated
MongoDB driver updated
Inline CTL code (e.g. `today()`) no longer works in strings
ExtFilter renamed to Filter
Salesforce components now use API version 39
HttpConnector uses CloverETL engine default charset now
JSONExtract and XMLExtract will now fail if there is a field referenced in the mapping that is not present in the output metadata.
Dropped binary builds for Linux 32-bit

CloverETL 4.5.0.M2

View full release notes for 4.5.0.M2 – Released February 21, 2017

Milestone

Event Listeners overhaul
Restart jobs on Server
Removed CTL1

Compatibility / Upgrade Notes

Removed support for CTL1
Inline CTL1 in backquotes no longer supported.
ExtFilter renamed to Filter
Salesforce components now use API version 39
HttpConnector default charset changed
JSONExtract and XMLExtract now fail on missing metadata fields

CloverETL 4.5.0.M1

View full release notes for 4.5.0.M1 – Released January 31, 2017

Milestone

Salesforce Wave Analytic writer
Restart jobs with parameters on Server

CloverETL 4.4.1

View full release notes for 4.4.1 – Released February 14, 2017

Production Bugfix

CloverETL 4.4

View full release notes for 4.4 – Released December 15, 2016

Major Production Release

Salesforce SOAP API-based Connector: Complex Queries and Attachments (joins, functions, subqueries)
Remote File Listeners (FTP, SFTP, Amazon S3 and Samba) + "File Finished" Check
Task Failure Listeners allow you to configure reactions to failures of other listeners
Amazon Redshift Driver is Now Built-in
ParallelReader Supports S3
Filter shortcut in Data Inspector
Filter shortcut in Data Inspector

Compatibility / Upgrade Notes

Changed default encoding to UTF-8 (previously ISO-8859-1) in core components
SpreadsheetDataWriter no longer allows String field as a target when writing to output port
Unified behavior of DECIMAL type in implicit vs. explicit mappings. Will produce Runtime Errors instead of ignoring mismatched precisions.
Update bundled Java in Designer to 1.8.0_101
SalesforceReader: subquery join type is now always set to LEFT OUTER JOIN

CloverETL 4.4.0.M2

View full release notes for 4.4.0.M2 – Released November 16, 2016

Milestone

Salesforce Connector: New SalesforceReader (SOAP-based, complex queries)
Task Failure Listeners

Compatibility / Upgrade Notes

Changed default encoding to UTF-8 (previously ISO-8859-1) in core components
SpreadsheetDataWriter no longer allows String field as a target when writing to output port
Unified behavior of DECIMAL type in implicit vs. explicit mappings. Will produce Runtime Errors instead of ignoring mismatched precisions.

CloverETL 4.4.0.M1

View full release notes for 4.4.0.M1 – Released October 18, 2016

Milestone

Salesforce CRM Connector supports Attachments
Remote File Listeners
Reacting to Task Failures
Amazon Redshift Driver built-in

CloverETL 4.3.1

View full release notes for 4.3.1 – Released November 10, 2016

Production Bugfix

CloverETL 4.3

View full release notes for 4.3 – Released September 08, 2016

Major Production Release

Code Debugging for CTL/Java code in components
Salesforce CRM Connector
Execution View filter
Unsorted input for Dedup

Compatibility / Upgrade Notes

Improved metadata concatenation when propagating metadata (CrossJoin, SalesforceBulkWriter)

CloverETL 4.3.0.M2

View full release notes for 4.3.0.M2 – Released August 09, 2016

Milestone

Salesforce CRM Connector

CloverETL 4.3.0.M1

View full release notes for 4.3.0.M1 – Released June 30, 2016

Milestone

Code debugging
Execution View Filter
Unsorted input for Dedup

CloverETL 4.2

View full release notes for 4.2 – Released June 09, 2016

Major Production Release

Version control (Git, SVN, ...) now functions with Server projects
Remote Server files available locally
Convert projects between local and Server
Source editor Syntax highlighting
Draw edge from input

Compatibility / Upgrade Notes

Validator email address rule has new option "Allow addresses with no TLD". Formerly, this was a default behaviour, now you have to explicitly turn it on.
S3 connectivity: Replaced JetS3t with Amazon SDK
Designer as eclipse plugin: Dropped support of Eclipse 3.x
XMLExtract: wrong attribute value is parsed
DBJoin should propagate metadata
Fix: Rollup - preExecute() is never called
Fix: SpreadSheetWriter: mapping by order does not work with hyperlinks
Sequences used in COMPILED CTL no longer skip values
CloverETL now supports IBM InfoSphere MDM version 11.5

CloverETL 4.2.0.M1

View full release notes for 4.2.0.M1 – Released May 12, 2016

Milestone

CloverETL 4.1.4

View full release notes for 4.1.4 – Released June 01, 2016

Production Bugfix

CloverETL 4.1.3

View full release notes for 4.1.3 – Released April 06, 2016

Production Bugfix

CloverETL 4.1.2

View full release notes for 4.1.2 – Released February 25, 2016

Production Bugfix

Compatibility / Upgrade Notes

RichText formatting support in notes
Fix: Populate parent record does not work when an element is mapped to a field with the same name

CloverETL 4.1.1

View full release notes for 4.1.1 – Released December 03, 2015

Production Bugfix

Compatibility / Upgrade Notes

Fix: JSONExtract adds empty string into list

CloverETL 4.1

View full release notes for 4.1 – Released September 10, 2015

Major Production Release

Optional Ports
Better support for AWS and HP Vertica
Generic Java components
Dynamically disabled components
Improvement to UI and UX

Compatibility / Upgrade Notes

Parsing of .classpath file by Server and ETL Runtime
Automatic mapping and parameter propagation in components
XMLExtract, JSONExtract now support list types
XMLExtract - extraction of element content (children elements) with namespace
CTL date parsing - strict option for functions
Removed components RecordToKeyValues and KeyValuesToRecord
Online license activation works over HTTPS
JDBC URL in Designer: '\t' in path is interpreted as tab char
Dynamic graph parameters were recomputed on every access
Fix: XMLXPathReader: charset attribute is ignored
Fix: EmailSender - unify null attachment handling
Fix: Error messages reported via raiseError() should be preserved
Fix: XMLExtract: charset autodetection does not work
Fix: CTL printErr() function should print to graph log

CloverETL 4.1.0.M1

View full release notes for 4.1.0.M1 – Released May 11, 2015

Milestone

New feature: Generic Java Component
Subgraph improvements

CloverETL 4.0.8

View full release notes for 4.0.8 – Released December 08, 2015

Production Bugfix

Compatibility / Upgrade Notes

Fixed - SpreadsheetDataWriter - stream mode creates invalid xlsx
Fixed - File event listener sets wrong value to EVENT_FILE_PATTERN

CloverETL 4.0.7

View full release notes for 4.0.7 – Released August 17, 2015

Production Bugfix

CloverETL 4.0.6

View full release notes for 4.0.6 – Released June 23, 2015

Production Bugfix

CloverETL 4.0.5

View full release notes for 4.0.5 – Released June 10, 2015

Production Bugfix

Compatibility / Upgrade Notes

Server Fix: Files out of the sandbox must be inaccessible when using sandbox relative paths
Server Fix: Security - zero-length password should not be allowed for LDAP authentication

CloverETL 4.0.4

View full release notes for 4.0.4 – Released March 11, 2015

Production Bugfix

Compatibility / Upgrade Notes

Fixed: Propagation of metadata defined by SQL does not work
Fixed: UniversalDataWriter: 'Create directories' cannot handle encoded URL

CloverETL 4.0.3

View full release notes for 4.0.3 – Released January 27, 2015

Production Bugfix

CloverETL 4.0.2

View full release notes for 4.0.2 – Released December 17, 2014

Production Bugfix

Compatibility / Upgrade Notes

Server: Added PARENT_RUN_ID and ROOT_RUN_ID parameters
Fixed: adjusted priority for explicitly propagated metadata

CloverETL 4.0.1

View full release notes for 4.0.1 – Released December 01, 2014

Production Bugfix

Compatibility / Upgrade Notes

HTTPConnector authentication behavior has changedsee more details

CloverETL 4

View full release notes for 4 – Released November 12, 2014

Major Production Release

Subgraphs
Automatic Metadata Propagation
Execution View Panel
Tableau TDE Support

Compatibility / Upgrade Notes

CloverETL requires Java 7
Upgraded versions of supported application containers of Server
Upgraded libraries that were in very old versions
Added support of MySQL 5.6 as Server configuration database
Sybase is no longer supported as Server configuration database
Deprecated components are now hidden
Removed old FactTableLoader wizard
CTL: fixed substring() inconsistency with 2 and 3 parameters
CTL: split() now returns empty list if input is null
CTL: indexOf() now accepts null values
Fixed EmailReader propagating CC to all succeeding records
Removed CTL compatibility check wizard
CloverETL Server supports Tomcat 7
CloverETL Designer is bundled with Eclipse 4.3
New "Runtime" for Designer
XLSDataReader and XLSDataWriter are deprecated
Fix: XMLExtract: explicit mapping has priority over implicit automap by name
Fix: Accessing non-existent tracking field in jobflow output mapping fails
Fix: Subgraph debug input and output components are identified by position in graph
Additional graph parameters are set by Runtime (such as RUN_ID).
Removed special ZIP support in CloverDataReader and CloverDataWriter
Fix: Database connection shared by multiple components in graph does not perform commit if the graph fails.
Fix: DeleteFiles recursive delete deleting the whole sandbox if fileURL was empty
Removed "Export metadata to XSD" wizard
Removed "Export graphs" wizard
Mac OS X Mavericks (10.9) might give you a warning about running unsigned software.

CloverETL 4.0.0.M2

View full release notes for 4.0.0.M2 – Released July 31, 2014

Milestone

Subgraphs feature expansion
New "Runtime" layer in Designer
Extended Graph Parameters
Improved Subgraphs editor

CloverETL 4.0.0.M1

View full release notes for 4.0.0.M1 – Released April 10, 2014

Milestone

New feature: Subgraphs
Server Administion improvements

CloverETL 3.5.4

View full release notes for 3.5.4 – Released January 21, 2015

Production Bugfix

CloverETL 3.5.3

View full release notes for 3.5.3 – Released December 11, 2014

Production Bugfix

Compatibility / Upgrade Notes

Fixed: deletion of whole sandbox in case of empty fileURL in DeleteFiles component
Fixed: SpreadSheetReader - problems with default date format

CloverETL 3.5.2

View full release notes for 3.5.2 – Released August 22, 2014

Production Bugfix

Compatibility / Upgrade Notes

Updated JDK bundled with Designer installer to JDK version 1.7.0_51
Started bundling JDK in Designer package for OS X (JDK version 1.7.0_51)
Fixed: dash ("-") was passing through isNumber function as a number

CloverETL 3.5.1

View full release notes for 3.5.1 – Released May 06, 2014

Production Bugfix

Compatibility / Upgrade Notes

When parsing deprecated format of parameter file (.prm from versions prior to 3.5), invalid lines are now ignored
Inline CTL code (`some code`) can now be used inside DB password field
Parameters in obsolete format (created prior to CloverETL 3.5) are now converted every time such parameters/or graph are saved

CloverETL 3.5

View full release notes for 3.5 – Released January 22, 2014

Major Production Release

Server Configuration Migration assistant
New Connectors: Exasol, MongoDB, JSON, HP Vertica
HTTPConnector: Adding streaming and binary data support
Server Audit Log feature
Secure parameters in the Server
Data Quality: Introducing Validator component

Compatibility / Upgrade Notes

Parameter files use XML
Parameters have description
Changed behavior of string functions (e.g. isNumber) failing on empty or null strings
Changed behavior of base64byte() function
Changed record count field to "long" in the Profiler - might produce incompatible integer/long in metadata coming from ProfilerProbe and ExecuteProfileJob
CloverDataReader/Writer data files not compatible between version 3.4 and 3.5 when these components are used in a mix of jobflows and transformation graphs
Functions ceil() and floor() return decimal instead of number for parameters of type decimal
Some conversion functions return NULL instead of throwing an exception
Some date functions return NULL instead of throwing an exception
Null 'case' values in switch() are now allowed
Function get() for lookups now always returns NULL for keys not found or NULL key, exception if unknown field is requested. Before, there was a difference between compiled and interpreted mode - returning null or exception respectively
Fixlen data reading changed in regards to automatic trimming. Read the related issue
Built-in MySQL JDBC driver updated to version 5.1.26 (formerly 5.1.22). The new version is optimized for MySQL 5.6.
FastSort defaults have been changed. Maximum open files is now 1000 by default, Number of sorting threads is 1
Old version of Designer on Windows is automatically uninstalled when new version is installed (only versions 3.5.0-M2 and newer are uninstalled)
Handling of null/empty values in Validator
ParallelReader error metadata no longer uses integer for record number
EmailReader: Fixed inconsistent behavior on POP3 vs. IMAP
Validate names of graph parameters
XMLExtract: explicit mapping to have priority over implicit automap by name
RecordFilter interface declares two isValid() methods
CTL: str2bits does not check validity of its input string

CloverETL 3.5.0.M2

View full release notes for 3.5.0.M2 – Released October 31, 2013

Milestone

CloverETL 3.5.0.M1

View full release notes for 3.5.0.M1 – Released September 11, 2013

Milestone

CloverETL 3.4.3

View full release notes for 3.4.3 – Released November 27, 2013

Production Bugfix

CloverETL 3.4.2

View full release notes for 3.4.2 – Released October 04, 2013

CloverETL

SpreadsheetDataReader now reports better error message when encoutering corrupt .xls files with custom formatted cells
EmailSender now properly initializes connection when it needs it (at phase start) (CLO-1137)
Export graph to HTML - fixed missing international characters; XHTML validation minor fixes; file not getting closed on Windows (CLO-1159, CLO-1148)
Fixed "Closed connection" problem with long running Profiler jobs on Server (CLO-1613)
Fixed Edit component freezing when editing values (Linux-gtk) (CLO-1605)
Fixed "stop view data" action - sometimes freezing Designer on Mac OS (CLO-1454)
Fixed enhanced tooltips producing errors to the Error log on Linux (CLO-1239)

CloverETL Server

User IP address is logged in the userAction log - Server is now logging IP address of the session in the userAction log.

CloverETL 3.4.1

View full release notes for 3.4.1 – Released July 03, 2013

CloverETL

Export graph to HTML improved - added graph description, better look, and newlines are preserved for better code legibility, added new print style
Server Console - Date/Time form fields are now keyboard-enabled
In the Transform editor, you can switch back to the visual three-column mapping editor after removing an invalid code from the Source tab
Fixed DataIntersection dropping some records if 'Allow key duplicates = false'
Fixed NPE occuring when data flowed from JSONReader to ExtHashJoin and both components were in the same phase
Fixed SortWithingGroups outputting more records than were on input
Fixed lookup table not being able to read quoted data
Fixed: A graph with DBLookupTable used in a CTL code is not restartable in batch mode

CloverETL Server

Fixed jobs containing ExecuteGraph/Jobflow that would occasionally hang and could not be aborted

CloverETL 3.4

View full release notes for 3.4 – Released May 15, 2013

Major Production Release

CloverETL 3.4.0.M2

View full release notes for 3.4.0.M2 – Released March 25, 2013

Milestone

CloverETL 3.4.0.M1

View full release notes for 3.4.0.M1 – Released December 19, 2012

Milestone

CloverETL 3.3.1

Released February 01, 2013

CloverETL

Updated Java in Designer Windows installer to Java7u11 due to security fix
WebServiceClient: not working wizard with specific WSDL (CLD-4237)
Fixed NullpointerException when editing properties of a component (CLD-4345)
Fixed Copy&Paste and Redo (CLD-4277)
CTLUtils class is now visible to transformations (CL-2624)
Unified parsers for XLS and XLSX in SpreadsheetDataReader (CL-2610)
Fixed: Recapacity of CloverBuffer is not allowed (CL-2597)
Fixed file operation components to fail on errors (CL-2594)
Fixed SystemExecute now keeps temp file on error (CL-2589)

CloverETL Server

Fixed watchdog reporting incorrect CPU readings (CL-2560)

CloverETL 3.3

View full release notes for 3.3 – Released October 23, 2012

Major Production Release

Production release for CloverETL 3.3.0-M1, 3.3.0-M2 and 3.3.0-M3

CloverETL 3.3.0.M3

View full release notes for 3.3.0.M3 – Released September 05, 2012

CloverETL Designer

Jobflows Designer support (Server Corporate feature)
Data Profiler is now integrated into the Designer (requires Data Profiler license)
Enhanced WebServiceClient and HTTPConnector components
New DBFDataWriter component

CloverETL Server

Jobflows - a workflow module
Temporary Space Management module
Graph parameters can be passed to executed graphs over JMX
Groovy over API

CloverETL 3.3.0.M2

View full release notes for 3.3.0.M2 – Released April 02, 2012

CloverETL Designer

Support for list and map fields in metadata (container types)
CTL2 change in assignment operator '=' (now it assigns by value, not reference)
New components for JSON (JSONReader/JSONWriter)
New components for Java Beans (JavaBeanReader/Writer, JavaMapReader/Writer) - pass data in Java objects through dictionary
Introducing a new XMLReader component based on XPath queries
Merge metadata function in Designer - create new metadata from existing ones by merging fields together
Webservice client extension    
 - added "Timeout" attribute + ability to print SOAP request/response in DEBUG mode
UI improvements    
 - Search functions in Designer - Shift-Space to place new components, Ctrl-O to search components in the open graph
 - Components can be renamed in the Edit component dialog by clicking their names
 - Added multiple templates for a new connection to choose from
Introducing new license manager

CloverETL Server

Fixed when "Cc" and "Bcc" are not filled in "send mail" schedule then they should be ignored

CloverETL 3.3.0.M1

View full release notes for 3.3.0.M1 – Released March 07, 2012

CloverETL Designer

New SpreadsheetDataReader/SpreadsheetDataWriter components with easy-to-use UI    
  • The components replace XLSDataReader and XLSDataWriter (which are kept for backwards compatibility)
  • Vertical(default) and horizontal reading supported
  • Multirow records supported
  • Excel 97/2003 XLS + Excel 2007 XLSX suppoprt
  • Streaming mode for high performance and small memory footprint
  • Easy to use and powerful mapping dialog
Graph elements locking    
  • Safety feature for cooperative environments
  • elements like metadata, connections, parameter files can be locked so that any attempt to modify it results in an alert
Metadata grouping    
  • metadata can be organized into folders in the outline
ComplexDataReader - regular expressions support in the selector
View Data improvements
MS Access / Generic ODBC support

CloverETL Server

Support for Weblogic 10
Web GUI - disabled users can be re-enabled

CloverETL 3.2.1

View full release notes for 3.2.1 – Released January 05, 2012

CloverETL Designer

Fix of View Data dialog error when data contained NULL value/s
WebServiceClient name space support fixed

CloverETL Server

Updated Quartz scheduler to 1.6.5 (see CLS-606)

CloverETL 3.2

Released December 19, 2011

CloverETL Designer

Dynamic Edge Buffers
Transformation Editor Enhancements
Field Labels
Designer Activation

CloverETL Server

LDAP User Management
Cluster Licencing

CloverETL 3.1.2

Released October 13, 2011

CloverETL Designer

XMLWriter minor tweaks    
  • Schema with local imports can now be properly used
  • Mapping generation from XSD no longer prefills element types as values
  • XSD root selection combo default selection changed
  • Drop of a field onto element and binding tweaked to be more user-friendly
  • Root element can contain a binding to a port as long as only one record per file is set. A warning is reported otherwise.
Customization options for OEM partners
Changed file URLs form to be Java compliant    
  • formerly file:c:/example is now correctly file:/c:/example
XMLExtract mapping editor fixed bug: preserve mapping of items mapped by ../ notation
ComplexDataReader GUI fixes - Mac OS X crashes fixed

CloverETL Server

Customization options for OEM partners
Engine plugins can be easily added to the server via configuration option    
  • see http://server-demo-ec2.cloveretl.com/clover/docs/osgi.html
  • Engine plugins library isolation, fixes clashing custom libraries with Server default libraries
MySQL DB installation script - replaced TYPE with ENGINE keyword for newer MySQL versions
Class loader issue on JBoss fixed

CloverETL 3.1

Released June 16, 2011

CloverETL Designer

New component ComplexDataReader (commercial only)    
  • for reading structured and unstructured flat files
  • similar to MultiLevelReader, yet more powerful and user-friendly
Redesigned component XMLWriter (EXT_XML_WRITER)    
  • brand new mapping (incompatible)
  • old XMLWriter still available as a deprecated component
  • supports disk caching for large amounts of data
XML components visual redesign    
  • brand new XMLWriter interface with visual and source editors
XMLExtract improvements    
  • automatic data denormalization
  • metadata creation out of XMLExtract dialog
  • ability to add ports and assign metadata
  • annotations
  • improved error reporting
AddressDoctor component (commercial only)
Lotus Notes Domino Reader/Writer/metadata extract (commercial only)
New component EmailReader (commercial only)
Graph editor visual improvements    
  • handy description bar
  • component autosize for component name
  • improved edge handling
DnD in graph editor improved    
  • drag'n'drop features for dragging files to graph, outline, etc.
New CTL2 functions - xml2json() and json2xml()
Support for WebDAV and Amazon S3 protocols
DBInputTable supports reading SQL queries from input port
Java class wizard intergration into Transform Editor
View data is not modal any more    
  • multiple View data windows can be open at the same time
Graph zoom and scroll information is preserved
Cobol CopyBook format metadata extract wizard
Primitive sequence support (no file required)
Alt-drag note does not work as a container drag
Auto-mapping in Transform Editor is case-insensitive
Binary parsers for integer and long, double (little/big endian, packed decimal)
New component Pivot
New component MetaPivot
PervasiveDB support
Firebird is has now built-in support
Trash multiple input ports
Trash can simulate a writer (Performance/Validate records modes)
New component DataSampler
New attribute for Denormalizer - group size
Performance of CTL random* functions improved
Performance of CTL String.indexOf() improved
Fixed handling of paths with spaces
ParallelReader improvements
Performance of Concatenate improved
Truezip is now used for handling zip files (append, excel)

CloverETL Server

WebDAV API
Web GUI: manual task execution    
  • tasks now can be executed manually instead just by the scheduler
Support for JBoss 5.1
Digest HTTP Authentication
SOAP WS API added to the manual
"graph version" attribute added to the executions history
Launch services requests are logged to the "[tmp]/cloverlogs/launch" by default
Fix: NPE is not thrown when the specified launch service is missing
debug_mode config parameter fixed
better tracking data persistence

CloverETL 3.0.2

Released March 30, 2011

CloverETL Designer

CTL2: Lists and maps of records are now possible.    
Now you can use list of records and maps of records in your code.
Example:
	// lists
	MyDataRecord[] myList;
	MyDataRecord a;
	MyDataRecord b;
	myList[2] = a;
	b = myList[2];
	// maps
	map[string, MyDataRecord] myMap;
	myMap["hello"] = a;
(For maps, only values can be records)
XMLExtract now distinguishes between null and empty strings    
When reading XML files with XML Extract, you can encouter the need to know whether an element or attribute is present in the source
or just has an empty value.
XMLExtract now sets either "null" value whenever the element/attribute is omitted or empty value ("") 
when the element/attribute is present but without a value
Aggregate: avg() and sum() aggregate functions now perform integer overflow check    
Now you can easily see whether the aggration function produce the integer overflow and thus you're not getting the right results.
Fix: DataIntersection correctly reports unsorted input now    
DataIntersection now stops immediately when it sees the input is not sorted properly ensuring data integrity.
UniversalDataReader & Writer now support "Quote character" attribute for specifying    
Quoting support in readers/writers has been around for long time but now you can even specify the quoting character. In previous CloverETL
versions there has been built-in quote defined as either `'` or `"` (quote or double quote).
Now we present more fine-grained setting where the quote character can be defined.   
CTL2: byte and cbyte data types can now be compared with == or != interchangeably
CTL1 and CTL2: Huge performance improvement in index_of() function
New DataSampling example project in engine examples
Updated built-in MySQL JDBC driver to mysql-connector-java-5.1.15
EmailSender: MessageBody can now be multiline
Extract metadata from database can now handle unknown JDBC data types
Fix in DBOutputTable when working with byte values in batch mode
Fixed Partition transform conversion to Java
DBFReader explicit "strict" data policy setting is now correct
XLSWriter now creates empty files correctly
Fixed Denormalizer issue when loading Denormalize transform specified by class name
Fixed DBExecute not working when calling stored procedure and connection defined by JNDI
Fixed SystemExecute running Windows PowerShell scripts
Fixed NPE when linking a lookup table

CloverETL Server

Upgraded facelets lib from 1.1.14 to jsf-facelets-1.1.15.B1.jar because of the JBoss 6.0.0
Removed some jars from the WAR file for JBoss
Added element into persistence.xml (because of JBoss)

CloverETL 3.0.1

Released November 15, 2010

CloverETL Designer

Default locale can be specified in defaultProperties
Fixed opening of the fact table loader wizard
Fixed XML mapping dialog breaking the mapping with skipped elements
Updated Oracle built-in driver class
Fixed annoying delays and hang-ups when working with SQL in Oracle
Components in palette are now sorted in alphabetical order
Fixed Transform Dialog issues when working with faulty lookups
Filter in SQL editor fixed
Import metadata from XSD fixed for names not conforming to Clover conventions
Tracking view incorrect CPU load fixed
Regular expression tester fix for incorrect regexps
error ports of UniversalDataReader and LDAP Reader can now have also byte/cbyte fields instead of just strings
byte and cbyte types in CTL2 are now fully compatible
fixed XMLExtract failing on opening input files in multiple phases
recursive parameter definition is now properly detected and warned in the log
CTL2 "for" cycle consuming memory fixed in CTL2 interpreted mode
ByteBufferUtils.encodeLength(ByteBuffer, int) fixed for 5-byte lengths

CloverETL Server

fixed NPE in HTTP API exec history #5061
added JDBC info to web GUI monitoring section
fix of schedules installation and initialization
Changes in tracking data: "nodeName" now contains node name and new attribute "nodeId" contains node ID. In addition "totalRecords" is of long type now.
all listener sections in web GUI are grouped in one "event listener" section group

CloverETL 3

Released August 24, 2010

CloverETL Designer

Brand new transformation language CTL2    
  • Introducing next generation of CTL (CloverETL Transformation Languge)
  • Typed languge, close to Java, can be transparently converted to Java
  • up to 30% speed increase
Dictionary support in the Designer    
  • Dictionary can be declared in the Designer
New format for boolean data field - e.g. /man|m/female|f/
Fact Table Loader wizard
New attribute 'quotedStrings' on DataWriter component - all written data can be quoted
CSV compliant flat file reading/writing
HTTP authentication support in HTTPConnector component
Extracting metadata from DBF files
Bundled examples with easy setup
Improved edge drawing for complex graphs
Default locale can be specified globally for the environment
FTP wildcards support added
Dictionary data types support enhanced to all CloverETL data types
Optimized resource allocation in CloverETL Server/Designer
Hundreds of minor functional and usability improvements
new Dictinary types: integer,long,number,decimal,boolean,date,byte
new RunGraph component attribute "paramsToPass"
dedicated graph property name "PROJECT_DIR" (absolute path to project home directory) was substituted by attribute at GraphRuntimeContext.contextURL    
  • new command line attribute -contexturl <path> should be used instead of -P:PROJECT_DIR="<path>"
equalNulls attribute of Merge component was removed - value of this attribute was fixed on 'true' value
list of components in tracking log (in console) are topologically sorted
new attributes for SystemExecute component - workersTimeout, charset
new attribute 'Collator sensitivity' on DataRecordMetadata
Joda date formatter is now default formatter (java formatter is still available with prefix "java:" in format string)

CloverETL Server

Distributed graph execution    
A graph can now run on multiple nodes in a cluster
Introducing Local and distributed sandboxes
File event listener enhanced file name pattern
JMS message listeners
Groovy event listeners
Refactor of send JMS msg task; jms API is removed from the WAR file
license parameter for sandboxes management
graph parameters SANDBOX_CODE_PROPERTY_KEY, SANDBOX_ROOT_PROPERTY_KEY, GRAPH_FILE_PROPERTY_KEY renamed to proper names SANDBOX_CODE, SANDBOX_ROOT, GRAPH_FILE
sandbox file is downloadable on url /clover/downloadFile?sandbox=[sandboxCode]\&file=[filePathInSandbox] (requires BASIC HTTP Authentication)
OSGi framework embedded in the server, so CloverETL Server APIs (i.e. some specific WebServices) may be implemented as OSGi bundles
HTTP API operations executions_history and graph_status may return detail status data in XML
fix of passing event parameters to the graph (see description of back-port in the section REL 2-9-5 for more details)
Executions enqueuing enabled/disabled switch
Archivator reliability improved
HTTP API executions_history operation - ordering parameters
Task Archivator has new option - "Include dictionary files" - all dictionary temporary files older than specified timestamp will be removed
swaref standard for binary data transmission in our webservice interface was substituted by mtom standard    
  • backward compatibility was broken
tracking data are stored in table run_record in binary serialized format for new records; tracking_* tables keep in DB and contain tracking data for older records
verbose mode is off by default

CloverETL 2.9.5

Released August 23, 2010

CloverETL Designer

Added support for custom extension point to add extra VM arguments to graph run configuration

CloverETL Server

passing parameters between graphs using "graph event listener" feature; back-port of issue #4907 from the branch 3.0;    
  1. Older versions passed all source graph parameters which overrided parameters in executed graph.
  2. Since version 2-9-5 server passes only parameters explicitly specified in the "execute graph" task. Please see the section "Execute Graph Task" in server manual for details.
  3.     It's possible to enable old-fashion behaviour by server config property "graph.pass_event_params_to_graph_in_old_style".     

CloverETL 2.9.4

Released July 22, 2010

CloverETL Server

Added support for IBM Java

CloverETL 2.9.3

Released June 03, 2010

CloverETL Designer

Special characters in external transformations are no longer expanded
Fix of #4252 RunGraph component - GraphNotFound on the server
Fixed incorrect resolving of special characters in transforms specified by URL
Reset fix in InfobrightDataWriter

CloverETL Server

fix of concurrent graphs which end with error status

CloverETL 2.9.2

Released April 22, 2010

CloverETL Designer

Multiple external elements (metadata, connections, etc.) can now be linked by multiselect in file dialog
SQL-2-Clover and vice versa type conversions optimized
SQLite support improved
added record type in Variables tab of Transform Editor
added "parent" and "root" buttons to file dialog
double-dash comments in SQL are now possible
Invalid metadata in extract from flat file can now be save on user request
Example projects using DB migrated to Derby - easy setup for newbies
CloverDataReader is now able to read without index file
Fixed Oracle-specific crash with specific driver-level Java access
Fixed slow DB extract metadata for large table
CTL editor fixed - rarely break CTL code syntax
Mac specific GUI fixes (font size, shortcut keys)
FastSort NPE fix with non-nullable record and no default value
fixed XLSWriter long sheet names issue
fixed occasional NPE in DataIntersection
fixed DB2DataWriter not finishing in pipe mode
fixed ExtSort sorting composed key with nulls incorrectly
fixed fields delimited by "\n" - doubling backslash
fixed Reading timestamps from XLS sheets

CloverETL Server

Added support for IBM WebSphere 7
Upgrade of Spring to 2.5.6
Upgrade of RichFaces to 3.3.2
Changed namespaces and names of WebServices API - causes incompatibility with older versions
fix: Server time label
fix: Web GUI task log filtering
fix: NPE in JMX API killGraph method
fix: HTTP API execution status
graph parameters SANDBOX_CODE_PROPERTY_KEY, SANDBOX_ROOT_PROPERTY_KEY, GRAPH_FILE_PROPERTY_KEY renamed to proper names SANDBOX_CODE, SANDBOX_ROOT, GRAPH_FILE
fix: NPE when launch service's graph has component without ports

CloverETL 2.9.1

Released February 19, 2010

CloverETL Designer

File dialog improvements
Browsing of Server projects on separate tab
improved SFTP performance
Linking of external parameter files fixed
Occasional freeze on Mac OS fixed
JMS Writer - Fix of exception propagation during sending of JMS message
fixed HashPartition function giving negative port numbers occasionally

CloverETL 2.9

Released January 29, 2010

CloverETL Designer

New component for connecting to Infobright database
New component for connecting to Web Services (WebServiceClient)
XLS reading - formatted value can be obtained as a String type field if needed
Tracking - in final tracking summary average Rec/s and KB/s is displayed
LDAPWriter - possibility of changing/disabling multiseparator
CTL transformation has now PROJECT_DIR available
new AbstractPartitionFunction for Java writen PartitionFunction
Parameter files can be located outside project
Completely redesigned File URL dialog for better user experience
Parsing of NULL values from flat file by specifying custom "null" keyword
Improved User's Guide
Quick Start Guide
Aspell lookup threshold setting fine tuning
Eclipse branding for bundle version
Path to JAR in JMS connection definition now supports parameters
Export: image path in HTML file fixed
missing column names when browsing Oracle database
external metadata from outside project can be now used
PostgreSqlDataWriter and OracleDataWriter - NullPointerException fix
Reading of zipped MS Excel files

CloverETL Server

support for Jetty servlet container
fix HTTP API operation graph_status complains 'RunRecord is null'

CloverETL 2.8.1

Released October 21, 2009

CloverETL Designer

DBInputTable - incremental file is created automatically when properly configured
AspellLookupTable can now return edit distance
DBOutputTable has new attribute "Atomic SQL query" for ensuring that SQL query rollbacks on error
SQL query in DBExecute can have comments inside
Bundled jTDS for direct support for Microsoft SQL Server and Sybase
Support for SQLite database browsing
Drivers for Microsoft SQL Server and Sybase are bundled with Designers and readily available
Dynamic default value hints display current values based on graph settings
JDBC driver can be specified without loading the JAR - thus allowing the JAR to be on classpath
Unified use of Clover file URL dialog
Minor usability fixes in Server integration (Designer Pro)
Parameter file linking in Server project
Fixed occasional exceptions when loading external lookup tables
Fixed CPU info tracking for multithreaded components
Fixed special characters resolving in some URL attributes
XMLWriter can be created from Java
Minor fixes in InformixDataWriter

CloverETL Server

fix of tracking graph persistence
fix of thread synchronization during graph abortion
some spelling changes in web GUI

CloverETL 2.8

Released August 21, 2009

CloverETL Designer

CloverETL Server Integration - connect to Server (Designer Pro only)    
  • CloverETL Designer
Unified versioning of CloverETL Engine and Designer (starting with 2.8.0)
Method DataRecord2JmsMsg.createLastMsg(DataRecord) is deprecated. Use the same method without parameters instead.
org.jetel.component.jms.JmsMsg2DataRecordProperties can process javax.jms.BytesMessage
bodyField attribute of JmsReader/JmsWriter have default value
interfaces DataRecord2JmsMsg and JmsMsg2DataRecord now have 2 new methods: setGraph(TransformationGraph) and getGraph()
context(thread) class-loader changed to current(class) class-loader
new run option: -skipcheckconfig
optimized UniversalDataReader
Trash now can print out its ID for debugging purposes
unified null and empty field values in sorting, Dedup, etc.
Designer has two versions: Designer and Designer Pro

CloverETL Server

fixed JMX notifications in cluster
cluster node mutually diagnostics
JNDI DB DataSource usable for server DB connection
simple HTTP API operation graph_run accepts params which are passed to executed graph as additional properties
launch services API optionaly passes URL parameters to graph as additional properties
refactor of Graph Config properties + additional parameters