Coming October 25: PeerSpot Awards will be announced! Learn more
Sheetal Jeshwani - PeerSpot reviewer
Werkstudentin Dev / Qa at Otto-friedrich-universität Bamberg
  • 8
  • 96

In which scenarios, one should select commercial ETL tools rather than open-source ones?

Which functionalities offered by enterprise ETL tools are not supported by open-source ETL tools?

Also, is there any major difference if one moves from Talend Open Studio to Talend Enterprise?

Thank you.

PeerSpot user
8 Answers
MUZAFFERYONTEM - PeerSpot reviewer
Managing Partner at a tech services company with 1-10 employees
Real User
Top 20
21 June 21

There might be several scenarios or cases for this question. 

Surely, open-source versions usually provide either no or limited versions of scheduling, auditing, auto-recovery or clustering, etc. functionalities. 

If still is the same, Talend Open studio was not providing scheduling and auditing so that users usually used to write their own scheduling such as Visa, Windows scheduling, etc.

Partha-DWBI Analytics Expert - PeerSpot reviewer
Principal Co-founder at Enterprise BIDI Solutions
Top 5Leaderboard
24 August 22

Enterprise ETL tools provide graphical interfaces for designing and executing ETL pipelines. They all connect to most relational databases,non-relational data sources such as JSON and XML and event streaming sources such as Apache Kafka.

Enterprise ETL tools use powerful algorithms which can detect the schema of incoming data and replicate the same in the data warehouse without any manual intervention, unlike an open-source ETL  tool.

Enterprise ETL tools are GDPR, SOC II, and HIPAA compliant. 

IS Sr Reporting Specialist at Community Health Network of Connecticut, Inc.
Top 10
09 August 22

Hi Sheetal,

Aside from features available, like many people mentioned, you need to keep in mind that open-sourced solutions might have limited support and security. A question to keep in mind. The community helps, however, what to do when all fails and you have a tough issue on hand. 

Just food for thought...


Partha-DWBI Analytics Expert - PeerSpot reviewer
Principal Co-founder at Enterprise BIDI Solutions
Top 5Leaderboard
24 August 22

Talend Enterprise supports for more connectors for enterprises, productivity, collaboration, version control, monitoring, clustering, and support compared to Talend Open Studio.

Deepak Damodarr - PeerSpot reviewer
Data Office Lead at a comms service provider with 501-1,000 employees
Real User
Top 5
11 August 22

*Taken from Talend Community:

1. Central repository - and for source code, and for scheduled Jobs, contexts, metadata and etc. Notifications about Job results and problems
2. Generated Documentation - more powerful tools for documenting Your code
3. JobLets - very helpful for making a screen more clean and readable for complicated Jobs
4. Dynamic schema support (not ideal, but at least present)
5. Debug
6. Spark Batch Jobs support

Questions to ask:

Q. Would the free community edition meet all your technical & business requirements?

Q. Would you need SLA-based support from Talend when things go wrong with the tool?

Q. Would you need bugs/defects to be patched by Talend on priority?

Q. Would you need onboarding support from Talend for your team?

Q. Would you need use case accelerators from Talend?

Esteban Fabiani - PeerSpot reviewer
Project and Consultant Manager at EMFConsulting Inc
10 August 22

Sheetal, from my point of view I always prefer to work with tools not coming from or supported by open-source. 

There can be advantages, but you have to be very skilled, and ready to have any type of problem, to begin, during, or in the future. I'm not against open-source... it's only to keep that in mind, and of course, you will not have support and a bunch of things you receive when you buy a tool. I'm not familiar with or worked with Talend, but this rule, I think, is for every company. 

Learn what your peers think about Talend Open Studio. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,572 professionals have used our research since 2012.
Azhagarasan Annadorai - PeerSpot reviewer
Founder at Kaizentric Technologies
Real User
Top 5Leaderboard
10 August 22

In case of pentagon ETL, job scheduler is missing in open source free edition. You can manage job scheduling using windows or Linux schedulers. It will be an easy task to manage schedules in commercial version, if you have say more than 30 jobs. 

Banks and insurance firms are normally worried about security vulnerability in open source éditions. You can pass the security checks/ checklist if you have commercial versions.

