Matillion

Matillion

Top Rated
TRUE
About TrustRadius ScoringScore 8.2 out of 100
Top Rated
TRUE
Matillion

Overview

Recent Reviews

Matillion Review

9 out of 10
July 09, 2021
I have been using Matillion since March and it has been a nice experience. It's helping a lot during our ETL process from RDS to Redshift, …
Continue reading
Verified User
Employee

Easy to implement and scale

8 out of 10
June 29, 2021
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across …
Continue reading
Verified User
Consultant

Good at what it does.

9 out of 10
November 27, 2020
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and …
Continue reading
Verified User
Professional
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 12 features
  • Connect to traditional data sources (91)
    9.0
    90%
  • Testing and debugging (82)
    8.9
    89%
  • Simple transformations (92)
    8.7
    87%
  • Complex transformations (91)
    7.4
    74%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Matillion, and make your voice heard!

Record a review

Pricing

View all pricing
Matillion

Matillion

N/A
Unavailable

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

7 people want pricing too

Alternatives Pricing

Fivetran

Fivetran

$1
per credit
What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

Boomi

Boomi

$550
per month
What is Boomi?

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code interface with the capacity for API and EDI connections for integrating with external organizations and systems, as well as compliance with data protection regulations.

Product Demos

Introducing Matillion ETL for Amazon Redshift | Available on AWS Marketplace
Introducing Matillion ETL for Amazon Redshift | Available on AWS Marketplace
01:15
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
00:53
Introducing Matillion ETL for BigQuery | Available on GCP Marketplace
Introducing Matillion ETL for BigQuery | Available on GCP Marketplace
00:53
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
04:30
Thrive Market - "Able to Deliver Better Value and Service" | Matillion ETL for Amazon Redshift
Thrive Market - "Able to Deliver Better Value and Service" | Matillion ETL for Amazon Redshift
04:34

Features Scorecard

Data Source Connection

8.6
86%

Data Transformations

8.1
81%

Data Modeling

8.8
88%

Data Governance

8.2
82%

Product Details

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.

Users can 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 ETL workflows with scheduling, notifications and alerting, and control flow.

Once jobs are built, run them with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components to give users extensibility and flexibility.

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

Enterprise customers gain 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 to help users get the most out of the platform. Their Product Feature pages on matillion.com provides more information.



Matillion Features

Data Source Connection Features

  • Supported: Connect to traditional data sources
  • Supported: Connecto to Big Data and NoSQL

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Business rules and workflow
  • Supported: Collaboration
  • Supported: Testing and debugging

Matillion Screenshots

Screenshot of Matillion uses an easy to follow GUI. Orchestrate your jobs quickly and simply with control data flow functionality, automating the ETL process.Screenshot of Bring your data together. Use Matillion to read and combine data across your target warehouse external storage, such as S3 or Blob. Then prepare your structured and semi-structured data to create clean data sets that can be used with your BI/reporting/visualization tool of choice.Screenshot of Develop confidence in your ETL jobs with self-validating components, sample and row counts. If a job does fail, use warehouse queue services with Matillion to get an alert to your email or Slack account.Screenshot of With hundreds of pre-built connectors out of the box, Matillion is well equipped to handle your most complex transformation needs. In case you need a bit more flexibility for unique use cases, use the SQL component to run custom scripts from within Matillion.

Matillion Videos

Matillion ETL for Amazon Redshift
Matillion ETL for Snowflake
Matillion ETL for BigQuery
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
Thrive Market Use Matillion ETL for Amazon Redshift to Revolutionize Their Data Warehousing Strategy

Matillion Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Talend Data Integration, Informatica Intelligent Cloud Integration Services, and Fivetran are common alternatives for Matillion.

Reviewers rate Connect to traditional data sources and Data model creation and Metadata management highest, with a score of 9.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.

Comparisons

View all alternatives

Reviews and Ratings

 (157)

Ratings

Reviews

