Matillion review
I have used Matillion in various projects in my company for different pharma clients for Life Sciences data. We were building solutions …
Matillion
Top Rated
TRUE
Matillion
Overview
Recent 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
Top Rated
2022
Popular Features
View all 12 features- Connect to traditional data sources (91)9.090%
- Testing and debugging (82)8.989%
- Simple transformations (92)8.787%
- Complex transformations (91)7.474%
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!
Pricing
View all pricingN/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
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…
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
01:15
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
00:53
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
04:30
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
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 Types | SaaS |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
| Supported Countries | Global |
| Supported Languages | English |
Frequently Asked Questions
Talend Data Integration, Informatica Intelligent Cloud Integration Services, and Fivetran are common alternatives for Matillion.
Reviewers rate Data model creation highest, with a score of 9.1.
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)
Reviews
(1-25 of 76)- Popular Filters
Companies can't remove reviews or game the system. Here's why
June 09, 2022
Matillion review
Ease of use and its features,easy integration with AWS
If you take the time to build your own with Matillion, you will end up with a vastly better solution than Stitch and Fivetran. We ran Stitch and Fivetran side by side connected from our source DB to both RedShift and Snowflake and documented the performance results as well as the multitude of data issues we had during the evaluation period. Those tools are great for plug-and-play if your data is simple and small. Our data and our source database are not simple, and huge and Stitch and Fivetran are just not great at handling variety. Now that Matillion is in place, the data loads that took Stitch seven days can be completed in under an hour. We have control over metadata and our DW data model, and can customize which columns from upstream we care about. The sky is the limit now that we have built out our solution. We are customizing, growing and expanding our capabilities every day and there is absolutely nothing standing in our way with Matillion. If we had chosen any other vendor tool (we evaluated many more that aren't listed by TrustRadius) we would be stuck. We would be hacking away at data in the DW instead of handling data in a well thought out manner as part of the pipeline.
January 24, 2022
Matillion a great, easy to implement resource
Matillion is much easier to implement and maintain. As a result, we use Matillion for 95% of our data pipelines and only use Apache Airflow when necessary.
August 02, 2021
Data Integration and transformation platform
Matillion has been the most successful product I have used in our company. It has the best features in data integration field and of all products it has performed exceptionally. It was our selection from the time go and everybody was interested in it. I have not come across such flexible and user friendly tool since we invested in this product.
July 08, 2021
Ease and complete tool, I would suggest it!
Matillion is cloud-native, therefore it doesn't need virtual machines to set up. It is easier to use compared with some of them. It always does query pushdown, while other ones don't'. It is integrated with Snowflake, while other ETLs need to use workarounds in order to perform the same steps.
Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta loads on the warehouse (i.e. updating only those records updated in the database since the last execution). Some other tools seemed to assume that you were accessing data from transactional databases where records were not updated, only ever created. This meant that we could not use them to deliver our Warehouse.
Other tools that did have equivalent flexibility/functionality were a lot more expensive than Matillion.
Other tools that did have equivalent flexibility/functionality were a lot more expensive than Matillion.
June 30, 2021
Visual ELT at its best
June 29, 2021
Easy to implement and scale
Matillion easily integrates with Snowflake which is a huge selling point. It is also affordable fro the amount of data source connections that it comes with.
June 29, 2021
Matillion Review
Matillion offers the unique capability of digital platform connectors (API connectors) and special functionality for Snowflake (which is our primary database). Also various sources including AWS S3, sFTP and various databases connection. In Pricing, the matillion option has economical than Informatica with our usage and Talend doesn't resonate well with flexibility, which we were looking for.
January 05, 2021
ETL made easy for non-programmers
Matillion is purely cloud solution versus Informatica Cloud still requires PowerCenter to do any serious transformation work.
November 30, 2020
Ease of Use and Reusability for Excellent ROI
SQL Server Integration Services (SSIS) is built around the Microsoft ecosystem; we needed something that was either "ecosystem-agnostic" or focused on AWS, which Matillion is. SSIS has very limited ability to parameterize jobs/packages compared to Matillion, reducing the reusability of jobs/packages.
Pentaho was too difficult to set up, and was also relatively limited in its parameterization, so that jobs weren't as reusable.
Ultimately, we select Matillion for its ease of use, its ability to create reusable jobs, its fit for our ecosystem, and its cost.
Pentaho was too difficult to set up, and was also relatively limited in its parameterization, so that jobs weren't as reusable.
Ultimately, we select Matillion for its ease of use, its ability to create reusable jobs, its fit for our ecosystem, and its cost.
November 27, 2020
Good at what it does.
- Amazon Elastic Compute Cloud (EC2)
Used EC2 boxes before, Matillion is an obvious upgrade.
November 25, 2020
Excellent AWS Data Integration Platform
Matillion is fully designed for AWS Cloud products, and aligned with AWS Redshift data integration perfectly.
October 06, 2020
Beautiful UI and UX to compete with any ETL, but at a cost!
It is much easier to use in terms of GUI capabilities. The only reason we would use an ETL tool other than our own manually written SQL scripts, is to be able to allow other engineers to use it without having one domain expert stuck on the inner working of complex scripts. So the GUI is essential for that, otherwise we wouldn't bother considering an off the shelf product.
October 05, 2020
Simple and Powerful
At that time, ~3 years ago, none of the competitors were as easy to start using as Matillion. As our team was not so experienced with ETL, Matillion was the best and easiest way to get our hands dirty with defining pipelines.
October 05, 2020
I'd bet my job on Matillion
We have direct experience with a number of ELT tools: SAS, Informatica, Pentaho, and others.
Matillion's ability to interface directly with Google BigQuery, the quality of its design, and the ability to be immediately productive made it the only product in the marketplace that we evaluated for this effort.
October 01, 2020
Get up and running with your data fast!
I have not used any other cloud-based ETL tools. Only on-premise solutions.
October 01, 2020
Matillion: flexible and complex
I didn't do the compare or eval, tool was chosen before I was hired.
October 01, 2020
Great product that does what it says on the tin
It's all in the Google ecosystem so integration with various offerings from Google is seamless. We can connect to various Google products with very little extra config.
September 17, 2020
Good stepping stone for data infrastructure
- SQL Server Integration Services, Stitch and a Talend company
It's browser-based and well suited for snowflake and redshift DWH. Matillion is Python-scripting friendly.
September 08, 2020
My experience with Matillion over the past couple of years!!
If you choose the Pentaho community edition, you need to take care of all deployment, server costs, etc.
I'm not sure how much an Enterprise Pentaho Edition costs though. In the case of Matillion, deployment is handled seamlessly, so it makes it ready to use. At the same time, you might feel there are good features missing in Matillion compared to Pentaho.
I'm not sure how much an Enterprise Pentaho Edition costs though. In the case of Matillion, deployment is handled seamlessly, so it makes it ready to use. At the same time, you might feel there are good features missing in Matillion compared to Pentaho.
September 03, 2020
Matillion: the last puzzle piece in modern analytical solutions
Before the ETL tool we made the decision to stick to Redshift as a database. Compared to listed products (that I used) I would say that the decision was easy if we consider the sync with AWS and Redshift, cloud-based solution, team collaboration, built-in scheduling, and monitoring.
September 01, 2020
Matillion - the swiss knife of ETL
More robust than Talend, easier to start working with and allows less technical users to understand how a file is being processed.
August 31, 2020
Matillion for ETL and Data Collection
I have used Microsoft SSIS in the past to collect, transform, and organize data. SSIS is harder to learn the details of. Additionally, it is harder to follow and understand. SSIS documentation is lacking and does not have relevant documentation in the product. You must google everything.
August 29, 2020
Robust ELT with Matillion for Redshift
Pentaho was used initially but the support was terrible. It was taking years to fix bugs and the scheduler was buggy, and it took an eternity to get the issue with the misfired job on the quartz Java scheduler to become made reliable. Informatica is a great tool that was considered, but Matillion was chosen as it is younger, cheaper and specific to Redshift. Jenkins is another tool we used. It is very reliable and free, but it was so difficult to create a simple and clear workflow to understand.