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.
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
Writers
Table 1.3. CloverETL Community Edition vs CloverETL Designer comparison - Writers
Transformers
Table 1.4. CloverETL Community Edition vs CloverETL Designer comparison - Transformers
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 | | |