AWS Glue vs Fivetran comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
11,729 views|8,292 comparisons
92% willing to recommend
Fivetran Logo
2,536 views|1,730 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between AWS Glue and Fivetran based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed AWS Glue vs. Fivetran Report (Updated: March 2024).
771,212 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like the fact that AWS Glue works with Python scripts.""It's fairly straightforward as a product; it's not very complicated.""I also like that you can add custom libraries like JAR files and use them. So, the ability to use a fast processing engine and embed basic jobs easily are significant advantages.""The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.""I appreciate AWS Glue for its cost-effectiveness.""Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs.""The solution helps organizations gain flexibility in defining the structure of the data.""The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team."

More AWS Glue Pros →

"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything.""The product has some seamless connectors, which are readily available.""Fivetran's most valuable feature is replication.""SysTrack load is the best feature.""The portal is very intuitive and easy to use.""You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when.""The product is very easy to use and very easy to configure.""The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."

More Fivetran Pros →

Cons
"There should be more connectors for different databases.""On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded.""The start-up time is really high right now. For instance, when you start up a new job, you have to wait for five or eight minutes before it starts. If the start-up time is reduced to one or two minutes, it will be great. It will be better to have a direct linkage to Redshift in AWS. If we can use data catalogs from Redshift, it will be so easy to create some data catalogs. Currently, we can only use data catalogs from S3.""The price of the solution could improve.""Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement.""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.""In terms of performance, if they can further optimize the execution time for serverless jobs, it would be a welcome improvement.""Overall, I consider the technical support to be fine, although the response time could be faster in certain cases."

More AWS Glue Cons →

"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services.""The solution is very expensive. I would like to have a better integration of the solution with Azure.""The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums.""The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly.""The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results.""Fivetran would be improved by adding the ability to integrate the data from third-party APIs.""I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded.""HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."

More Fivetran Cons →