(1-25 of 93)
Popular Filters
Companies can't remove reviews or game the system. Here's why
April 18, 2022

Build your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needs

Jay Archer | TrustRadius Reviewer
Jay Archer
Manager of Data, Reporting, and Analytics
ReCharge Payments (Internet, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Review Source
Likelihood to Recommend
Great if you need a visual, customized, powerful data engineering and data integration platform that can do pretty much anything. I have yet to hit a situation that I can't solve one way or another. Not great if you only have time for a plug-and-play solution. This is not Stitch or FiveTran, but if you invest the time to learn and use Matillion you can end up with a vastly better solution to your data needs.
November 06, 2021

Most flexible and user-friendly ELT platform to support a modern data stack

Verified User
Engineer in Engineering
Restaurants Company, 501-1000 employees
Score 10 out of 10
Vetted Review
Verified User
Review Source
Likelihood to Recommend
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.
August 02, 2021

Data Integration and transformation platform

Austin Lee | TrustRadius Reviewer
Austin Lee
Data Scientist
Saggezza (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Review Source
Likelihood to Recommend
It is very well suited in data management and integration. It has saved our organization from data fraud and mismanagement of information from various sources. It has driven our company forward by delivering useful information that is suited to support our goals. Taking data from various sources and sorting it and uploading it in a cloud warehouse has enabled our departments to handle data properly.
July 09, 2021

Matillion Review

Verified User
Employee in Information Technology
Computer Software Company, 11-50 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Likelihood to Recommend
Matillion is nice if you don't want to spend time developing a home-built application to perform the ETL step and of course if you have a budget to spend on it. I don't suggest Matilion if you want to customize a lot or if you have a really specific environment to handle data.
July 08, 2021

Ease and complete tool, I would suggest it!

Verified User
Consultant in Information Technology
Information Technology & Services Company, 501-1000 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Likelihood to Recommend
It is useful when you need to create a Datawarehouse and put together a complex workflow. The development time is reduced compared to other ETLs. When you are more confident, you can also create complex flows using different job parameters and orchestrator jobs. Buttons for start and end success/end errors are also useful. Connection with source systems is also good.
July 02, 2021

Building a data warehouse from the ground up with Matillion

Verified User
Engineer in Other
Financial Services Company, 201-500 employees
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.

June 30, 2021

Visual ELT at its best

Verified User
C-Level Executive in Information Technology
Insurance Company, 51-200 employees
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.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
Lead Analyst
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Score 9 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).
January 05, 2021

ETL made easy for non-programmers

Verified User
Team Lead in Information Technology
Information Technology and Services Company, 501-1000 employees
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.
November 30, 2020

Ease of Use and Reusability for Excellent ROI

MB
Matthew Burr
Sr. Data Engineer
HireVue (Information Technology and Services, 201-500 employees)
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.
October 06, 2020

Beautiful UI and UX to compete with any ETL, but at a cost!

Adel Helal | TrustRadius Reviewer
Adel Helal
Tech Lead Engineer
Campaign Monitor (Marketing & Advertising, 201-500 employees)
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.
October 05, 2020

Easy to use and recommended for existing ETL developers

Verified User
Manager in Other
Online Media Company, 51-200 employees
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.
October 05, 2020

Simple and Powerful

Verified User
Team Lead in Engineering
Financial Services Company, 51-200 employees
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.
October 05, 2020

I'd bet my job on Matillion

DR
Dan Reiland
Director, IT Operations
Clario, Inc. (Computer Software, 11-50 employees)
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.
October 01, 2020

Matillion: flexible and complex

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employees
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.
October 01, 2020

Fell in love with Matillion in less than a week!

CM
Chandana M
Intelligence Analyst
RWWA (Gambling & Casinos, 201-500 employees)
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.
October 01, 2020

Great product that does what it says on the tin

Paul Cebulski | TrustRadius Reviewer
Paul Cebulski
Systems Administrator
Parkwood Holdings ltd (Leisure, Travel & Tourism, 5001-10,000 employees)
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.