CloverETL Overview

For more details and videos take a look at the Quick Start Guide →

 

Designer UI
Anatomy of a Graph
Read & Write Data
Transform & Modify
Merge & Join
Other Actions
Clover Script
Performance

Reads flat files of any type from file, http, ftp

  XPath parsing
Native and ODBC/JDBC drivers   Simple and complex XML files
Excel worksheets   LDAP / Directory Services / Active Directory
DBase files   Java Message Service
Random Data Generator for creating test data   Read data from the output of another Transformation Graph
         

Reading & Writing Data

Unlike some other products, Clover has deliberately avoided having hundreds of different readers and writers, many of which are very subtle variations on similar components. Instead, Clover has as few as possible but each one is highly configurable with all the parameters needed to get your data in and out of almost any data source.
 

Complex ASCII / Delimited Data Files

Clover can read just about any data file. It has highly detailed support for even the most esoteric data formats. Clover is even able to read from data files that have more than one record type within the same file.
 

 

Clover can also automatically process batches of files in a folder or in a specified list of files. Our Enterprise and Cluster Products can also trigger graph execution as files appear in a folder or when file attributes change. In fact, we will be very surprised if you have ASCII files that cannot be processed by Clover.
 

Databases

Clover will read from and write to any database with a good quality ODBC/JDBC driver. It can also derive data structures directly from database table structure, avoiding laborious manual configuration.
 

Other Readers & Writers

Clover provides support for a wide variety of data sources including

  • Excel (XLS)

  • DBF

  • Lotus Domino

  • Quickbase

  • JMS

  • LDAP
     

Java & Web Service Based Integration

Clover Enterprise and Cluster Editions allow third party systems to call a Web Service interface and may also pass data and parameters into a Clover Graph. Programmers may also use the JMS and Java function calls.
 

Custom Readers & Writers

Custom Components can be written in Java and allow the support of advanced, customized or proprietary formats.