Zapier and AWS Glue are competitive in the automation and data integration category. AWS Glue has the upper hand for enterprises due to its robust enterprise-level features.
Features: Zapier offers extensive integration capabilities, allowing users to connect various applications easily. Its plug-and-play ability is beneficial for small to medium enterprises, and it provides valuable automation of workflows. AWS Glue is praised for scalability, integrating seamlessly with AWS products, and offering strong ETL processes. It also provides automatic schema detection and robust data management.
Room for Improvement: Zapier could improve Google Sheets integrations, support comprehensive logic, and offer better support channels. Users also request a wider range of integrations and more customization options. AWS Glue requires a more user-friendly interface, diverse programming language support, and better multi-cloud environment support. Users also find the setup process cumbersome and suggest operational cost reductions.
Ease of Deployment and Customer Service: Zapier is primarily used on public clouds, with high ratings for ease of deployment and customer service. AWS Glue is flexible across public, private, and hybrid clouds but has a learning curve and inconsistent technical support, which affects satisfaction levels. While Zapier users experience quick resolutions due to its simplicity, AWS Glue excels in technical integrations but could improve accessibility and support consistency.
Pricing and ROI: Zapier's tiered pricing includes a free plan for basic needs, scaling based on usage. Despite being pricey when scaling, it offers good value for small businesses. AWS Glue's pay-as-you-go model can be costly for small businesses but provides robust enterprise capabilities that justify the expense. Both solutions offer strong ROI, with Zapier appealing to cost-sensitive small businesses and AWS Glue to large enterprises seeking powerful features.
I advocate using Glue in such cases.
In a scenario where employing three resources for three months might cost approximately $18,000 to $20,000, Zapier provides substantial cost savings.
Upgrades occur every four months, and new developments coincide with version updates.
Sometimes, in my early days, when I was stuck with something, they helped me solve these issues, and even helped me solve some of my automations.
The experience was positive with prompt responses from their team.
It is beneficial to upgrade jobs, and we conduct extensive testing in development before migrating to production.
It can easily handle data from one terabyte to 100 terabytes or more, scaling nicely with larger datasets.
Scaling it gets quite expensive, and while I cannot evaluate it purely from a technology perspective, compared to Workato, I would give Zapier a seven for scalability.
AWS Glue is highly stable, and I would rate its stability as nine.
In my current company, we had significant challenges with Zapier regarding maintenance, as Zaps were often broken, not necessarily due to Zapier, but due to changes in the input variables.
Migrating jobs from version 3.0 to 4.0 can present compatibility issues.
With AWS, I gather data from multiple sources, clean it up, normalize it, de-duplicate it, and make it presentable.
A more user-friendly and simpler process would help speed up the deployment process.
You can build similar or dependent automations in one Zap, which helps with understanding the process without switching between different records.
I would appreciate if there would be a feature where we can use actions right after loops. Currently, you cannot use any other action after the loop. Everything needs to be within the loop.
Having flexibility in creating more complex automation would eliminate the need to transform data within the source or destination.
Costing depends on resource usage, and cost optimization may involve redesigning jobs for flexibility.
AWS charges based on runtime, which can be quite pricey.
The smallest cost for a project is around €700, while the largest can reach up to €7,000 based on the scale of the usage.
The pricing is in accordance with market standards and even lower in some cases.
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless.
AWS Glue's most valuable features include its transformation capabilities, which provide data quality and shape for processing in ML or AI models.
I think if I'm working with big data, common languages like Python work quite nicely, which is advantageous.
They have approximately 7,000 connections.
Even a person with no technical knowledge can use Zapier to create automations.
The automation capabilities are impressive.
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:
AWS Glue Benefits
AWS Glue offers a wide range of benefits for its users. These benefits include:
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.
Zapier is a tool for primarily non-technical users to connect together web apps.
An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.
Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.
Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.
Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.
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.
