Item: Talend Data Integration
Rating: 9
Author: Sanket Bharaswadkar

Use Cases and Deployment Scope

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.

Pros and Cons

data integration
support for different data sources
documentation

memory management
too technical for business users
IDE is slow

Return on Investment

clean design
easy to use
high ROI

Alternatives Considered

Alteryx Analytics

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.

Other Software Used

Alteryx Analytics, SAS Business Intelligence, Pentaho

Likelihood to Recommend

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.

Talented Talend

Overall Satisfaction with Talend Data Integration