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 featuresConnect 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!
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.1
81%
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 93)- Popular Filters
Companies can't remove reviews or game the system. Here's why
June 09, 2022
Matillion review
I have used Matillion in various projects in my company for different pharma clients for Life Sciences data. We were building solutions for clients which can help the analytic users and other down streams to consume data as per their requirements. In other Healthcare Analytics Projects, we were extracting the data from different sources like Facebook and Google Analytics and building a repository using Matillion ETL. Matillion was user-friendly and easy to learn and easily integrated with AWS Redshift and Snowflake DBs.
We are using Matillion to centralize our data to a new data warehouse. Our primary use case is pulling data from a relational database (MySQL). I've been able to implement three different flavors of data sourcing, the two primary types being a full table load and incremental data loading of changed data into Slowly Changing Dimension and Fact tables in the DW. The performance of Matillion combined with Snowflake is astoundingly fast. We are also able to hit APIs to Zendesk and Hubspot easily to round out our integration with other SaaS vendors in our stack.
January 24, 2022
Matillion a great, easy to implement resource
We use Matillion for all our redshift data warehouse ETL needs.
Matillion is helping resolve use-cases related to transparent orchestration workflows. These workflows often involve custom Python, SQL, staging locations, and sending data to external systems such as Salesforce and cross-channel marketing platforms all in one workflow. When FiveTran & DBT don't meet our exact requirements and use-case, we use Matillion to help resolve these use-cases in an easily understandable workflow that technical users, new engineers, or non-technical users can understand/troubleshoot.
August 02, 2021
Data Integration and transformation platform
Matillion is being used to transform and integrate data in our organization. Most of the data that we highly rely in decision making and planning is well analyzed by this great product. Data is safe for use in our departments can easily be saved in the cloud for free for future use.
July 09, 2021
Matillion Review
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, both on AWS. I really appreciate the software features and their support team is always able to clarify doubts and lead us to the best solution for our business.
July 08, 2021
Ease and complete tool, I would suggest it!
We have been using Matillion for a specific project in the SupplyChain area. The ETL works well and it was really easy to implement. We didn't use many objects, but we still were able to implement everything we needed, such us datamarts and file exports. We also tested the connection with SAP and we were happy to see it worked correctly. Something I think could be useful is a tool to move jobs between different environments: export/import upload. Json is ok but doesn't allow us to manage to version, and moreover, if you are moving many files, you need to manually substitute the original job with the new one.
Matillion is being used by the BI Team to orchestrate the population of the Data Warehouse. The Warehouse, in turn, is used to produce a range of reports across all business functions in the organisation. We use Matillion to ingest data from an application database (hosted in AWS), Salesforce, Netsuite and Google Analytics
July 01, 2021
Push the data with Matillion
We use it to get data from various sources into our data space. We use it within our company and also share it externally with our clients. It is very much useful.
June 30, 2021
Visual ELT at its best
Used by developers and business analysts in the IT department to extract and transform data into our Snowflake data warehouse. We have different data sources after a company merger and needed combined reporting. We also needed to pull data from third-party data sources such as Xero, Google Analytics, and so on.
June 29, 2021
Easy to implement and scale
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across the whole organization. We use Matillion to automate the ingestion and transformation of data pipelines. We utilize Snowflake as a data warehouse, so we use Matillion as the tool to load data into the Snowflake database.
June 29, 2021
Matillion Review
iQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.
January 05, 2021
ETL made easy for non-programmers
We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.
November 30, 2020
Ease of Use and Reusability for Excellent ROI
We use Matillion to bring together data from multiple sources - our application, Salesforce, Qualtrics, etc. - into a central data warehouse for use throughout the business in reporting, both internally and externally. Matillion performs the ETL that transforms this raw data into a structure in Redshift useful for reporting.
November 27, 2020
Good at what it does.
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and external reports.
November 25, 2020
Excellent AWS Data Integration Platform
Matillion is used by the software department for data integration, for syncing up data from the OLTP database to the OLAP system, and populating data for our data warehouse.
October 06, 2020
Beautiful UI and UX to compete with any ETL, but at a cost!
We still have an old-fashioned process in our monolith environment to extract-transform-load from a SQL server data store. Currently the monolith is the main product of the CM brand and is still being heavily maintained. The way we are moving forward is to "unlock" the data from its current storage in order to have better analytics using event streaming. For the time being, the only way we are able to extract large amounts of data from our relational SQL data store is using the ETL process through Matillion into our data warehouse solution in Redshift.
October 05, 2020
Easy to use and recommended for existing ETL developers
Matillion was used in order to create a Redshift Data warehouse solution. Where the Data warehouse followed the Inmon module and on top of that is a Data mart with multiple aggregations.
It was the product of choice for BI needing to move from an old ETL tool and DB.
October 05, 2020
Simple and Powerful
Matillion is being used only by data engineering team, which is part of Data Science department. It's our ETL tool to populate our data warehouse on Snowflake. Orchestration jobs are running on a daily basis and are basis of BI reports, which are used across the whole organization. Except that, it's used to generate new feature sets for data scientist for modelling.
October 05, 2020
I'd bet my job on Matillion
Matillion is primarily used by our Data Engineering team to produce highly curated datasets for use by our clients. We transform extensive volumes of client and vendor data into a highly clean and valuable artifact. Matillion is our primary ELT tool and has displaced a number of other tools previously used by our organization.
October 01, 2020
Get up and running with your data fast!
Matillion is being used primarily by the Analytics team, which is part of engineering, to orchestrate data transformation jobs from our application databases to our data warehouse.
October 01, 2020
Matillion ETL - excellent cloud based data tool
Matillion is our ETL tool to populate our data warehouse running in Google BigQuery. In conjunction with Google Data Studio, we have a daily process used across the whole business with up to date financial, commercial and project data. It is managed by the Technology Team but the whole business sees the results.
October 01, 2020
Matillion: flexible and complex
We use it as an ETL tool to process data from Redshift and other software, create tables in Redshift, and transform data as it goes.
October 01, 2020
Fell in love with Matillion in less than a week!
Matillion has been used to clean, integrate and transform data from multiple sources are prepare data for data visualisation to answer key business questions at our organisation. Our business problem was finding an ETL solution as we moved towards Cloud data warehouse. We right away knew Matillion is the best fit for us.
October 01, 2020
Great product that does what it says on the tin
We started using Matillion a couple years ago across all areas of our business. We use this tool to gather data from various data sources (SQL, Google Sheets, API calls, etc.), and transforming it and eventually outputting to our data warehouse for data visualisation.