December 19, 2017
Score 9 out of 10
Overall Satisfaction with Talend Data Integration
We have a high amount of excel files coming in from different departments. They all have a different data structure. It was very difficult integrating all the types of data, with different data sizes. We used Talend to integrate data in one format. We had to perform data analysis, pattern recognition. It had a big impact on overall efficiency. We also found several bottlenecks, and narrowed our focus area.
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.
It is very useful for disparate data sources like Excel, Microsoft Access, SQL server or any relational database. Also, cases where you need data transformation, a lot of pre-processing, Talend is very good. Its tMap is very useful. It also has various transformers, and we can add custom logic for various data fields.