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.
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 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)
Reviews
(1-7 of 7)- Popular Filters
Companies can't remove reviews or game the system. Here's why
July 09, 2021
Matillion Review
I had some troubles with one specific conversion between data types from SQL Server to RedShift and their documentation didn't mention how to perform that so, I contacted them in order to get instructions, it was not exceptional support but once they replied to me they could give me a satisfactory instruction about how should I proceed.
June 29, 2021
Matillion Review
There are a couple of times when Matillion support team provided its extraordinary brilliance.
I would like to point out an instance when we were trying to implement tracking & monitoring in place for scheduled jobs and Kalyan (from the Support team) helped us to implement tracking which is still very helpful for our team without manually going to individual job to check the success.
Team provided the idea of "Task History Export" and another instance of using automated variable "Matillion ID" for tracking needs.
I would like to point out an instance when we were trying to implement tracking & monitoring in place for scheduled jobs and Kalyan (from the Support team) helped us to implement tracking which is still very helpful for our team without manually going to individual job to check the success.
Team provided the idea of "Task History Export" and another instance of using automated variable "Matillion ID" for tracking needs.
November 30, 2020
Ease of Use and Reusability for Excellent ROI
At one point, we were evaluating a decision to move to the next tier of Matillion. This would have doubled our costs, but would also have given us access to more computing resources.
I can imagine that many vendors would have seen this as an upsell opportunity and done all in their power to make a case for upgrading. When I spoke with Matillion, though, they carefully went through our usage with us before making any recommendation. After we looked through our use cases and usage with them, they recommended we stay at the current tier. It was clear that we wouldn't get enough benefit from an upgrade to warrant the cost.
I appreciate that Matillion valued our business and the benefits we get from their product more than making a quick buck.
I can imagine that many vendors would have seen this as an upsell opportunity and done all in their power to make a case for upgrading. When I spoke with Matillion, though, they carefully went through our usage with us before making any recommendation. After we looked through our use cases and usage with them, they recommended we stay at the current tier. It was clear that we wouldn't get enough benefit from an upgrade to warrant the cost.
I appreciate that Matillion valued our business and the benefits we get from their product more than making a quick buck.
November 27, 2020
Good at what it does.
Matillion helped us setup our instance into our private VPC for security reasons. Their help was prompt and they guided us through what could have been a complicated and tedious process. Thanks to their support, our instance is now more secure against any possible security breaches. This level of technical support is excellent.
November 25, 2020
Excellent AWS Data Integration Platform
Matillion support team provided support for resolving ETL task caused out of memory issue.
September 03, 2020
Matillion: the last puzzle piece in modern analytical solutions
Multiple times! Not needed to elaborate in detail but at the beginning when support was really needed, Matillion provided it.
August 21, 2020
First class data processing made easy to everyone
one time debugging a script that turn out to be a weird behaviour with some certain character. The person in charge of solving it cared to schedule meetings, do a follow-up until it was fixed. Really had our backs.