An excellent data integration tool
September 28, 2016
An excellent data integration tool
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Talend Integration Suite
Talend is used to build a corporate data warehouse solution which centralizes all relevant company intel into a single repository. Talend is used for development only by the IT department (as expected) but the information it gathers is used for the whole company. The main problem which talend addresses is to unify different sources of intel by retrieving data from databases, files, web services, the internet, etc.
- 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.
- 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.
- Easy to build complex data transformations.
- Licensing model isn't that flexible.
- Memory mangement for huge volumes of information. You have to modify ETL designs to handle it properly.
- SQL Server Integration Services and Kettle
Compared to Microsoft SQL Server Integration Services (SSIS) talend gives developers much more tools and flexibility in order to achieve different ETL processes. For instance, SSIS, separates processing from data management, and Talend mixes both stages so that you can perform complex processes like iterating sub-jobs for each data row. It also provides a huge component list compared to SSIS which allows retrieving and saving data from many various sources. The administration part is also wider than what is offered from SSIS. In other words, SSIS is like a toy compared to Talend Integration's capabilities.
When comparing Talend with Kettle (Pentaho) it's is easy to find similarities because they are both similar tools. In my experience, I'd rather [use] Talend because, in my opinion, it is more focused at data management. Kettle is a component provided from a wider BI tool, and Pentaho is not only focused at data management. I also found Talend gives better performance and manages connection sockets better than Kettle.
When comparing Talend with Kettle (Pentaho) it's is easy to find similarities because they are both similar tools. In my experience, I'd rather [use] Talend because, in my opinion, it is more focused at data management. Kettle is a component provided from a wider BI tool, and Pentaho is not only focused at data management. I also found Talend gives better performance and manages connection sockets better than Kettle.