Matillion Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
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

Do you work for this company? Learn how we help vendors

TrustRadius TRUE BadgeTrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 88)

Companies can't remove reviews or game the system. Here's why.
November 30, 2020
Matthew Burr | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is really well suited to environments using Redshift or Snowflake, and that rely on Amazon Web Services. It is also well suited to scenarios where you need to perform a lot of similar ETL tasks with small variations that could be parameterized. It's great if you want to get up-and-running quickly, and don't want to spend a ton of time in configuration and setup; you can get going very quickly out-of-the-box. It would be less appropriate in on-premise scenarios, where all of your data is stored on-premise. If you don't use AWS, you won't get as much value out of it. Also, in environments with large teams and lots of developers modifying jobs simultaneously, it can be a challenge to coordinate work and manage changes.
Read Matthew Burr's full review
November 24, 2020
Sudarshan Kothari | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion works best when automating the workflow from the various digital platforms. It provides the best use-case for automation of any dashboarding/reporting requirement where data is stored in one of the databases and updated regularly. Matillion might not be the best use-case for core ETL operation as it lacks stability for enterprise (but is improving to high standards with every update).
Read Sudarshan Kothari's full review
August 14, 2020
Britton Gray | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It's very well suited for data ingestion. Many connectors and loop components particularly make it easy to grab lots of data in a source system programmatically. Python scripts make it extensible. It's not as good for modern data warehouse ELT - you can use it as a "traffic cop" in those situations - but is it really work so much money per hour at that point?
Read Britton Gray's full review
August 13, 2020
Hyrum Ward | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is a one stop ETL shop. It is extremely flexible, and has been able to manage anything we've asked it to do so far. We love it for any API calls that we want to make. It is also very useful for transforming data that is already in our warehouse.

Matillion might not be appropriate for a very small startup that is relying on free software. Airflow is a better choice in that scenario.

For large datasets being pulled from third parties that have complex schemas, Matillion can be a lot of work. It is possible, but there are other tools that specialize in that. Fivetran is a tool we use in tandem with Matillion to great effect.
Read Hyrum Ward's full review
October 06, 2020
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Essentially Matillion is a nice tool to build a bunch of Redshift queries with added benefits of having a range of integration features. Considering the annual cost is almost equivalent to a junior engineer, we could spend the time to manually write the Redshift queries we need to transform and load our data that can run on our own microservices, and scale them as we see fit so we aren't faced with the hard limits of EC2 instance sizes. We also wont have to worry about hitting Java heap space limits since we can focus more on the Redshift query/transforms optimizing.
Read Adel Helal's full review
October 05, 2020
Dan Reiland | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is an excellent fit for organizations that have expertise (and data) in one of the supported engines (BigQuery, Redshift, and Snowflake). ELT workflows are easy to implement and automate against data of varied size. The UI successfully hides the complexity of SQL for users not well verse in it, but provides expert SQL users the ability to implement complex transformations not easily achieved with the standard components.
Read Dan Reiland's full review
October 01, 2020
Chandana M | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

I would 100% recommend Matillion for any business who is looking for an ETL solution for their cloud data warehouse especially Snowflake. What worked for us with Matillion is the ability to integrate our external sources (Elastic Search, Google Analytics), transform, automate and create a single data source for further data visualization.
Read Chandana M's full review
October 01, 2020
Paul Cebulski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It's perfect for pulling data from SQL server no matter of the amount of the data, recently we have pulled 14 millions of rows and transformed this data in the matter of minutes. Matillion is not great to pull large volumes of data from Google Sheets.
Read Paul Cebulski's full review
September 08, 2020
Viswanath Manne | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It would suggest Matillion for any medium level startup that is dealing with huge data and multiple sources of data, as it is easier to pull and push from/to multiple databases. Matillion might be a costly solution for early startups in my opinion, but if you are a huge data-based company, I would suggest you check out Matillion.
Read Viswanath Manne's full review
September 06, 2020
Dan Dow | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is really good at giving you a visual reference to look at data flows. The layout of orchestration and transformation jobs is intuitive enough that I have been able to show people who have never coded SQL in their lives how to use the product and they can understand how the data is moved and how it is transformed.

However, say you need to add a field to a top-level table that you have not written an extract for. Moving that new field across each transformation job for each intermediary fact or dim table can be very time-consuming and tedious and it seems it should not be that hard to add a feature--"populate through transformation as {field name}" should be possible.
Read Dan Dow's full review
September 03, 2020
Aleksa Topalović | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

If you are in a situation that includes Redshift, a whole AWS platform and developing modern analytical solutions, Matillion is the tool that could improve your whole platform. Instead of writing complex scripts you have possibilities to design the whole process that is also understandable for business users also at the first look - implementing business logic is faster. Using the power of the Redshift you have an impression of instantly doing a job. Matillion also covers some other use cases like processing and integrating unstructured data so that all business needs could be satisfied. At the end synchronization with other tools also works fine so the whole BI process from data to insights is shorter.
Read Aleksa Topalović's full review
August 31, 2020
Eduard Matei | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion can be designed to ingest a multitude of file types through an automatic process, allowing less technical users to create and control the end to end process of ETL.
API queries, python code, bash script processing, Matillion can be used to solve complex problems, creating an easy-to-follow process.
Read Eduard Matei's full review
August 29, 2020
Antonello Supino | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is great when you want to integrate the data into a single DWH such as Redshift or Snowflake.
Also the task history is very clear along with all the detailed reporting on each single operator.

