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
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 & consVideo 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 pricingEntry-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?
Alternatives Pricing
Product Demos





Features Scorecard
Data Source Connection
Data Transformations
Data Modeling
Data Governance
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 Integrations
Matillion Competitors
Matillion Technical Details
Deployment Types | SaaS |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Supported Countries | Global |
Supported Languages | English |
Frequently Asked Questions
Comparisons
View all alternativesCompare with
Reviews and Ratings
Reviews
(1-25 of 76)- Popular Filters
Matillion review
Matillion a great, easy to implement resource
Data Integration and transformation platform
Ease and complete tool, I would suggest it!
Other tools that did have equivalent flexibility/functionality were a lot more expensive than Matillion.
Visual ELT at its best
Easy to implement and scale
Matillion Review
ETL made easy for non-programmers
Ease of Use and Reusability for Excellent ROI
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.
Good at what it does.
- Amazon Elastic Compute Cloud (EC2)
Excellent AWS Data Integration Platform
Beautiful UI and UX to compete with any ETL, but at a cost!
Simple and Powerful
I'd bet my job on Matillion
Get up and running with your data fast!
Matillion: flexible and complex
Great product that does what it says on the tin
Good stepping stone for data infrastructure
- SQL Server Integration Services, Stitch and a Talend company
My experience with Matillion over the past couple of years!!
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.