CloverETL 3.3.0-M2 – Enhanced Support for Rich Data Structures

The new CloverETL milestone release brings two major improvements. The first is an enhancement to the CloverETL platform in processing rich data structures. This allows users to work with an array or map of values in a single data field. The second is a collection of new connectors for reading and writing JSON and POJOs (Plain Java Objects).

Sign in to download the new version →

Support for List and Map Fields

This is one step that CloverETL is taking to enhance its support for both rich data structures and unstructured data. A field in metadata can now be declared as a list of values or as a map – a pair of a key and a value. This enhancement eases the previously rigid metadata model, which required each processed data record to be exactly described to the last item. With the new version, data coming from systems where the structure of record varies from record to record (as are CRMs, social networking systems) can now be easily processed in CloverETL by utilizing the variable length lists or even more flexible maps.

Support for lists and maps now spans across the whole platform: from the metadata editor, through CTL, to passing lists and maps over to a dictionary. Lists and maps now may become handy in processing XML, to name one use case.


CloverETL 3.3.0-M2 - Lists and Maps

 


CloverETL 3.3.0-M1 - JSON and Java Objects


Reading and Writing JSON and Java Objects

A number of new readers and writers are now available for closer cooperation with web and Java applications. CloverETL can directly connect to and produce JSON data. Two other connectors JavaBeanReader/Writer and JavaMapReader/Writer help to integrate standard Java formats and Java applications into data transformations.

Search Dialog for Components and CTL Functions

As the number of components is increasing, this new feature helps to find a proper component without using the components palette. A keystroke (Shift-Space) or a click on a toolbar icon opens up a component search dialog where you can look for a component by either its name or description.

CloverETL 3.3.0-M2 - Search Toolbar

CloverETL 3.3.0-M2 - Search Dialog