Matillion

Matillion

Top Rated
TRUE
About TrustRadius Scoring
Score 8.1 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

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

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
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!

Pricing

View all pricing
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

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 uses an easy to follow GUI. Orchestrate your jobs quickly and simply with control data flow functionality, automating the ETL process.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.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.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

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

(1-25 of 91)
Companies can't remove reviews or game the system. Here's why
Jay Archer | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
My learning curve was long. Matillion is simply not like any other ETL / ELT tool out there, because Snowflake isn't like other cloud databases out there. I had to first learn a different pattern of data movement and error checking. Next, I had to learn which components to use and when. There aren't any good in-depth how-to guides out there. There aren't really detailed instructions on how to implement a specific pattern and what challenges you are going to face and how to handle them. There isn't a site for users and developers to hang out and ask questions, there is only the support ticket queue and some very knowledgeable and helpful Matillion engineers to answer your questions.
Austin Lee | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion was implemented within one week in our organization for full functionality. Our company secured its deployment within this period of time and all our programs were able to run smoothly. The learning curve was easy to master and get it run as expected within a short period of time. Our teams commitment and flexibility of this tool contributed to quick implementation.
July 09, 2021

Matillion Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
I started reading about Matillion and after one week and talking to their support team I started my project and it was up and running after 2 weeks of developing.
Score 9 out of 10
Vetted Review
Verified User
Review Source
It took some days in order to figure out how to configure the environment and all the basic configurations. Writing simple jobs took a really short time to learn (hours), while in some other days I was able to prepare a full orchestrator. Parameters configuration is a little more complex and I had to figure it out in some hours together with a colleague of mine.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Within a month of getting Matillion we had an established pipeline that was extracting data from the company's application database and updating the corresponding data in the warehouse. Additional data source (e.g. Salesforce and Netsuite) were quick to implement (c. 2 weeks per data source) including any relevant testing.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Proof of concept took a couple of weeks. Getting access to private SQL databases was a little fiddly as we needed to install some drivers which we would have expected to be installed as default, but once up and running, we have had no issues. Tweaking firewalls settings to allow Matillion access took a while.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I watched training and example videos/seminars for about two weeks before getting an instance set up for the company. And from there, I had a usable workflow going within another week.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running with-in a week time after acquiring a license but for the development team to work efficiently it took a couple of weeks.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We were able to get up and running with Matillion within a month. With no real training in the tool, we were able to develop useful jobs and an entire job framework on Matillion within that month. As we got more familiar with it, within three months, we were able to take advantage of additional features to create a framework where bringing new data in from our application is as simple as adding an entry to a table.
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
From the moment we bought it on AWS marketplace to connecting to our monolith database it took a matter of hours. Deciding the Redshift table structure we needed for storage actually took longer than the actual setup time! That is a definite plus for anyone who wants to get up an running as soon as possible.
October 05, 2020

Simple and Powerful

Score 7 out of 10
Vetted Review
Verified User
Review Source
Within 2-3 weeks from starting Matillion, we had our first simple pipeline in production: extracting data from our operational database and putting it into data warehouse.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Our initial POC demonstrated that migrating to Matillion was the logical next step for our organization. Our expectation had been six months to migrate our production loads from legacy tooling to Matillion. We were able to migrate complex production workflows, validate the result, and promote the Matillion generated artifacts in less than two months. Processing time for each workflow was cut from three days to a few hours. The productivity gains were stunning. Team members have been freed to focus on deeper and more valuable work as a direct result of our implementation.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Used the trial edition initially and was able to set up an ETL process for production, which then started populating real reports in 6 weeks. Previous process was quite manual, a combination of Alteryx and Excel which took a lot of time.