Matillion

Matillion

Top Rated
TRUE
About TrustRadius ScoringScore 8.2 out of 100
Top Rated
TRUE
Matillion

Overview

Recent Reviews

Matillion Review

9 out of 10
July 09, 2021
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, …
Continue reading
Verified User
Employee

Easy to implement and scale

8 out of 10
June 29, 2021
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across …
Continue reading
Verified User
Consultant

Good at what it does.

9 out of 10
November 27, 2020
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and …
Continue reading
Verified User
Professional
Read all 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.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!

Record a review

Pricing

View all pricing
Matillion

Matillion

N/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

Fivetran

Fivetran

$1
per credit
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…

Boomi

Boomi

$550
per month
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
Introducing Matillion ETL for Amazon Redshift | Available on AWS Marketplace
01:15
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
Introducing Matillion ETL for Snowflake | Available on Azure, AWS and GCP Marketplaces
00:53
Introducing Matillion ETL for BigQuery | Available on GCP Marketplace
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
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
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

Screenshot of Matillion uses an easy to follow GUI. Orchestrate your jobs quickly and simply with control data flow functionality, automating the ETL process.Screenshot of Bring your data together. Use Matillion to read and combine data across your target warehouse external storage, such as S3 or Blob. Then prepare your structured and semi-structured data to create clean data sets that can be used with your BI/reporting/visualization tool of choice.Screenshot of Develop confidence in your ETL jobs with self-validating components, sample and row counts. If a job does fail, use warehouse queue services with Matillion to get an alert to your email or Slack account.Screenshot of With hundreds of pre-built connectors out of the box, Matillion is well equipped to handle your most complex transformation needs. In case you need a bit more flexibility for unique use cases, use the SQL component to run custom scripts from within Matillion.

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 TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

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)

Ratings

Reviews

(1-25 of 92)
Popular Filters
Companies can't remove reviews or game the system. Here's why
April 18, 2022

Build your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needs

Jay Archer | TrustRadius Reviewer
Jay Archer
Manager of Data, Reporting, and Analytics
ReCharge Payments (Internet, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Review Source
Usability
9
I would like to give it a 9.5 or so. Only a few aspects of the usability need some work. These are trivial things to fix, but really annoying to an experienced user.
November 06, 2021

Most flexible and user-friendly ELT platform to support a modern data stack

Verified User
Engineer in Engineering
Restaurants Company, 501-1000 employees
Score 10 out of 10
Vetted Review
Verified User
Review Source
Usability
10
I was able to get up and running with Matillion in 1-2 hours with a simple job my first time using it. It's pretty intuitive and straightforward. No YAML's, config files, local installations, reading of complex documentation, or understanding of unique open-source frameworks.
August 02, 2021

Data Integration and transformation platform

Austin Lee | TrustRadius Reviewer
Austin Lee
Data Scientist
Saggezza (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
10
It has given us excellent services and lead to the growth of our organization. Our organization departments usually get an opportunity to work on data that is secure and make informed decisions. In overall data, Matillion has been very effective in data management. Distribution of data across our organization and effective storage for referencing has contributed to excellent data handling.
July 09, 2021

Matillion Review

Verified User
Employee in Information Technology
Computer Software Company, 11-50 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
9
It's easy to understand how the flow works and all the features provided by the tool. You also can find some information on their website or Youtube channel.
July 08, 2021

Ease and complete tool, I would suggest it!

Verified User
Consultant in Information Technology
Information Technology & Services Company, 501-1000 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
8
It is good. Matillion is easy to use, the connection is web-based, fast, and always works. The "search" into each object simplifies the construction of transformations and joins. The SQL is always retrievable from jobs, therefore the debug phase is also easy to analyze. Moreover, in case of need, you can also write your own SQL into the appropriate object.
July 02, 2021

Building a data warehouse from the ground up with Matillion

Verified User
Engineer in Other
Financial Services Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
8
I find Matillion very intuitive and quickly got to grips with it. I have found that developers with a more purist coding background have struggled to get to grips with it more, particularly in relation to managing variables. For me personally, this has not been an issue and the online documentation has been excellent in digging deeper into specific functional areas
June 30, 2021

Visual ELT at its best

Verified User
C-Level Executive in Information Technology
Insurance Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
9
Works well for people that like to visualize things, as each job and transformation is displayed on a graphical interface. A job or transformation can be a large set of tasks or can be broken down into individual ones so that diagrams do not get too complicated and out of hand.
June 29, 2021

Easy to implement and scale

Verified User
Consultant in Information Technology
Information Technology & Services Company, 11-50 employees
Score 8 out of 10
Vetted Review
Verified User
Review Source
Usability
7
It is generally user friendly in terms of the various tools, but I think there is room for improvement in terms of seeking support or examples from other users.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
Lead Analyst
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
9
Matillion providing underline features of the database and unique functionality in connectors, increase our day-to-day work solution using the tool. For example, Snowflake database supports for JSON file system and thus using Matillion with Snowflake offers to flatten as an additional component is exceptional. Another example: Data could relive under FTP, sFTP, Cloud system (S3), databases and matillion have support to all, thus increasing the usability.
November 30, 2020

Ease of Use and Reusability for Excellent ROI

MB
Matthew Burr
Sr. Data Engineer
HireVue (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
10
It's very easy to use because of its graphical nature. Ultimately, it is a wrapper for activities you could do using SQL, Python, and AWS services, and by presenting those activities in a simple interface it makes it easier to perform them without having to worry about a lot of extraneous details.
October 05, 2020

Simple and Powerful

Verified User
Team Lead in Engineering
Financial Services Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Review Source
Usability
10
User experience is very intuitive and takes no time to get hands on it. There are lots of documentation which go pretty much into deep details.
October 05, 2020

I'd bet my job on Matillion

DR
Dan Reiland
Director, IT Operations
Clario, Inc. (Computer Software, 11-50 employees)
Score 9 out of 10
Vetted Review
Verified User
Review Source
Usability
9
Matillion has a clean and consistent interface that is readily approachable by anyone experienced with a visual or flow based ELT tool. The ability to rapidly onboard new users, reaching productive output in a few hours, is a key part of the value proposition. That it is usable by a wide range of skill levels is testament to the thought put into its overall design.
October 01, 2020

Matillion: flexible and complex

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Review Source
Usability
6
It's a mixed bag of usability: takes some getting used to, learning curve (not sure why some components can be used in "transformation jobs" but not "orchestration jobs" ?) but once you understand it, it's fairly usable.
October 01, 2020

Fell in love with Matillion in less than a week!

CM
Chandana M
Intelligence Analyst
RWWA (Gambling & Casinos, 201-500 employees)
Score 10 out of 10
Vetted Review
Verified User
Review Source
Usability
10
I can say Matillion can improve on a few things as answered in the previous question. But, I would still rate it 10 because I am completely dependent on it in my day to day activities. One of the reasons I took up a job is to be told in the interview that they were intending to purchase Matillion and they did!
Overall, Matillion is quite easy to use for any one with basic understanding of SQL. Can integrate external data sources with simple setup. For me, helps in answering all the business questions from my stakeholders with Tableau as data visualization tool.