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

Matillion

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
155 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 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.

Feature Set Ratings

  • Matillion ranks higher in 4 feature sets: Data Source Connection, Data Transformations, Data Modeling, Data Governance

Data Source Connection

8.0

Fivetran

80%
8.8

Matillion

88%
Matillion ranks higher in 2/2 features

Connect to traditional data sources

8.7
87%
7 Ratings
9.3
93%
90 Ratings

Connecto to Big Data and NoSQL

7.4
74%
5 Ratings
8.3
83%
56 Ratings

Data Transformations

8.0

Fivetran

80%
8.5

Matillion

85%
Matillion ranks higher in 2/2 features

Simple transformations

8.0
80%
6 Ratings
9.0
90%
91 Ratings

Complex transformations

8.0
80%
4 Ratings
8.0
80%
90 Ratings

Data Modeling

8.0

Fivetran

80%
9.0

Matillion

90%
Matillion ranks higher in 4/6 features

Data model creation

7.6
76%
6 Ratings
9.0
90%
34 Ratings

Metadata management

9.0
90%
4 Ratings
8.9
89%
41 Ratings

Business rules and workflow

6.3
63%
5 Ratings
9.3
93%
79 Ratings

Collaboration

8.3
83%
4 Ratings
9.3
93%
80 Ratings

Testing and debugging

7.9
79%
3 Ratings
9.2
92%
81 Ratings

feature 1

9.0
90%
1 Rating
8.2
82%
4 Ratings

Data Governance

7.5

Fivetran

75%
8.1

Matillion

81%
Matillion ranks higher in 2/2 features

Integration with data quality tools

7.1
71%
5 Ratings
8.1
81%
23 Ratings

Integration with MDM tools

8.0
80%
3 Ratings
8.1
81%
21 Ratings

Attribute Ratings

  • Fivetran is rated higher in 1 area: Usability
  • Matillion is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.7

Fivetran

87%
8 Ratings
8.9

Matillion

89%
92 Ratings

Likelihood to Renew

Fivetran

N/A
0 Ratings
5.4

Matillion

54%
6 Ratings

Usability

9.0

Fivetran

90%
1 Rating
8.6

Matillion

86%
91 Ratings

Performance

8.0

Fivetran

80%
2 Ratings

Matillion

N/A
0 Ratings

Support Rating

Fivetran

N/A
0 Ratings
7.5

Matillion

75%
10 Ratings

Implementation Rating

Fivetran

N/A
0 Ratings
8.2

Matillion

82%
2 Ratings

Product Scalability

Fivetran

N/A
0 Ratings
8.3

Matillion

83%
84 Ratings

Likelihood to Recommend

Fivetran

Mostly Fivetran can be useful for working with risk reduction operations during agile data analysis processes. I.e., in the short term the heaviest data movement operations would be safe. If you need to create an automated infrastructure for the data, the ability to create data list transformations in SQL is useful for keeping the work integrable or with schema changes. For situations that require a lot of speed: setting up the Fivetran platform is very easy, as you only need to authenticate the sources of the data to start working, and this is excellent for covering fast storage operations.
Murray Clear | TrustRadius Reviewer

Matillion

If your company has ever had issues with un-transparent data pipelines, difficulty understanding orchestration of workflows, and issues with data engineering retention and ramp-up, then Matillion is likely the right solution for you. It doesn't require heavy technical skills, just a strong understanding of Data-Eng Concepts. It's low-code/no-code optionality allows for everyone to come in and quickly understand how jobs are interconnected without having to cross navigate multiple systems for connectors, transformations, loads, and logging. It's an all-in-one solution that complements more specialized solutions like Fivetran and Hightouch. You can even set up python connections to orchestrate Fivetran and Hightouch into a Matillion workflow.
Anonymous | TrustRadius Reviewer

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
Anonymous | TrustRadius Reviewer

Matillion

  • Matillion's UI makes it easier to understand the flow of data in your data pipeline.
  • Custom Python scripts make it easier to manage and manipulate variables and also to create custom functions (e.g. we use one to post messages to Slack when jobs have failed/succeeded).
  • Handling failures in processes is straightforward.
Anonymous | TrustRadius Reviewer

Cons

Fivetran

  • More detailed logging
  • More flexible choices for time range over which records are synced
  • More options for masking and excluding sensitive data
Anonymous | TrustRadius Reviewer

Matillion

  • The Python script component needs a friendlier window in which to edit your scripts. The script is not searchable, and tabbing is frustrating.
  • The High Availability server configuration was not working for us. It was allowing duplicate jobs to run, and causing a lot of confusion in the scheduler. Love the idea, but the implementation fell short.
  • Better alerting around queued jobs would be nice. Sometimes jobs start queuing and nothing runs. Usually this is the result of a badly written job, but it would be nice to get alerts.
Hyrum Ward | TrustRadius Reviewer

Pricing Details

Fivetran

General

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

Starting Price

$1 per credit

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

Starting Price

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.

Likelihood to Renew

Fivetran

No score
No answers yet
No answers on this topic

Matillion

Matillion 5.4
Based on 6 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 8.6
Based on 91 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 10 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

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 places where Fivetran out-performed, other vendors.
Sudarshan Kothari | 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 8.3
Based on 84 answers
The product scales great for small to medium size teams or groups. For groups larger it becomes more challenging and requires more individual instances depending on the volume of running jobs and concurrent users - it handles 10's of concurrent users and jobs very well but much larger than that would be extremely difficult on the largest instance or cluster that is available at this time.
Patrick Hildreth | TrustRadius Reviewer

Return on Investment

Fivetran

  • Development cost have reduced for each connector
  • The pay-per-use model is still not out their which requires lot of overhead cost
Sudarshan Kothari | TrustRadius Reviewer

Matillion

  • Load data in Snowflake with minimal efforts. Loading data from REST API's require few hours instead of days. Effective manpower utilization
  • Upscale or downscale instance size on demand which makes it a cost-effective solution
  • No need to maintain and upgrade infrastructure which means no separate operational cost and downtime
Anonymous | TrustRadius Reviewer

Screenshots

Add comparison