Talend Data Integration Reviews

Talend is the best for ETL out of all the other products we looked at. Of course, it is not meant for synchronous services. But, batch jobs that we schedule and run on bulk data are the best fit for Talend Data Integration. Though Talend does not provide a preview of transformed data like SnapLogic, it is very efficient in data processing and transformation.

Talend is much versatile in assimilating various different business use cases. It covers more functionality and is packed with tons of features to explore. It has the ability to fine tune to each project, and not be a one-fits all solution. Problems with Excel, is that it is not suited for large projects, collaboration work. Alteryx is a very costly alternative.

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.

Most other tools of similar nature work well for small and medium sized data warehouses, but fail to maintain performance for very large data warehouses. However, Talend works decently well on large data as well. On the other hand, there are software tools like Oracle Data Integrator that are especially made for large orgs, and Talend cannot match up to those benchmarks.

Talend has all the data integration features needed for an enterprise along with big data integration. It stands tall as a data integration suite and has a low cost as compared to some of its commercial counterparts. Talend does not have reporting tools like Pentaho but its data integration features are more powerful.