All ETL tool comparison

Fivetran vs. Matillion

Fivetran and Matillion are two competing ELT solutions. Compare data sources and destinations, features, pricing and more. Understand their differences and pros / cons.

Check the comparison spreadsheet

About the services

About Fivetran

Fivetran is a closed-source, managed ELT service that was created in 2012. As of September 2021, they have built 150 data connectors and have over 2,000 customers. They are considered a reliable choice and have a large customer base. Fivetran charges on monthly active rows (in other words, the number of rows that have been edited or added in a given month).

About Matillion

Matillion is a self-hosted ETL solution, created in 2011. It supports about 100 connectors and provides all extract, load and transform features. Matillion is used by 450 companies in 40 countries. Being self-hosted means that Matillion ensures your data doesn’t leave your infrastructure. You might have to pay for several Matillion instances if you’re multi-cloud. 



Data ingestion, ELT.

Data ingestion, data transformation, and business intelligence.


More than 150.

More than 100.


All major data warehouses, lakes and databases.

All major data warehouses, lakes and databases.

Customizability of connectors

Limited through Fivetran’s Cloud functions.


Database replication

Full table and incremental via change data capture.

Pricing is indexed on rows.

Full table and incremental via SELECT/replication key, timestamp or change data capture for AWS-hosted Matillion ETL instances.

Integration with data stack

Supports dbt transformations.


Support SLAs



Security certifications



Vendor lock-in

Annual contracts.

Annual contracts. Self-hosting implies a higher lock-in.

Purchase process

Requires conversations with sales.

Sales only.


Volume-based pricing with MARs (monthly active rows). Credits are not rolled over.

Based on the number of Virtual Core Hours used. 


Available through Powered by Fivetran.




Pre-built connectors are the primary way to differentiate ETL / ELT solutions, as they enable data teams to focus only on the insights to build.


Fivetran offers connectors for more than 150 data sources. It supports the major data warehouses and databases as destinations. However, Fivetran doesn’t support any data lakes.

Customers can pay extra and request that Fivetran build a new data source, but no one outside the Fivetran team can build new data sources or make improvements to existing sources. 

Fivetran’s customers often end up having to build and maintain custom connectors in-house with their own data engineering teams to address all their custom needs.


Matillion integrates with about 100 data sources. Customers can request Matillion to build a new data source, but no one outside the company can build new data sources or make improvements to existing sources. 

Matillion only supports Redshift, Snowflake, BigQuery, Azure Synapse Analytics and Delta Lake as destinations.



Fivetran is an ELT tool, and does not transform data prior to loading, either. It offers its own opinionated normalization out of the box, and recently added support for post-load transformations via copy-and-paste SQL and dbt.


Matillion offers post-load transformations through what it calls Transformation Components. Users can create Transformation Components via point-and-click selection or by writing them in SQL. 

Matillion does not support external transformation tools, such as dbt.


Every company has custom data architectures and, therefore, unique data integration needs. A lot of tools don’t enable teams to address those, which results in a lot of investment in building and maintaining additional in-house scripts. 


Fivetran released cloud functions to let their customers edit connectors by writing small function to fetch data using Go, Java, Node.js, Python, C# or F#. Customers will need to host their functions on a serverless platform.


Matillion doesn’t provide any customizability, unfortunately. 

Support & docs

Data integration tools can be complex, so customers need to have great support channels. This includes online documentation as well as tutorials, email and chat support. More complicated tools may also offer training services.


Fivetran provides support through an in-app form, but does not offer chat support.

Their documentation is comprehensive, but Fivetran doesn’t offer a Slack or Discourse community. 

Fivetran does not provide any training services.


Matillion provides support through an online ticketing system accessible through a support portal or via email. 

Documentation relies on articles accessible through the support portal. 

Matillion does not have any Slack or Discourse community to provide help. 

The company doesn't provide training services, but tutorial videos can be found on YouTube.



Fivetran provides a 14-day free trial. It discloses a pricing based on monthly active rows, i.e., rows that are added or edited in a given month. 

Fivetran’s volume-based pricing doesn’t adapt well with database replication use cases that involve the replication of millions of rows. 


Matillion offers a 14-day free trial. Its pricing depends on the cloud platform on which the customer's data warehouse runs. 

The pricing model is based on Virtual Core Hours, which will depend on the instance size customers run. Annual billing plans are available with discounts.

Want to know the benchmark of data pipeline performance & cost?

Discover the keys to enhancing data pipeline performance while minimizing costs with this benchmark analysis by McKnight Consulting Group.

Get now

Compare Airbyte's pricing to other ELT tools

1 minute cost estimator

Don't trust our word, trust theirs!

"Airbyte is a very promising solution for the single point of data integration. We continuously migrate our connectors from our existing solution to Airbyte as they became available on Airbyte, and look forward to the release of Airbyte Cloud!"
Apostol Tegko
Apostol Tegko
Data Analyst at Fnatic
"Airbyte has cut months of man hours off of our ELT pipeline development and delivered usable data to us in hours instead of weeks. We are excited for the future of Airbyte, enthusiastic about their approach, and optimistic about our future together."
Micah Mangione
Micah Mangione
Director of Technology at
“I was blown away by how easy it was to get started with Airbyte. We were able to adapt a Singer tap for a missing integration in 25 mins. Because Airbyte is so simple to use, I was able to avoid a planned data engineer hire.​”
Jins Kadwood
Jins Kadwood
CTO at AgriDigital

What Airbyte users say

“Airbyte saved us two months of engineering time by not having to build our own infrastructure. We can count on the stability and reliability of Airbyte connectors. Plus, with Airbyte it’s simple to build custom pipelines.”
“With Airbyte, we don’t need to worry about connectors and focus on creating value for our users instead of building infrastructure. That’s priceless. The time and energy saved allows us to disrupt and grow faster.”
"I used Airbyte's connector builder to write 2 connectors. The experience was amazing, the setup was straightforward, and in almost no time I was able to develop a new connector and get it running.”
“Using Airbyte makes extracting data from various sources super easy! I don't have to spend time maintaining difficult data pipelines. Instead, I can use that time to generate meaningful insights from data.”
"Airbyte does a lot of things really well. We just had to set it up, and it ran from there. Even moving 40GB worth of data works just fine without needing to worry about sizing up.”