Coming October 25: PeerSpot Awards will be announced! Learn more

AWS Glue vs Talend Open Studio comparison

Cancel
You must select at least 2 products to compare!
Amazon Logo
19,150 views|15,466 comparisons
Talend Logo
21,109 views|17,037 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on May 22, 2022

We performed a comparison between AWS Glue vs Talend Open Studio based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.

  • Ease of Deployment: Users report that the initial setup and deployment of both solutions is straightforward and easy.
  • Features: Reviewers of both products are happy with their stability and scalability. AWS Glue users like its user interface and say it is easy to implement ETL processes with, but they feel it is slow when starting up. Talend Open Studio reviewers say it is user-friendly and has excellent data integration but consumes a high amount of memory.
  • Pricing: Each of these products received mixed reviews in the pricing category. Some users of each feel that the price is too high.
  • ROI: AWS Glue users do not mention ROI. Talend Open Studio report seeing an ROI.
  • Service and Support: Users of both solutions report being satisfied with the level of support they receive.

Comparison Results: AWS Glue has a slight edge in this comparison since it is more lightweight than Talend Open Studio.

To learn more, read our detailed AWS Glue vs. Talend Open Studio report (Updated: August 2022).
632,779 professionals have used our research since 2012.
Q&A Highlights
Question: How does Talend Open Studio compare with AWS Glue?
Answer: 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.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution is stable and reliable.""AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software.""The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.""The key role for Glue is that it hosts our metadata before rolling out our actual data. This is the major advantage of using this solution and our clients client have been very satisfied with it.""Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs.""It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly.""Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you.""One of the best features of the solution is its ability to easily integrate with other AWS services."

More AWS Glue Pros →

"The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily.""The most valuable features are definitely data integration, data preparation, and data stewardship.""This product is very easy to use.""I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.""Open Studio's best features are that it's user-friendly, even for beginners, and very easy to implement.""The data integration aspect of the solution is excellent.""The best thing I have found with Talend Open Studio is their major support for the lookups.""We're able to handle large amounts of data with ease."

More Talend Open Studio Pros →

Cons
"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data.""The crucial problem with AWS Glue is that it only works with AWS. It is not an agnostic tool like Pentaho. In PowerCenter, we can install the forms from Google and other vendors, but in the case of AWS Glue, we can only use AWS.""The monitoring is not that good.""The interface for AWS Glue could improve, they do not put a lot of details. You can write the code, in PySpark or in Scala, which is a big advantage, it is only easy to use for a developer. It will be difficult for new users to enter the cloud environment.""It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options.""Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background.""Overall, I consider the technical support to be fine, although the response time could be faster in certain cases.""If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."

More AWS Glue Cons →

"The pricing could be lower. They should work to make it more affordable.""We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features.""The server-side should be completely revamped.""In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM.""Talent consumes a lot of resources on my PC.""Talend should improve the log and error handling to better track the errors you find during development. Sometimes it's challenging to see what's causing an issue, and tracking that on Talend is complicated.""The security features could be improved.""In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."

More Talend Open Studio Cons →

