CloverETL Engine A Java based data integration framework which can be used to transform data
Download

CloverETL Engine Ranking & Summary

CloverETL Engine Tags

data transform database framework data integration integration

CloverETL Engine Description

A Java based data integration framework which can be used to transform data CloverETL Engine, a commercial open source data integration framework written in Java, can be used to transform data.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. Here are some key features of "CloverETL Engine": · internally represents all character data as Unicode - any character from any codepage can be represented - ASCII, LATIN, ASIAN, etc. · converts data from & to common character sets (ASCII, UTF-8, ISO-8859-1,ISO-8859-2, etc) · contains palette of more than 50+ specialized transformation components · nativelly 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 · reads & writes XML data/ Excel (XLS) data/ variable length data (CSV) / fix-length data and several other not so common formats (dBase/FoxPro/FlashFiler) · supports remote reading/writing of data through FTP/SFTP/HTTP/HTTPS protocols, also works with ZIPed & GZIPed data · offers 5 different lookup table types (Simple, Range, Database, Persistent, Aspell) · runs on 32bit & 64bit platforms - Windows, Linux, AIX, Solaris, HP-UX, AS/400 (System i) and many others · data records are internally handled as a variable-length data structures - can handle very large records (theoretical limit 231) · 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 · 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 Requirements: · Java 2 Standard Edition Runtime Environment What's New in This Release: · This version adds an optimized UniversalDataReader, Trash print ID, unification in treating null and empty fields in many components (Dedup, etc.), a -skipcheckconfig runtime option, and the ability to include comments in SQL queries.

CloverETL Engine Related Software