Fivetran vs. Matillion

Fivetran

Matillion

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Fivetran	Score 8.2 out of 10	N/A	Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using cloud-based software and storage, traditional ETL tools badly underperformed, and the complicated configurations they required often led to project failures. To streamline and accelerate…	$0.01
Matillion	Score 6.9 out of 10	N/A	Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions. The vendor states enterprises including Cisco,	$1,000 per month 500 prepaid credits (additional credits: $2.18/credit)

Pricing

Fivetran

Matillion

Editions & Modules

Starter: $0.01
per credit
Standard: $0.01
per credit
Enterprise: $0.01
per credit

Basic: $1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced: $2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise: Contact Sales

Offerings

Pricing Offerings
Fivetran	Matillion
Free Trial
Yes	Yes
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	Yes

Entry-level Setup Fee

Optional

No setup fee

Additional Details

—

Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.

More Pricing Information

Get More Info!

Community Pulse
	Fivetran	Matillion
Considered Both Products	Fivetran Verified User Professional Chose Fivetran Matillion requires a lot more initial setup effort and the resulting schemas are also much more "raw" data than the nicely cleaned schemas which Fivetran provides. Therefore it would also require more (manual) post-processing efforts compared to Fivetran. So the savings on time … Incentivized Helpful? Uddipan Mukherjee Big Data Specialist Chose Fivetran Fivetran is a powerful data replication tool that supported use cases for organization-wide data platforms. Incentivized Helpful? Sudarshan Kothari Senior Data Scientist Chose Fivetran Fivetran came well with the connectors' availability and updates with the source changes. We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization. These were 2 … Incentivized Helpful?	Matillion Verified User Employee Chose Matillion We evaluated Fivetran, TreasureData, StitchData and few other options. But only with Matillion did we have the option of a cloud-based ETL solution that we were able to host within the APAC-Sydney region to ensure our data stays within our region. Incentivized Helpful? Verified User Director Chose Matillion Matillion seemed more robust than Fivetran and was easier to use. Incentivized Helpful? Verified User Employee Chose Matillion Fivetran had better ease of use, but I chose Matillion because of pricing and flexibility. Incentivized Helpful? Clark Huang Chief Technology Officer Chose Matillion We evaluated Fivetran and Xplenty prior to choosing Matillion. Matillion was the only solution that easily satisfied our single-tenant to multi-tenant use cases. Incentivized Helpful? Verified User C-Level Executive Chose Matillion Prefer Matillion's visuals in terms of viewing jobs. We may end up using both Matillion and Fivetran Incentivized Helpful? Jay Archer Manager of Data, Reporting, and Analytics Chose Matillion If you take the time to build your own with Matillion, you will end up with a vastly better solution than Stitch and Fivetran. We ran Stitch and Fivetran side by side connected from our source DB to both RedShift and Snowflake and documented the performance results as well as … Incentivized Helpful? Matthew Belo Senior Architect Chose Matillion Matillion ran circles around Stitch and Striim both in functionality, setup, and performance. There was no real comparison. Fivetran massively outperforms Matillion in pretty much every facet of the production from setup, maintenance, visibility, and usability. It already … Incentivized Helpful? Verified User Manager Chose Matillion We decided to move forward with Matillion because it was the best tool among tools that support both ingesting data from a source system to a target database and running transformation workflows on it afterwards. Fivetran and Airbyte only support data ingestion and we had our … Incentivized Helpful? Verified User Director Chose Matillion Cost and ease of use were better for our purposes. Matillion distinguishes itself from Fivetran and SnapLogic through its user-friendly design, no-code interface, in-depth transformation capabilities, allowing for complex data manipulations directly within the platform, … Incentivized Helpful? Verified User Professional Chose Matillion Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum … Incentivized Helpful? Dan Zielinski Senior Database Architect Chose Matillion We selected Matillion primarily because of it's ability to connect to numerous data sources and easily create transformation jobs. While Fivetran does a better job managing and examining deltas, it is not easy to use and is very non user friendly. SSIS was not a good fit for … Helpful? Verified User Manager Chose Matillion Matillion is cheaper and we really like the customer support of Matillion as well as lerning materials provided by Matillion were far better. They also made connectors for us for free while others were charging us for it. Incentivized Helpful? Verified User Engineer Chose Matillion Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta … Incentivized Helpful? Verified User Engineer Chose Matillion Matillion is a good tool for integrating multiple clouds. Informatica has been a market standard for many years, it provides multiple capabilities for data governance, data quality, etc. However, Informatica is pretty expensive compared to Matillion. Also, Matillion is more … Incentivized Helpful? Sahil Bhange Sr Data Engineer Chose Matillion Matillion is easy to use and easy to teach to moderate tech knowledge team members Incentivized Helpful? Verified User Consultant Chose Matillion Matillion easily integrates with Snowflake which is a huge selling point. It is also affordable fro the amount of data source connections that it comes with. Incentivized Helpful? Sudarshan Kothari Lead Analyst Chose Matillion Matillion offers the unique capability of digital platform connectors (API connectors) and special functionality for Snowflake (which is our primary database). Also various sources including AWS S3, sFTP and various databases connection. In Pricing, the matillion option has … Incentivized Helpful? HW Hyrum Ward Manager of Data Engineering Chose Matillion We used Airflow for a year before switching to Matillion. We switched to Matillion because the Airflow servers were not stable, and we didn't have any in-house expertise that could manage the Linux OS which Airflow is built on. We were constantly frustrated by the fact that … Incentivized Helpful? Patrick Hildreth Lead Data Warehouse DBA Chose Matillion When we started there were not many options and the ones that were did not have the same level of functionality. Incentivized Helpful? Verified User Engineer Chose Matillion Matillion had out of the box support for most of the third party tools we have, plus it integrates well with our data warehouse platform. We found it to meet our use cases after a trial period. It's customizable when you know what you are doing. The use of global and local … Incentivized Helpful? Verified User Manager Chose Matillion We chose Matillion due to cost, compatibility with Redshift, and its ease to implement. Incentivized Helpful? KS Kris Shinn VP, Technology Chose Matillion There's a number of systems not available to enter in here that we also took a look at: AWS Data pipeline, Airflow, Xplenty, etc. The reason we chose Matillion is for the balance of features (ability to connect into cloud data sources like Jira), a simple interface to put … Incentivized Helpful? Verified User Analyst Chose Matillion Matillion is the best alternative for on-premise ETL tools if you are looking for a cloud-only solution. None of the tools we evaluated provide same features offered by Matillion. Extensive technical documentation is available on the website which makes development easy and … Incentivized Helpful? Caleb Dinsmore Software Engineer II Chose Matillion Our organization hires present college students in an apprenticeship role, so it was important to us that whatever tool we use to be easy to train on. We also preferred that it integrate well with Snowflake since we had decided that we wanted to use that as our data storage … Incentivized Helpful?
Top Pros	Pro Data replication Pro Data sources Pro Real time	Pro Easy to use Pro Data sources Pro Drag and drop
Top Cons	Minus User based Minus Use cases Minus Quite difficult	Minus Version control Minus Source control Minus Use cases

