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 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-25 of 92)- Popular Filters
Companies can't remove reviews or game the system. Here's why
June 09, 2022
Matillion review
- Positive impact on learning for freshers because of simple infra
- Easy to learn ETL tool
- Easily integrated with AWS
- Able to react to changing data quality issues caused upstream
- Ability to handle massive scaling issues with ease
- Ability to connect to more SaaS vendors as our business needs change
January 24, 2022
Matillion a great, easy to implement resource
- Reduced our nightly ETL pipeline time by 50%
- Saving us time reduces our need for headcount
- Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity
- Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why
- Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc.
August 02, 2021
Data Integration and transformation platform
- It quickly works and ensures ROI is achieved within a short period of time.
- It has positively impacted our business plans.
July 09, 2021
Matillion Review
- Became possible to build our DW
- We do not need to worry about the ETL software maintenance.
- It's easy to keep it updated.
July 08, 2021
Ease and complete tool, I would suggest it!
- Less effort in development.
- Low costs as it is possible the "pay for use."
- If you don't trigger Matillion, switch off cost are considered also if no job is running.
- Matillion has been essential in the successful implementation of a data warehouse in our organisation.
- It is unlocking client opportunities for us to provide a "warehouse as a service" as part of our company's offering.
July 01, 2021
Push the data with Matillion
- Data job done quickly.
- Bit of monitoring cost is involved.
June 30, 2021
Visual ELT at its best
- Essential in rolling out our data warehouse strategy.
June 29, 2021
Easy to implement and scale
- Allows for custom data refresh schedules
- Requires little maintenance or support from the team
- Affordable and scalable ETL solution
June 29, 2021
Matillion Review
- Our organization focuses on Data-Driven Digital Marketing Strategies, so not investing time and resources on getting the data, we ensured the time utilized much more in analyzing the data and for this purpose, Matillion was our solution and was right on a positive track.
- Matillion has been performing positive since it's consumption in our organization in terms of investment.
- With increasing functionality and stability in Matillion system, we could look for greater return than just replacements.
January 05, 2021
ETL made easy for non-programmers
- Allows quick development and deployment
November 30, 2020
Ease of Use and Reusability for Excellent ROI
- 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
November 27, 2020
Good at what it does.
- Made our ETL more reliable and easy to maintain compared to running scripts on EC2 and Cronjobs.
November 25, 2020
Excellent AWS Data Integration Platform
- License fees are expensive.
October 06, 2020
Beautiful UI and UX to compete with any ETL, but at a cost!
- Considering our specific use case is to provide analytics "for free" to our existing customers of all tiers, the added investment is hard to measure since this is an internal cost in order to keep up with our competitors. We are still trying to quantify customer retention directly related to the new analytics we provide because of what Matillion has helped us achieve.
October 05, 2020
Easy to use and recommended for existing ETL developers
- The pricing increased dramatically by 30% with short notice. This obviously hurt the OPEX.
October 05, 2020
Simple and Powerful
- Modifying code and deploying to production is very simple and takes very little time.
- Easy UI and simple flow creation enabled us to create pipelines in a very short time, rather than spending lot of man-power to get to the same level with other tools.
- In the long run, requirements and complexity grow a lot, it might not be the best solution. Perfect for small-medium sized companies.
October 05, 2020
I'd bet my job on Matillion
- Matillion allowed us to increase the productivity of our data engineering team by an order of magnitude.
- Matillion created a culture of standardization within our organization: the team uses a consistent approach to working with client data that is repeatable, testable, and easily automated.
- The ability to rapidly iterate, and receive meaningful feedback from the tools, allows our teams to experiment with new approaches to working with client data.
October 01, 2020
Get up and running with your data fast!
- Allowed us to migrate an existing data store to a new data warehouse without needing to hire an additional team.
October 01, 2020
Matillion ETL - excellent cloud based data tool
- Saved time in report production - from 2 weeks to automatic in minutes.
- increased quantity of reports available to the business.
- Allowed production of external MI to be automated.
October 01, 2020
Matillion: flexible and complex
- Allowed us to replace an ancient tool (pentaho) and move forward into the new era.
- Quick deployment and smooth upgrades make us look good to our customers.
October 01, 2020
Fell in love with Matillion in less than a week!
- ROI is quite significant in terms of manual effort that went in before purchasing Matillion.
- With Matillion automation, can answer multiple business questions to various stakeholders.
October 01, 2020
Great product that does what it says on the tin
- Increased our data visibility.
- Increased our data accessibility.
- Positively affected ops choices which directly lead to increased revenue.