Matillion ETL vs Zapier comparison

Read 41 Zapier reviews

750 Views
501 Comparison Views

95% willing to recommend

Matillion ETL

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 3, 2024

Zapier and Matillion ETL both compete in the automation and data integration sector. Zapier has an edge with its broad integration capabilities, while Matillion ETL stands out for its robust tools tailored for AWS services, streamlining large-scale data workflows.

Features: Zapier offers a wide range of integrations, allowing complex workflows without coding, and efficiently connects multiple applications. Users find it saves significant development time. Matillion ETL excels with built-in verification tools, seamless integration with AWS services, and an intuitive interface, making it ideal for large-scale data transformations.

Room for Improvement: Zapier could improve by enhancing error detection and expanding integrations to niche applications. Users also suggest better API connections and real-time bidirectional data sync. For Matillion ETL, more frequent updates in response to API changes, along with broader database integration and additional customization options, would increase flexibility.

Ease of Deployment and Customer Service: Both Zapier and Matillion ETL deploy effortlessly on public clouds. Zapier's setup is straightforward, though its technical support varies in responsiveness. Matillion ETL's deployment is praised for its AWS integration, with generally positive support facilitating a smoother onboarding process.

Pricing and ROI: Zapier's costs can rise with increased usage, but its pricing structure is straightforward, with entry-level plans accessible for startups. It provides significant ROI, especially for automating repetitive tasks. Matillion ETL employs a pay-as-you-go model based on runtime and instance size, considered moderately expensive but cost-effective for large data orchestration.

To learn more, read our detailed Matillion ETL vs. Zapier Report (Updated: January 2025).

Download the complete report

Matillion ETL vs. Zapier

January 2025

Helped 838,713 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Matillion ETL

Ranking in Cloud Data Integration

5th

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Zapier

Ranking in Cloud Data Integration

10th

Average Rating

8.6

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Cloud Data Integration category, the mindshare of Matillion ETL is 3.6%, down from 4.9% compared to the previous year. The mindshare of Zapier is 1.7%, down from 1.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Integration

Featured Reviews

Sunny Kumar

Specialist Programmer at Infosys

High efficiency, performs well, and price well

The decision to use Matillion ETL depends on the specific requirements. If the requirements can be met without Matillion ETL in a short amount of time, then using it would be unnecessary. However, if dealing with large data sets and frequent data migrations to and from the cloud, then Matillion ETL would be a suitable choice. I have a lot of experience in this field of data and I was able to achieve results with Matillion ETL that I was not able to with the traditional approach. The solution is helpful for large amounts of data. I rate Matillion ETL an eight out of ten.

Read full review

FrankHo

Analyst at MSXI

Though the tool offers a visually appealing UI, it needs to improve its documentation

With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation. The product has many bugs, so users have to wait for a period ranging from five minutes to an hour to see where the Zap went. In Zapier, Zaps aren't very understandable owing to the way they work. As a user, you would think that in Zapier, a Zap works in a particular way once you set it up, but it won't happen. At times, some Zaps can interfere with each other, because of which there might be infinite loops that may occur, owing to which multiple Zaps continue to run or break down in general, after which nothing would run in your environment. You would not be notified about the breakdown of Zaps. The bugs in the product may be considered to understand or get an explanation of how Zaps works between software systems, so for something between Gmail and HubSpot, Zapier would explain through better documentation what would work and what wouldn't work. Maybe if Zapier had better functionality with Python or any other coding language in general, it would make the product a lot better.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."

"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."

"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."

"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."

"Matillion ETL is one hundred percent stable."

"It has helped us to get onto the cloud quickly."

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"The solution's most valuable feature is the CDC (Change Data Capture) component."

More Matillion ETL pros

"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."

"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."

"Webhooks are the most valuable feature of Zapier."

"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana."

"The solution is a SaaS and does not require a complex setup."

"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."

"The product's initial setup phase was very easy."

"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."

More Zapier pros

Cons

"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."

"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

"It needs integration with more data sources."

"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."

"The tool's lineage is very weak."

"The cost of the solution is high and could be reduced."

"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."

"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."

More Matillion ETL cons

"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."

"It could support various languages along with Python."

"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."

"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."

"I think that this solution should have more apps connected to it."

"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"

"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."

"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."

More Zapier cons

Pricing and Cost Advice

"The AWS pricing and licensing are a cost-effective solution for data integration needs."

"It was very easy to purchase through the AWS Marketplace, but it was also expensive."

"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."

"The prices needs to be lower."

"The cost of the solution is high and could be reduced."

"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."

"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."

"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."

More Matillion ETL pricing and cost advice

"The least expensive plan is $24 a month, and you can go all the way to $800 a month if you're a huge company using many tasks."

"It's very affordable."

"It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."

"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."

"Zapier is a paid service. Its license renews monthly, and Zapier will downgrade your subscription to the free version when your credit card doesn't have funds. That significantly impacts your service because everything halts completely. Zapier doesn't have any hidden costs."

"Per task, there is a monthly plan involving 15 euros...Also, in different forms, they just give you the ability to use different features. They charge 18.58 euros for the first standard plan, which includes 750 tasks. So, it is about 25 cents per task."

"Think your Zaps through to make sure you don't use more Zaps than you need."

"The product is reasonably priced."

More Zapier pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

838,713 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

14%

Manufacturing Company

Healthcare Company

Computer Software Company

18%

Financial Services Firm

University

Educational Organization

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

What do you like most about Zapier?

The product's most valuable feature is automation.

What is your experience regarding pricing and costs for Zapier?

The pricing is suitable. It's not cheap, but not expensive.

What needs improvement with Zapier?

The pricing could be a little cheaper.

Azure Data Factory vs Matillion ETL

Comparisons

Compared 13% of the time

SSIS vs Matillion ETL

Compared 10% of the time

AWS Glue vs Matillion ETL

Compared 10% of the time

Snowflake vs Matillion ETL

Compared 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 6% of the time

More Matillion ETL Competitors

Coefficient vs Zapier

Compared 27% of the time

AWS Glue vs Zapier

Compared 17% of the time

Fivetran vs Zapier

Compared 14% of the time

MuleSoft Composer vs Zapier

Compared 14% of the time

Alteryx Designer vs Zapier

Compared 13% of the time

More Zapier Competitors

Product Reports

Download Matillion ETL product report

Matillion ETL

February 2025

Download Zapier product report

January 2025

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

No data available

Overview

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

Matillion

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.

Sample Customers

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

BuzzFeed, Groupon, Spotify, Columbia University, FOX