Jairo Willian Pereira - PeerSpot reviewer
Information Security Manager at a financial services firm with 5,001-10,000 employees
Real User
Top 5Leaderboard
13 October 21

Essential and fundamentals ETLs features, I think, that are available over all types and products. Not only for differences and features but about "first/baby steps" and "next step when maturity grow".

Article in Portuguese, but I strongly recommended reading it (even if via Google Translator). Approach valid for any commercial product/platform and FOSS approaches:

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Nov 24, 2021
Which is better and why?
See 1 answer
24 November 21
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in the ETL console. This solution has a lot of useful features. For example, you can point AWS Glue to data in AWS, and Glue stores the associated metadata in the data catalog. As a result, the data becomes searchable and available in the ETL. The UI is very friendly and easy to use. We also like how fast it is for ETL processes. If your company handles large quantities of sensitive data, AWS Glue provides a scheduler, and the data deployment is very straightforward. Still, AWS Glue leaves some room for improvement. The setup can be pretty tricky if you are not already an AWS user. Also, the sample code is not available for many use cases. Talend Open Studio is a data integration solution designed for ETL, Big Data, and data integration. It is also easy to use. The feature we like the most is that It allows us to integrate the different data sources. It has the added advantage of being open-source. It provides a lot of features out of the box, which is nice to have. The pre-built widgets help you streamline integrations with databases and web services. We use it for small loads, but for large amounts of data it stalls sometimes. Conclusions: If you are already an AWS user, AWS Glue is probably the best ETL tool for you. If that's not the case, deployment can be quite difficult. For small loads, Talend is a better option.
User at Technische Hochschule Georg Simon Ohm
Jun 09, 2021
Hi, I'm looking at Oracle Analytics Server and Oracle OBIEE and am trying to understand the difference between the two of them. I've heard that Oracle Analytics Server and Oracle Analytics Cloud have almost the same features. The difference is that Oracle Analytics Server is on-premise and Oracle Analytics Cloud is a cloud version. But, I also know that Oracle OBIEE is on-premise too. Peers, ...
See 2 answers
Dinesh Murugappan - PeerSpot reviewer
Technical Marketing Specialist at Guidanz Inc
08 June 21
Hey Husein, Oracle Analytics Server or OAS is an advanced enterprise analytics platform with self-service features and machine learning capabilities. Everything is used almost in with drag-and-drop actions. On the other hand, Oracle OBIEE is a traditional BI tool. In terms of features, it lacks a lot behind OAS. Further, it is not self-service friendly. Many companies using OBIEE are connecting Tableau or Power BI to OBIEE via BI Connector (which connects to OAC and OAS as well).Though OAS is far advanced than OBIEE, some features like flash templates, scorecard management etc, that are available in OBIEE are deprecated in OAS.Companies using OBIEE have the option to migrate to OAS at no additional cost, and experience its advanced features.
Manager - Metrics & Analytics at a computer software company with 1,001-5,000 employees
09 June 21
Oracle Analytics Server (OAS) is the latest Oracle release to supersede Oracle Business Intelligence Enterprise Edition (OBIEE). Current OBIEE customers can upgrade to OAS at no additional licensing cost. Whether you are on OBIEE 11g or 12c, upgrading to OAS has the following main advantages: Business users benefit from enhanced Data Visualization and Data Preparation features. Augmented analytics with machine learning capabilities become available to end-users. Analytics platform remains Oracle supported so you get the latest features and remain certified against updates to related Oracle and 3rd Party software. With OAS, it becomes more viable to deploy both OAS and OAC in a hybrid manner. The majority of OBIEE features, besides a few specific capabilities, continue to be available after the upgrade to OAS. Whether its data visualization projects, classic BI dashboards, or BI Publisher pixel-perfect report bursting, all these capabilities may be upgraded to OAS. The OAS topology is similar to that of OBIEE: OAS components are hosted on a WebLogic domain. This includes an Admin server and a managed server. Also, the system schemas (RCU) are deployed in a database. OAS basically covers all the features that already existed in OBIEE, except for the following, which are deprecated with OAS. These same features are also deprecated from Oracle Analytics Cloud (OAC): Mobile App Designer Scorecards Marketing Segmentation
Download Free Report
Download our free Talend Open Studio Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,572 professionals have used our research since 2012.