CloverETL

• Overview
• CloverETL Engine
  • Commercial × Open source
• CloverETL Designer
  • Designer Editions
  • Components
  • Screenshots
  • Videos
  • Designer Pro Server Integration
  • Buy
• CloverETL Server
  • Server Editions
  • Screenshots
  • Videos
  • Live demo
  • Server × Engine
  • Launch Services
  • Buy
• White Papers
• Licensing
• Development
  • Code Repository
  • Bugtracker

While using Java technology it allows for platform independence. It can be used standalone - as a server application or can be embedded in other applications as a transformation library.

CloverETL Engine is released under dual-license:

• commercial
• LGPL License.

Feature Highlights

• converts data from & to common character sets (ASCII, UTF-8, ISO-8859-1,ISO-8859-2, etc)
• supports all major industry standard databases (Oracle, MS SQL, DB2, Infromix, Sybase) and several open source variants (MySQL, PostgreSQL). Other databases are supported through JDBC layer
• contains palette of more than 50 specialized data transformation components
• reads & writes XML data/ Excel (XLS) data/ variable length data (CSV) / fix-length data and several other not so common formats
• contains connectors to other systems through standard protocols: middleware - JMS, LDAP, SOAP
• reads&writes legacy data formats - dBase/FoxPro/FlashFiler/QuickBase
• supports remote reading/writing of data through FTP/SFTP/HTTP/HTTPS protocols, also works with ZIPed & GZIPed data
• runs on 32bit & 64bit platforms - Windows, Linux, AIX, Solaris, HP-UX, AS/400 (System i) and many others

More Features

• internally represents all character data as Unicode - any character from any codepage can be represented - ASCII, LATIN, ASIAN, etc.
• data records are internally handled as a variable-length data structures - can handle very large records (theoretical limit 2³¹)
• fields can have default values, text formats, NULL value checkers
• contains connectors to other systems through standard protocols: middleware - JMS, LDAP, SOAP
• transformation of data is performed by independent components, each running as an independent thread - can utilize more than one CPU (is very scalable)
• framework implements so called pipeline-parallelism - when data record is processed by component, it is immediately sent to the following component for additional processing.
• contains interpreter of specialized transformation language - CTL
• offers 5 different lookup table types (Simple, Range, Database, Persistent, Aspell)
• transformations (mappings) of data can be also coded directly in Java or any other scripting language
• metadata describing structures of data (records) and transformations can be read/written from/to XML
• works with common Source Code Management Systems - CVS, SVN, SourceSafe
• can be easily extended by custom components

CloverETL Engine Overview

More detailed information on CloverETL Engine's functionality can be found in the CloverETL Engine Overview slides (in PDF format).