An excellent data integration tool
- Reading for multiple sources: Any modern Database, Files, WebServices, etc.
- Monitoring and scheduling task dependencies for data loading purposes.
- Really useful to design a Data Warehouse, thanks to its built in components for design patterns like SCD, etc.
- It's also useful to publish data interfaces via WebServices or REST.
- Good and high qualified support team.
- Connecting to various databases from classic Relational (MSSQL, Oracle, MySQL, etc.) to No-SQL Databases.
- Well documented.
- Community which provides plugins, etc.
Cons
- Installation process of Integration Suite platform.
- JAVA memory management. It's easy to get a memory overhead error, and you have to modify configuration files to increase memory manually.
- Migration process.