Pricing and Cost Advice
  • "It is not expensive. AWS Glue works on the serverless architecture. We get charged for the time the server is up. For our use case, we have to use it once in a day, and it is not expensive for us."
  • "Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."
  • "Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."
  • "This solution is affordable and there is an option to pay for the solution based on your usage."
  • "AWS Glue is quite costly, especially for small organizations."
  • "AWS Glue uses a pay-as-you-go approach which is helpful. The price of the overall solution is low and is a great advantage."
  • More AWS Glue Pricing and Cost Advice →

  • "There are many versions available and one is open-sourced which is free."
  • "The cost for one year for the ETL tools, not for the big data, is 6K per year. It is a good price."
  • "It does the job well for nothing — without cost. That's the advantage of this product."
  • "Talend Open Studio is priced too high."
  • "Open Studio has a basic license and additional costs for services, including customer support and technical assistance."
  • More Talend Open Studio Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    632,779 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: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… more »
    Top Answer:The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.
    Top Answer:It is user-friendly and the interface is good.
    Top Answer:The pricing is reasonable. I'd rate the pricing on offer a five out of five. they make it very affordable.
    Top Answer:Nothing comes to mind in terms of areas of improvement. Multiple products are there within the product suite. That can be actually trimmed down. Instead of having multiple products, what they can do… more »
    Ranking
    2nd
    Views
    19,150
    Comparisons
    15,466
    Reviews
    10
    Average Words per Review
    472
    Rating
    8.1
    4th
    Views
    21,109
    Comparisons
    17,037
    Reviews
    14
    Average Words per Review
    522
    Rating
    7.8
    Comparisons
    Also Known As
    Open Studio
    Learn More
    Overview

    AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. You can create and run an ETL job with a few clicks in the AWS Management Console. You simply point AWS Glue to your data stored on AWS, and AWS Glue discovers your data and stores the associated metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once cataloged, your data is immediately searchable, queryable, and available for ETL.

    Talend Open Studio is a free, open source ETL tool for data integration and Big Data. The solution enables you to extract diverse datasets and normalize and transform them into a consistent format which can be loaded into a number of third-party databases and applications.

    Talend Open Studio Features

    Talend Open Studio has many valuable key features. Some of the most useful ones include:

    • Automatic identification of data types and potential errors
    • tMap module
    • Graphical conversion tools
    • Charts
    • Database SCD Tools
    • Business intelligence formats (Jasper, OLAP, SPSS, Splunk)
    • ETL and ELT support
    • Eclipse-based development tooling
    • Versioning
    • Large library of connectors
    • Data flow orchestration
    • File management without scripting
    • Data transformations

    Talend Open Studio Benefits

    There are several benefits to implementing Talend Open Studio. Some of the biggest advantages the solution offers include:

    • Reduces the time taken to develop the integration.
    • Provides a wide selection of source and target connectors.
    • Monitor and manage problematic deployments with ease.
    • Allows developers to have the lowest cost of ownership for any solution.
    • Improves collaboration between different teams who need access to data.
    • Automated data integration process synchronizes the data and eases real time and periodic reporting, which would be time-consuming if done manually.
    • Achieve better data quality because data matures and improves over time.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Talend Open Studio solution.

    Elio B., Data Integration Specialist/CTO at Asset messages, says, "The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."

    A Practice Head, Analytics at a tech services company mentions, “The data integration aspect of the solution is excellent. The product's data preparation features are very good. There's very useful data stewardship within the product. From a technical standpoint, the solution itself is pretty good. There are very good pre-built connectors in Talend, which is good for many clients or businesses, as, in most cases, companies are dealing with multiple data sources from multiple technologies. That is where a tool like Talend is extremely helpful.”

    Prerna T., Senior System Executive at a tech services company, comments, “The best thing I have found with Talend Open Studio is their major support for the lookups. With Salesforce, when we want to relate our child objects to their parent object, we need to create them via IDs. Then the upsert operation, which will allow you to relate a child object to the event, will have an external ID. That is the best thing which keeps it very sorted. I like that.”

    An Implementation Specialist, Individual Contributor at a computer software company, states, “I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields.” He also adds, “It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool.”

    PeerSpot user Badrakh V., Information System Architect at Astvision, explains, "The most valuable features are the ETL tools."

    Offer
    Learn more about AWS Glue
    Learn more about Talend Open Studio
    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Almerys, BF&M, Findus
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company18%
    Financial Services Firm13%
    Insurance Company8%
    Media Company8%
    REVIEWERS
    Computer Software Company30%
    Insurance Company20%
    Energy/Utilities Company10%
    Integrator10%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Comms Service Provider13%
    Financial Services Firm11%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business17%
    Midsize Enterprise25%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    REVIEWERS
    Small Business39%
    Midsize Enterprise28%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    AWS Glue vs. Talend Open Studio
    August 2022
    Find out what your peers are saying about AWS Glue vs. Talend Open Studio and other solutions. Updated: August 2022.
    632,779 professionals have used our research since 2012.

    AWS Glue is ranked 2nd in Cloud Data Integration with 10 reviews while Talend Open Studio is ranked 4th in Data Integration Tools with 15 reviews. AWS Glue is rated 8.2, while Talend Open Studio is rated 7.6. The top reviewer of AWS Glue writes "Easy to perform ETL on multiple data sources, and easy to use after you learn it". On the other hand, the top reviewer of Talend Open Studio writes "Popular open-source ETL tool in Singapore/ South East Asia; Connects to Big Data; Easy to spot errors with generated Java code". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, Informatica Cloud Data Integration, SSIS and IBM InfoSphere DataStage, whereas Talend Open Studio is most compared with SSIS, Azure Data Factory, Talend Data Fabric, IBM InfoSphere DataStage and Informatica PowerCenter. See our AWS Glue vs. Talend Open Studio report.

    We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.