Among all ETL tools used, Clover ETL comes closes to Ab Initio in look and feel.
I felt immediately at home with Clover's Designer (equivalent to Ab Initio's GDE).
Here is a 1-to-1 equivalent of Clover's components compared with Ab Initio's.
I felt immediately at home with Clover's Designer (equivalent to Ab Initio's GDE).
Here is a 1-to-1 equivalent of Clover's components compared with Ab Initio's.
| Ab Initio | Clover ETL |
| Input files | Universal Data Reader |
| Output files | Universal Data Writer |
| Reformat | Reformat |
| Join (in memory) | ExtHashJoin |
| Join (sorted) | ExtMergeJoin |
| Run component | SystemExecute, DBExcute, RunGraph |
| Join with DB | DBJoin |
| Lookup | Lookup Join |
| DB Table | DB Input Table |
| Trash | Trash |
| Filter | ExtFilter |
| Sort | ExtSort |
| Sort within Group | SortWithinGroups |
| Replicate | SimpleCopy |
| Dedup | Dedup |
| Concatenate | Concatenate |
| Gather | SimpleGather |
| Merge | Merge |
| Partition | Partition |
| Aggregate (deprecated) | Aggregate |
| Normalize | Normalizer |
| Denormalize | Denormalizer |
| Rollup | Rollup |