TrustRadius Insights
	Fivetran	Matillion
Highlights	Research Team Insight Published June 18, 2020 Fivetran and Matillion are both tools designed to extract and transform business data. Fivetran is a Data Replication tool that replicates business data from applications and databases and stores them in a single data warehouse, it is most popular with mid-sized businesses with many data sources to replicate. Matillion is a data integration tool that helps businesses to aggregate data from different sources for querying and analysis. Matillion is most popular with mid-sized businesses. Features Fivetran and Matillion both pull in data from many business sources, but they also have a few standout features that set them apart from each other. Fivetran can pull in data directly from many SaaS applications right out of the box, making it a strong choice for organizations looking for a plug and play tool to handle SaaS data. Additionally, Fivetran helps organizations meet regulatory compliance standards for both GDPR and HIPAA. Lastly, customers are able to add new data sources to Fivetran, making it easy to add customer data to a businesses data warehouse. Matillion provides a simple to use interface that won’t require significant training for new users. For businesses that do need a little more training, however, Matillion provides both thorough documentation as well as in depth tutorial videos so users can get up to speed quickly. Lastly, Matillion provides ticket based support so users can reach out to the vendor for help with any software issues. Limitations Fivetran and Matillion both help organizations to handle large amounts of business data, but they also have some limitations that are important to consider. Fivetran includes detailed documentation for their software, but provides no tutorials or training. New users will have to really on experienced coworkers or third party content when learning to use Fivetran. Additionally, Fivetran’s interface is more complex to use than Matillion, which can handle post load data transformations with a simple drag and drop interface. Matillion has built in integrations for some SaaS applications, but not as many as Fivetran. For businesses that only use applications supported by Matillion this isn’t an issue, but it can be a problem for businesses with other SaaS applications. Additionally, Matillion only provides support for GDPR compliance, so businesses that need their data to be HIPAA compliant may need to consider other options. Pricing Pricing for Fivetran is dependent on the needs of the business starting at $1.00 per credit with access to all Fivetran connectors. Fivetran also offers a free trial so businesses can see if the software is right for them before making a purchasing decision. Matillion similarly depends on the needs of the business, but it starts as low as $1.37 an hour and offers support for Amazon Redshift, Google BigQuery, Azure Synapse Analytics, and Snowflake.

Features

Fivetran

