Talend OpenStudio building your EDW at $0 cost
Rating: 10 out of 10
October 06, 2016
Vetted Review
Verified User
4 years of experience
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.
Cons
- The Talend Administration Console TAC is a great place to schedule and monitor your jobs. Probably the interface can be improved.
100%
10.0
100%
10.0
100%
10.0
100%
10.0
- 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
- BusinessObjects Data Services, data stage and Informatica
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.
No
- 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 Joblets support speedy development of jobs using templates. The documentation option dumps the entire job as HTML for technical review and readability.
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.
No