Home | Table of Contents | CloverETL Community Edition | CloverETL 4.6.1
--- | --- | ---
Prev | Family of CloverETL Products | Next

## CloverETL Community Edition

CloverETL Community Edition is a free edition of CloverETL Designer for non-commercial and commercial use with limited functionality.

Figure 1.4. CloverETL Community Edition

### Limitations of CloverETL Community Edition

- Maximum number of components in a graph is limited to 20.

### Unavailable Functionality in CloverETL Community Edition

- Server integration

- Jobflow

- Data quality

- All export functions except export graph

- Use of other clover engine than the default

- All lookup tables except simple lookup

- Sequences

- Disabling components and pass through mode

- CloverETL Log Console

- Advanced CTL functions, see list below

- JMS* features (connections)

- Cluster and Deprecated categories in palette

- Connection wizard does not allow you to load a user driver. Only provided set of drivers is available.

- Run graph configuration has Use cloveretl engine disabled and fixed to check state.

- Some advanced CTL functions are not available.

  - editDistance

  - metaphone

  - NYSIIS

  - soundex

  - iif

  - isnull

  - nvl

  - nvl2

  - printErr

  - printLog

  - raiseError

### Components

Table 1.1. CloverETL Community Edition vs CloverETL Designer general comparison of components

Components | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
Readers | 10 | 26
Writers | 7 | 31
Transformers | 10 | 22
Joiners | 2 | 7
Job Control | 1 | 7
File Operations | 0 | 5
Others | 5 | 10

FlatFileReader is an alias for UniversalDataReader, therefore the both components are counted as one. The same approach is applied on FlatFileWriter and UniversalDataWriter.

### Readers

Table 1.2. CloverETL Community Edition vs CloverETL Designer comparison - Readers

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
CloverDataReader |  |
ComplexDataReader |  |
CustomJavaReader |  |
DataGenerator |  |
DBFDataReader |  |
DBInputTable |  |
EmailReader |  |
FlatFileReader |  |
HadoopReader |  |
JavaBeanReader |  |
JMSReader |  |
JSONExtract |  |
JSONReader |  |
LDAPReader |  |
LotusReader |  |
MongoDBReader |  |
MultiLevelReader |  |
ParallelReader |  |
QuickBaseRecordReader |  |
QuickBaseQueryReader |  |
SalesforceBulkReader |  |
SalesforceReader |  |
SpreadsheetDataReader |  |
UniversalDataReader |  |
XMLExtract |  |
XMLReader |  |
XMLXPathReader |  |

### Writers

Table 1.3. CloverETL Community Edition vs CloverETL Designer comparison - Writers

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
CloverDataWriter |  |
CustomJavaWriter |  |
DB2DataWriter |  |
DBFDataWriter |  |
DBOutputTable |  |
EmailSender |  |
FlatFileWriter |  |
HadoopWriter |  |
InfobrightDataWriter |  |
InformixDataWriter |  |
JavaBeanWriter |  |
JavaMapWriter |  |
JMSWriter |  |
JSONWriter |  |
LDAPWriter |  |
LotusWriter |  |
MongoDBWriter |  |
MSSQLDataWriter |  |
MySQLDataWriter |  |
OracleDataWriter |  |
PostgreSQLDataWriter |  |
QuickBaseRecordWriter |  |
QuickBaseImportCSV |  |
SalesforceBulkWriter |  |
SalesforceWriter |  |
SalesforceWaveWriter |  |
SpreadsheetDataWriter |  |
StructuredDataWriter |  |
TableauWriter |  |
Trash |  |
UniversalDataWriter |  |
XMLWriter |  |

### Transformers

Table 1.4. CloverETL Community Edition vs CloverETL Designer comparison - Transformers

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
Aggregate |  |
Concatenate |  |
CustomJavaTransformer |  |
DataIntersection |  |
DataSampler |  |
Dedup |  |
Denormalizer |  |
ExtSort |  |
FastSort |  |
Filter |  |
LoadBalancingPartition |  |
Merge |  |
MetaPivot |  |
Normalizer |  |
Partition |  |
Pivot |  |
Reformat |  |
Rollup |  |
SimpleCopy |  |
SimpleGather |  |
SortWithinGroups |  |
XSLTransformer |  |

### Joiners

Table 1.5. CloverETL Community Edition vs CloverETL Designer comparison - Joiners

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
Combine |  |
CrossJoin |  |
DBJoin |  |
ExtHashJoin |  |
ExtMergeJoin |  |
LookupJoin |  |
RelationalJoin |  |

### Job Control

Table 1.6. CloverETL Community Edition vs CloverETL Designer comparison - Job Control

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
Fail |  |
GetJobInput |  |
Loop |  |
SetJobOutput |  |
Sleep |  |
Subgraph |  |
Success |  |

### Others

Table 1.7. CloverETL Community Edition vs CloverETL Designer comparison - Others

Component | CloverETL Community Edition | CloverETL Designer
--- | --- | ---
CheckForeignKey |  |
CustomJavaComponent |  |
DBExecute |  |
HTTPConnector |  |
LookupTableReaderWriter |  |
MongoDBExecute |  |
RunGraph |  |
SequenceChecker |  |
SystemExecute |  |
WebServiceClient |  |

Prev | Up | Next
CloverETL Cluster | Home | Table of Contents | Getting Additional Information