Matillion

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	Fivetran 10.0 8 Ratings 18% above category average	Matillion 7.7 132 Ratings 8% below category average
Connect to traditional data sources	10.08 Ratings	7.9131 Ratings
Connecto to Big Data and NoSQL	10.06 Ratings	7.491 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	Fivetran 6.3 7 Ratings 25% below category average	Matillion 6.6 133 Ratings 21% below category average
Simple transformations	6.67 Ratings	7.1133 Ratings
Complex transformations	6.15 Ratings	6.1132 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	Fivetran 6.1 8 Ratings 26% below category average	Matillion 7.4 125 Ratings 6% below category average
Data model creation	2.06 Ratings	9.133 Ratings
Metadata management	4.04 Ratings	9.140 Ratings
Business rules and workflow	8.06 Ratings	7.1117 Ratings
Collaboration	7.55 Ratings	5.2117 Ratings
Testing and debugging	9.04 Ratings	5.4118 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	Fivetran 9.0 7 Ratings 10% above category average	Matillion 8.2 23 Ratings 1% above category average
Integration with data quality tools	9.06 Ratings	8.222 Ratings
Integration with MDM tools	9.04 Ratings	8.220 Ratings

Best Alternatives
	Fivetran	Matillion
Small Businesses	Skyvia Score 10.0 out of 10	Skyvia Score 10.0 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Fivetran	Matillion
Likelihood to Recommend	8.5 (9 ratings)	6.4 (134 ratings)
Likelihood to Renew	- (0 ratings)	8.6 (6 ratings)
Usability	9.0 (2 ratings)	5.9 (133 ratings)
Performance	8.0 (1 ratings)	- (0 ratings)
Support Rating	- (0 ratings)	7.4 (7 ratings)
Implementation Rating	- (0 ratings)	8.2 (1 ratings)
Product Scalability	- (0 ratings)	5.8 (127 ratings)
Vendor post-sale	- (0 ratings)	9.1 (1 ratings)
Vendor pre-sale	- (0 ratings)	9.1 (1 ratings)

User Testimonials
	Fivetran	Matillion
Likelihood to Recommend	Fivetran Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider. Incentivized Sudarshan Kothari Senior Data Scientist Read full review	Matillion When my team receives a request to import data in from a new place, it's great to have a tool where you can set up those imports in minutes, yet have the capabilities to create customized and complex orchestration as time allows. Because it's easy to send SFTP exports, my internal customers are sometimes surprised that it's not as easy to perform other exports such as e-mailed files or API integrations. If Matillion had output components as varied and excellent as the import components, it would be the perfect solution for so many things we do. Incentivized Verified User Anonymous Read full review
Pros	Fivetran Easily connects to source data using delivered connectors Transforms data into standard models and schemas Has very good documentation to help quickly setup connectors Incentivized Verified User Anonymous Read full review	Matillion Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks. It provides the security capability as well. All the credentials can be securely stored in Matillion. Reusable templates can be built which reduces the redundancy. Time to production is very minimal. Incentivized Verified User Anonymous Read full review
Cons	Fivetran Very difficult to get connectors enhanced if a specific needed object is not supported by them Depending on the edition needed and the data volumes, can get quite expensive Incentivized Verified User Anonymous Read full review	Matillion Static and monolithic, it will show its limits when running multiple concurrent jobs. Github and versioning implementation is messy and broken. Don't use it. There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info. API implementation is cumbersome and limited. There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions). Handling of variables is limited especially for returned values from sub components. Some components could return more metadata at the end of their execution instead of the standard one. Billing is badly designed not taking into account that the server is hosted by the client. Expensive. We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side. CDC doesn't work as expected or it is not a mature product yet. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	Fivetran No answers on this topic	Matillion With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable. Incentivized Sudarshan Kothari Lead Analyst Read full review
Usability	Fivetran Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector. Incentivized Verified User Anonymous Read full review	Matillion We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch. Dan Zielinski Senior Database Architect Read full review
Performance	Fivetran It runs pretty well and gets our data from point A to point cluster quickly enough. Honestly, it's not something I think about unless it breaks and that's pretty rare. Incentivized Scott Laronge Head of Data Science Read full review	Matillion No answers on this topic
Support Rating	Fivetran No answers on this topic	Matillion Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming. Incentivized MB Matthew Burr Sr. Data Engineer Read full review
Implementation Rating	Fivetran No answers on this topic	Matillion We were able to control on access and built various enviroment for implementation Incentivized Sudarshan Kothari Lead Analyst Read full review
Alternatives Considered	Fivetran We never seriously considered using anything else. Our data engineers had used Fivetran extensively in previous roles so when it came time to make a decision, there wasn't much of a process. They gladly signed the contract with Fivetran pretty quickly. Incentivized Verified User Anonymous Read full review	Matillion Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach. Incentivized Verified User Anonymous Read full review
Scalability	Fivetran No answers on this topic	Matillion We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level. Incentivized Verified User Anonymous Read full review
Return on Investment	Fivetran It has been very positive in serving BI team with new source requests It has been OK at scaling to match as data volumes as source data size grows Incentivized Verified User Anonymous Read full review	Matillion Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI. The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest. Incentivized Verified User Anonymous Read full review
ScreenShots		Matillion Screenshots

Features

Limitations

Pricing