Talend OpenStudio building your EDW at $0 cost
October 06, 2016

Talend OpenStudio building your EDW at $0 cost

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Talend Integration Suite

We use the big data edition of Talend Integration Suite. It is used by the Business Intelligence department for extract transform load (ETL). There are more than 400 jobs that pull data or push data from various sources. Talend is used to load data into the enterprise data warehouse. (EDW). I use the big data edition to pull data from hive cluster. There are complex sources like highly nested JSON and XML that can be easily parsed using Talend components. The best thing I like about Talend is the ease of use/debug and ease of deployment. Behind the scenes it uses Java coding, so whatever you do in the interface can be easily visible under code. Packaging and deployment of code is easy too in any environment (Windows or Mac or Linux) with any version of Java compatibility.


  • JSON parsing, if you are into highly nested JSON object parsing Talend has the ability to display the structure of JSON and allows you to define the extraction logic in the metadata. Same with XML source.
  • Customization, For mostly all ETL work you will have a component in Talend. And in case you have a very specific requirement you can end up easily designing a custom component that you can code and reuse and share with others.
  • Talend has a connectivity option to almost all the databases (relational or NOSQ)L and sources available. It also has generic JDBC/ ODBC drivers in case you need it.
  • I like the ease of deployment across environment (DEV and PROD) with the use of context variables.


  • The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.
  • The product provides a cost effective solution to integrate salesforce data source
  • With a single big data license customers can develop and deploy a full EDW solution
  • Administration and installation

There are code building and code conversions internally in most of these ETL tools. The repository is an overhead in the ETL process. There may be a need for a full-time administrator to manage deployments and monitor jobs. With Talend, it seems to be transparent with the pure JAVA/PERL code. You have the ability to easily customize your code. It has support for big data integration. The data quality/ MDM tools can be easily integrated with Talend ETL.

The license cost is low compared to other ETL tools. With the new version of talend cloud-based hosted deployment is also available. An overall full featured open source version of Talend studio is available that can be used at zero cost with some amount of scripting to automate tasks.

I was able to replace SSIS with a zero cost Talend open studio deployment with shell scripting and CRON scheduling.

Talend as an ETL tool is robust and flexible because of the transparency of the behind the scene Java code. Developers can debug and optimize the code easily because of visibility. The big data component of talend makes it the IDE for working with file formats like JSON and log files.

Talend gives the ability to pull data using WSDL/API and also to make data available as REST API. Talend jobs are platform independent and can be deployed easily. IDE is eclipse based.

Talend Data Integration Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools

Evaluating Talend Integration Suite and Competitors

  • Price
  • Product Features
  • Product Usability
  • Prior Experience with the Product
In my previous company, I used Talend open studio to replace SSIS with a zero cost ETL tool to build our EDW. Since we worked with the open studio community edition, we got a lot of opportunities to look under the hood to make custom changes and to implement and automate a few features. In the process, we explored the full product in and out and came to know the pros and cons of the product. That helped me to make a decision in my next assignment to go for Talend. It overall helped me to design and develop ETL jobs with quick turn around time - this time with the licensed Talend Big data integration tool.
I think I would simply go with Talend. Over a period of time, it has grown up as an enterprise product with the open source blend. The new big data solutions connectors are easily available or customized in talend. The parallel execution multi-threaded execution option helps with running jobs in parallel.
Talend Joblets support speedy development of jobs using templates. The documentation option dumps the entire job as HTML for technical review and readability.

Talend Integration Suite Support

Good support, specially when it relates to PROD environment. The support team has access to the product development team. Things are internally escalated to development team if there is a bug encountered. This helps the customer to get quick fix or patch designed for problem exceptions. I have also seen support showing their willingness to help develop custom connector for a newly available cloud based big data solution
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
Yes - for a large scale deployment (700+ jobs). Support is usually helpful when you are doing a POC for new development projects and want to find out the compatibility of tools. It also covers upgrades to scale your environment periodically. Access to knowledge and forums also helps new developers speed up the job building process.


More Reviews of Talend Data Integration