What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings
15 Ratings

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
143 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100

Likelihood to Recommend

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

SAS/Access

SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
Nikardi Jallah | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Matillion
7.9
SAS/Access
9.7
Connect to traditional data sources
Matillion
8.3
SAS/Access
10.0
Connecto to Big Data and NoSQL
Matillion
7.6
SAS/Access
9.5

Data Transformations

Matillion
8.1
SAS/Access
8.5
Simple transformations
Matillion
8.6
SAS/Access
9.0
Complex transformations
Matillion
7.5
SAS/Access
8.0

Data Modeling

Matillion
7.2
SAS/Access
8.8
Data model creation
Matillion
7.6
SAS/Access
9.0
Metadata management
Matillion
6.6
SAS/Access
9.0
Business rules and workflow
Matillion
7.4
SAS/Access
9.0
Collaboration
Matillion
6.8
SAS/Access
9.0
Testing and debugging
Matillion
6.3
SAS/Access
8.0
feature 1
Matillion
8.2
SAS/Access

Data Governance

Matillion
6.5
SAS/Access
9.7
Integration with data quality tools
Matillion
6.6
SAS/Access
9.5
Integration with MDM tools
Matillion
6.3
SAS/Access
10.0

Pros

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

SAS/Access

  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases
Larry Burns | TrustRadius Reviewer

Cons

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

SAS/Access

  • Syntax for the connection string can be tricky
  • Specification of the data source driver can be tricky
Jim Metcalf | TrustRadius Reviewer

Likelihood to Renew

Matillion

Matillion 7.1
Based on 2 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

SAS/Access

No score
No answers yet
No answers on this topic

Usability

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

SAS/Access

No score
No answers yet
No answers on this topic

Support Rating

Matillion

Matillion 7.6
Based on 4 answers
For most of users support can provide needed help. And it is always in a really short time frame.In some really advanced cases there was necessary to include highly tech people and there was a lot of back and forth. Because I have a case that is not resolved for more than a year and the bug is based on initial bad implementation (Google AdManager component) I would suggest that sometimes don't rush to publish something that is not ready.
Aleksa Topalović | TrustRadius Reviewer

SAS/Access

SAS/Access 10.0
Based on 2 answers
I have always received excelled service working with SAS technical support. Additionally, the tool is used so widely that there are many online resources and use cases that allow you to see many other uses or support routes.
Larry Burns | TrustRadius Reviewer

Implementation Rating

Matillion

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

SAS/Access

No score
No answers yet
No answers on this topic

Alternatives Considered

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

SAS/Access

Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.
Anonymous | TrustRadius Reviewer

Scalability

Matillion

Matillion 6.7
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

SAS/Access

No score
No answers yet
No answers on this topic

Return on Investment

Matillion

  • Matillion has dramatically decreased the time it takes to create new ETL
  • Matillion has reduced the amount of time it takes to execute our daily ETL processing (by 50% or more)
  • Matillion has increased the number of people who can develop ETL by making ETL development easier
  • Matillion has increased the variety of data sources we can bring into our data warehouse
  • Matillion has made it a little harder to manage source control and deployment
Matthew Burr | TrustRadius Reviewer

SAS/Access

  • Bring usable data together quickly for downstream consumption e.g. modelling and reporting.
Horst Wolter | TrustRadius Reviewer

Screenshots

Pricing Details

Matillion

General

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

SAS/Access

General

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

Rating Summary

Likelihood to Recommend

Matillion
7.6
SAS/Access
10.0

Likelihood to Renew

Matillion
7.1
SAS/Access

Usability

Matillion
7.8
SAS/Access

Support Rating

Matillion
7.6
SAS/Access
10.0

Implementation Rating

Matillion
8.2
SAS/Access

Scalability

Matillion
6.7
SAS/Access

Add comparison