CloverETL Community: List of Features

Available set of components

Readers

  • UniversalDataReader
  • XLSReader
  • DBFDataReader
  • XMLExtract
  • DBInputTable

Writers

  • UniversalDataWriter
  • DBOutputTable
  • XLSWriter
  • Trash

Transformers

  • Reformat
  • ExtFilter
  • ExtSort
  • SimpleCopy
  • Dedup
  • Concatenate
  • SimpleGather
  • Merge
  • Aggregate

Joiners

  • ExtHashJoin

Others

  • DBExecute
  • SystemExecute
  • HTTPConnector


The following features are not available in Community

  • CloverETL Server integration
  • Export functions
  • Fact Table Load wizard
  • Use CloverETL engine other than default
  • All lookups except Simple lookup
  • Search
  • Persistent sequences (only primitive in-memory sequences)
  • Enabling/disabling components & pass-through mode
  • JMS connections
  • User loaded database drivers (only fixed built-in set)
  • Externalized resources (connections, metadata, ...)
  • CTL functions: edit_distance, metaphone, NYSIIS, soundex
  • Custom components


Functional and performance limitations

Feature Commercial Community
Performance unlimited unlimited
Number of processed records unlimited unlimited
Number of components per graph unlimited 20
Number of edges in debug mode unlimited 1
Number of records in debug mode unlimited 100


List of available database drivers

  • MySQL
  • PostgreSQL
  • Oracle
  • SQLite
  • Microsoft SQL Server
  • Sybase
  • Derby