
| Capability | Kalido | ETL Tools |
|---|---|---|
| Create and maintain landing tables | Automated | Manual |
| Single mapping for population of multiple entities/tables | Automated | Manual |
| Dependency management for parallel execution driven by the model | Automated | Manual |
| Graphical query builder to create complex extract definitions | Automated | Manual |
| Type conversion between landing zone and warehouse tables | Automated | Manual |
| Extract only option to data in acquisition layer for subsequent transformation | Automated | Manual |
| De-duplication of data between landing and staging | Automated | Manual |
| Load mappings apply to initial and incremental load | Automated | Manual |
| Loosely typed landing tables to minimize external load failures | Automated | Manual |
| Suspense views and summaries for rejected data | Automated | Manual |
| Multi-entry versioning in single mapping job | Automated | Manual |
ETL tools have their place in many integration projects, however their disadvantages outweigh their ability to assist customers to deliver agile data warehouses that can enable business value in a timely way. Read how Kalido overcomes these issues by automating the data integration tasks which otherwise would be manually constructed – and maintained – in ETL tools.
For more details, read our press release Kalido Speeds Time-To-Value with Information Engine Version 9.0