What users are saying about
11 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
144 Ratings
11 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Matillion

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
144 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Highlights

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.

Likelihood to Recommend

Fivetran

Fivetran works well when you have a lot of data in different places and want to get it all in one spot. I don't think it's as necessary if you have one cluster that needs to be replicated against and the data could wait a day. In this instance, there are other tools.
Scott Laronge | TrustRadius Reviewer

Matillion

Matillion is great for handling bulk and 'delta' loads to your warehouse, i.e. updating the warehouse with only those records updated since the last execution of the pipeline. The components and Python scripting provide a huge amount of flexibility in what the pipeline does, but you do need to have the expertise to know how to implement it properly.Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Fivetran
Matillion
7.9
Connect to traditional data sources
Fivetran
Matillion
8.3
Connecto to Big Data and NoSQL
Fivetran
Matillion
7.5

Data Transformations

Fivetran
Matillion
8.1
Simple transformations
Fivetran
Matillion
8.7
Complex transformations
Fivetran
Matillion
7.6

Data Modeling

Fivetran
Matillion
7.1
Data model creation
Fivetran
Matillion
7.6
Metadata management
Fivetran
Matillion
6.6
Business rules and workflow
Fivetran
Matillion
7.4
Collaboration
Fivetran
Matillion
6.8
Testing and debugging
Fivetran
Matillion
6.2
feature 1
Fivetran
Matillion
8.2

Data Governance

Fivetran
Matillion
6.5
Integration with data quality tools
Fivetran
Matillion
6.6
Integration with MDM tools
Fivetran
Matillion
6.3

Pros

Fivetran

  • Quick replication of data with minimal lag.
  • Automated reporting if data is out of date.
  • The customer support team is relatively good.
Scott Laronge | TrustRadius Reviewer

Matillion

  • The workspace is drag and drop, which makes it intuitive and easy to use.
  • Server creation and management is robust. We haven't had to worry too much about it once we got it created.
  • The job scheduler is very simple and intuitive.
  • Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
Hyrum Ward | TrustRadius Reviewer

Cons

Fivetran

  • A full schema refresh takes us two-three days and knocks us offline from monitoring up-to-date business KPIs, running updated analyses, etc. This is likely due to us having massive amounts of data (from a count(1) perspective, not size of tables perspective).
  • There's little to no progress estimate on the front end UI to see how long this refresh might take and you need to enable back end logging in Amazon to see where it's at in the sync process and derive rough estimates of completion time.
Scott Laronge | TrustRadius Reviewer

Matillion

  • Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
  • Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
  • Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
Patrick Hildreth | TrustRadius Reviewer

Likelihood to Renew

Fivetran

No score
No answers yet
No answers on this topic

Matillion

Matillion 7.4
Based on 4 answers
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.
Sudarshan Kothari | TrustRadius Reviewer

Usability

Fivetran

Fivetran 9.0
Based on 1 answer
Just need to input connection info.
Scott Laronge | TrustRadius Reviewer

Matillion

Matillion 7.8
Based on 87 answers
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
Britton Gray | TrustRadius Reviewer

Performance

Fivetran

Fivetran 8.0
Based on 2 answers
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.
Scott Laronge | TrustRadius Reviewer

Matillion

No score
No answers yet
No answers on this topic

Support Rating

Fivetran

No score
No answers yet
No answers on this topic

Matillion

Matillion 7.5
Based on 9 answers
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.
Matthew Burr | TrustRadius Reviewer

Implementation Rating

Fivetran

No score
No answers yet
No answers on this topic

Matillion

Matillion 8.2
Based on 2 answers
Not really a part of the implementation to give fare insight.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Fivetran

Honestly, we haven't done much investigation in a while, it just works 360 days of the year. The other five days there may be a hiccup that will throw us a day off of data, but it gets caught up in the end.
Scott Laronge | TrustRadius Reviewer

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 together Data pipelines (that required little to no coding), and a reasonable price point. Matillion is pretty unique in that it hits a balance of all three of those requirements.
Kris Shinn | TrustRadius Reviewer

Scalability

Fivetran

No score
No answers yet
No answers on this topic

Matillion

Matillion 6.6
Based on 79 answers
Instance size can be upgraded or downgraded with few clicks and hourly billing rate will change immediately. No need to restart Matillion instance. Matillion Enterprise edition has several benefits and will be activated automatically by configuring ">=m4." large instance size
Anonymous | TrustRadius Reviewer

Return on Investment

Fivetran

  • I don't think about ETL (Extract, Transform and Load).
  • I don't process any ETL, it's set it and forget it.
Scott Laronge | TrustRadius Reviewer

Matillion

  • I was able to build a complete commissions processing system for over 3500 employees using Matillion in just over a month. This included gathering data from 5 different sources, combining them together appropriately and building in the business rules. I was awarded one of the top awards our company gives for this project.
  • Our big three Business Intelligence tools: Matillion, Redshift and DOMO allow us to give our employees the right data at the right time. Our productivity has increased as 75%+ of our employees look at their data every day they work.
Gary Pope | TrustRadius Reviewer

Screenshots

Pricing Details

Fivetran

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Fivetran Editions & Modules

Edition
Starter$1.001
Standard$1.501
Enterprise$2.001
  1. per credit
Additional Pricing Details

Matillion

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Matillion Editions & Modules

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

Rating Summary

Likelihood to Recommend

Fivetran
7.0
Matillion
7.5

Likelihood to Renew

Fivetran
Matillion
7.4

Usability

Fivetran
9.0
Matillion
7.8

Performance

Fivetran
8.0
Matillion

Support Rating

Fivetran
Matillion
7.5

Implementation Rating

Fivetran
Matillion
8.2

Scalability

Fivetran
Matillion
6.6

Add comparison