When you want to export data back to MySQL or to other data sources it is quite difficult, that's an area of improvement.
Read Antonello Supino's full review
August 26, 2020
Andy Lai | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is suitable for a use case that needs to support multiple data sources or where you have much data to load into the data warehouse. It is not suitable for a budget-tied project, as it is quite costly if you just deploy it to use it as a data loader.
Read Andy Lai's full review
August 16, 2020
Daniel Zielinski | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is perfect for our organization since we are migrating to a more hybrid cloud-based architecture. I especially appreciate how changes to code are reflected immediately and can be seen by all developers instantaneously. This is of particular importance when employees are working remotely. The data that we ingest is processed twice a day, which is ideal for our organization. Any company that wants to invest in Matillion needs to determine and test the frequency of data ingestion.
Read Daniel Zielinski's full review
August 14, 2020
Avishua Stein | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is well suited for ingesting data from multiple sources, especially when the raw data is being stored in cloud storage. We have AWS Lambda connected to S3 and Matillion so triggering ingestion jobs when data is delivered is simple. Sending alerts for job failure or success to Slack/email is easy.

Matillion is probably less appropriate for scenarios where multiple people are going to be working on one job.
Read Avishua Stein's full review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

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.

Read this authenticated review
January 05, 2021
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

ETL development can happen without much programming using graphical ETL dev tools and Matillion makes it simple. If data movement is what your organization needs then Matillion is your tool. If you need heavy programming for most performant or reusability then Matillion is not very useful.
Read this authenticated review
October 05, 2020
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It is well suited for anyone needing to create a BI (ETL/ELT) solution on Redshift.
It is very easy to use and provides a lot of components similar to other ETL tools.
Please note all processing is pushed down to the DB (think ELT).
The only downside is some of the under the hood logic is sometimes not acting in the documented/desired fashion, requiring workarounds.
Read this authenticated review
October 05, 2020
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It's perfect for the teams who have very little experience with ETL and want to start creating pipelines with very little effort. It's also a very good solution if pipeline complexity is simple and does not require too much scalability.
Read this authenticated review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

  • Great if you have many developers working at the same time.
  • If you want to build a pipeline quickly and schedule it right away.
Read this authenticated review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Good for highly customizable jobs, takes some learning curve but then very flexible.

Less appropriate: the Zuora API has some issues and we had to build the data pull from a bunch of basic API components instead of the proper highlevel one.
Read this authenticated review
September 16, 2020
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is well suited for small teams that require fast and graphic development of dataflow jobs. Not so great with its support (it might take several days to get any response and that is not good when pipelines are business critical). When it comes to orchestration of big teams working with GIT, it can become a nightmare: single-lined big jsons not specifying what work was done.
Read this authenticated review
September 08, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Matillion is very well suited to connecting to online data sources, as it has an array of connectors that are already set up with third parties. It is easy to get started and can be hosted in AWS or Azure. You only get charged per hour so it is cost-effective if set up correctly.
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (86)
8.3
Connecto to Big Data and NoSQL (53)
7.5
Simple transformations (87)
8.7
Complex transformations (85)
7.6
Data model creation (34)
7.6
Metadata management (41)
6.6
Business rules and workflow (75)
7.4
Collaboration (75)
6.8
Testing and debugging (77)
6.2
feature 1 (4)
8.2
Integration with data quality tools (23)
6.6
Integration with MDM tools (21)
6.3

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.

Quickly develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate your ETL workflows with scheduling, notifications and alerting, and control flow.

Once your jobs are built, run them with confidence with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components giving you the ultimate extensibility and flexibility.

Shared Job templates, Dynamic and Grid variables, and Version control help your development teams share resources across your Matillion instance.

Enterprise customers benefit from additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.

Each product comes with a set of warehouse specific features that help you get the most out of the platform. See our Product Feature pages on matillion.com for more information.



Categories:  Data Integration

Matillion Features

Data Source Connection Features

Has featureConnect to traditional data sources
Has featureConnecto to Big Data and NoSQL

Data Transformations Features

Has featureSimple transformations
Has featureComplex transformations

Data Modeling Features

Has featureBusiness rules and workflow
Has featureCollaboration
Has featureTesting and debugging

Matillion Screenshots

Matillion Videos (6)

Matillion Integrations

Matillion Pricing

  • Has featureFree Trial Available?Yes
  • Does not have featureFree or Freemium Version Available?No
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?No

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

Matillion Support Options

 Free VersionPaid Version
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

Matillion Technical Details

Operating Systems: Unspecified
Mobile Application:No
Supported Countries:Global
Supported Languages: English