Pricing and Cost Advice
  • "The pricing is a bit higher than other solutions like Athena and EC2. If the pricing becomes more scaled or flexible, it will be good because you have to pay 44 cents just for one DPU for an hour. If you increase DPUs to 5 or 10, the pricing gets multiplied. There are also some time limits like 0 to 10 minutes or 10 to 20 minutes. If the pricing is according to the minutes, it would be better because you have to limit your job to 10 minutes or 20 minutes."
  • "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."
  • "The overall cost of AWS Glue could be better. It cost approximately $1,000 a month. There is paid support available from AWS Glue."
  • More AWS Glue Pricing and Cost Advice →

  • "I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing. We're always open to doing things cheaper, so we might potentially implement a different solution."
  • "I've heard that the license for HVR is a bit costly compared to its competitors, but since it's reliable and efficient, I think the customer shouldn't be bothered about the cost."
  • "Fivetran is very expensive, and its database-driven pricing model is outdated."
  • "I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors."
  • "In the first year, we were given a very good discount. It was approximately 20,000 Euros per year. In the third year, we purchased credit for two years and the price was 33,000 Euros per year."
  • "I would say they're a little bit on the expensive side, and their contract process is not particularly good, but there is a lot of potential flexibility."
  • "The pricing model is okay and mid to large companies will not have an issue with it."
  • "The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high."
  • More Fivetran Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    771,212 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:AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or… more »
    Top Answer:As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector and by buying an already established data replication software, they become some… more »
    Top Answer: I honestly can't think of another data replication software that can give you better statistics and insight than HVR Software. There's the feature for topology and statistics and both of them can… more »
    Top Answer:As someone who works at a company where a high volume of information is replicated and has tried several data replication softwares, I can tell you that you're looking at the right one. HVR Software… more »
    Ranking
    1st
    Views
    11,729
    Comparisons
    8,292
    Reviews
    32
    Average Words per Review
    419
    Rating
    7.8
    6th
    Views
    2,536
    Comparisons
    1,730
    Reviews
    15
    Average Words per Review
    603
    Rating
    8.0
    Comparisons
    Learn More
    Overview

    AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.

    AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.

    The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.

    AWS Glue Features

    AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:

    • Automatic schema discovery: AWS Glue crawlers connect to the organization's source or target data source through a prioritized list of classifiers to determine the schema for users' data. This feature creates metadata in companies' AWS Glue Data Catalog.

    • Schemas for data stream management: The AWS Glue Schema Registry enables users to validate and control the evolution of streaming data through registered Apache Avro schemas for no additional charge.

    • Automatic scaling based on workload: This feature dynamically scales resources up and down based on workload. The feature controls job resources, removing them depending on how much the workload can be split up.

    • FindMatches: This feature is for machine learning-based data deduplication and cleansing, and works by finding records that are imperfect matches of each other to remove useless data copies.

    • Edit, debug, and test ETL code: This feature helps users who have chosen to interactively develop their ETL code by providing development endpoints for editing, debugging, and testing the code it generates for them.

    • AWS Glue DataBrew: An interactive, point-and-click visual interface for specialists to clean and normalize data without the need to write any code.

    • AWS Glue Interactive Sessions: This feature simplifies the development of data integration jobs by enabling data engineers to interactively prepare and explore data.

    • AWS Glue Studio Job Notebooks: This AWS Glue feature provides serverless notebooks with minimal setup, allowing developers to start working in a timely manner.

    • Complex ETL pipeline building: This feature allows the product to be invoked on a schedule, on demand, or based on an event, allowing users to start multiple jobs in parallel or specify dependencies to build complex ETL pipelines.

    • AWS Glue Studio: This AWS Glue feature allows users to visually transform data through a drag-and-drop interface. The product automatically generates the code for ETL processes for users' data.

    AWS Glue Benefits

    AWS Glue offers a wide range of benefits for its users. These benefits include:

    • Users of other AWS products can easily onboard with AWS Glue, as it is integrated across a wide range of the company's services.

    • The solution is serverless, which allows for a lower total cost of ownership.

    • AWS Glue offers more power for users, as it automates much of the effort in building, maintaining, and running ETL jobs.

    • The product allows customers to easily discover and search across all their AWS datasets through AWS Glue Data Catalog.

    • AWS Glue does not require additional payment for managing and enforcing schemas for data streams.

    • The solution facilitates the authority of scalable ETL jobs for beginners and non-coding experts through a drag-and-drop interface.

    Reviews from Real Users

    Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.

    Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.

    Fivetran is a data integration and migration solution that centralizes data from various sources into a data warehouse (such as Snowflake or BigQuery) for analytics. Its most valuable features include replication and managed pipelines, integration with DBT for data transformation, and many source connections. 

    Fivetran is easy to use, with fast data migration and an intuitive portal for easy setup and troubleshooting. It has helped organizations integrate and manage data, saving time and resources.

    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    DocuSign, Oldcastle Infrastructure, Crossmedia, Talkdesk, Chubbies, Brandwatch
    Top Industries
    REVIEWERS
    Computer Software Company47%
    Financial Services Firm18%
    Pharma/Biotech Company12%
    Consumer Goods Company6%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company14%
    Manufacturing Company7%
    Insurance Company7%
    REVIEWERS
    Manufacturing Company42%
    Outsourcing Company17%
    Transportation Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Educational Organization24%
    Computer Software Company11%
    Financial Services Firm11%
    Manufacturing Company9%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise13%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise73%
    REVIEWERS
    Small Business17%
    Midsize Enterprise25%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise30%
    Large Enterprise56%
    Buyer's Guide
    AWS Glue vs. Fivetran
    March 2024
    Find out what your peers are saying about AWS Glue vs. Fivetran and other solutions. Updated: March 2024.
    771,212 professionals have used our research since 2012.

    AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Fivetran is ranked 6th in Cloud Data Integration with 20 reviews. AWS Glue is rated 7.8, while Fivetran is rated 8.0. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Talend Open Studio, whereas Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Informatica PowerCenter. See our AWS Glue vs. Fivetran report.

    See our list of best Cloud Data Integration vendors.

    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.