Saving the Best for Last: CloverETL at the Tableau Conference in Seattle


After four full days of discussing data, and the opportunities and challenges that come with it, Tableau’s Destination Data Conference in Seattle has come to an end. The event, the third we attended as an official partner of Tableau, and by far the largest of the year, was sold out with over 5600 attendees, many who came to see how data solutions like Clover can empower their Tableau analytics and visualizations.[Continue reading]

CloverETL 4.0 Milestone 2 released. Brace for subgraphs!

Rapid data integration easy with tweaked UI interface.

The second milestone of 4.0 is here so it’s about time to show you what it involves. Milestone releases give you early access to new features and improvements in CloverETL. The second milestones are usually very close to the final production version - nearly all features of the production version are in the milestone release so you can start preparing for the transition.[Continue reading]

New Release Model Offers Clover Users The Choice

Production and milestone releases

As you may have noticed, the latest CloverETL release is labeled as a milestone release. What does this mean exactly? Well, this release marks the beginning of our new release model that will fulfill two separate, but important requirements that our customers have been asking for: the need for sustained stability in operations as well as the availability of new features as they come out.[Continue reading]

Big Time with Big Records

Those of you who have ever tried to process big records with CloverETL already learned that it required some tweaking and special care to make it run smoothly and efficiently. In some cases, CloverETL could get too greedy with memory requirements for a graph run, making it quite cumbersome to set up. With CloverETL 3.2 we have introduced improved memory management in the runtime layer that has optimized memory usage when running graphs with big records.[Continue reading]

CloverETL Visions for 2012: Evolution and Revolution in Data Integration

Part one - celebrating 10 years
In 2012, CloverETL will celebrate its 10th anniversary as an open source project. It all started back in 2002. On October 3rd, 2002, version 0.1 was first announced on the Freshmeat (now Freecode) portal. That day, CloverETL’s official life began.[Continue reading]

Building Data Warehouse with CloverETL: Slowly Changing Dimension Type 2


In the last part of our data warehouse (DWH) tutorial, I showed you how to load a dimension table that stores historical data according to the Slowly Changing Dimension Type 1 (SCD1). In today’s post, I will focus on a Slowly Changing Dimension Type 2 (SCD2) dimension table. I think that SCD2 is the most challenging sub-task of ETL part of DWH design and each ETL architect should be able to deal with it.[Continue reading]

Loop Execution of Data Transformation


Case study description
Czech Insolvency Registry ( basically contains data about economic subjects that entered insolvency and have financial difficulties with paying off their debts. The registry allows everybody to download data using public SOAP Web Service. It can be done manually or automatically with the right software.[Continue reading]