Matillion

Matillion

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

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.

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

Reviewers rate Data model creation highest, with a score of 9.1.

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 76)
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
If you take the time to build your own with Matillion, you will end up with a vastly better solution than Stitch and Fivetran. We ran Stitch and Fivetran side by side connected from our source DB to both RedShift and Snowflake and documented the performance results as well as the multitude of data issues we had during the evaluation period. Those tools are great for plug-and-play if your data is simple and small. Our data and our source database are not simple, and huge and Stitch and Fivetran are just not great at handling variety. Now that Matillion is in place, the data loads that took Stitch seven days can be completed in under an hour. We have control over metadata and our DW data model, and can customize which columns from upstream we care about. The sky is the limit now that we have built out our solution. We are customizing, growing and expanding our capabilities every day and there is absolutely nothing standing in our way with Matillion. If we had chosen any other vendor tool (we evaluated many more that aren't listed by TrustRadius) we would be stuck. We would be hacking away at data in the DW instead of handling data in a well thought out manner as part of the pipeline.
Austin Lee | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion has been the most successful product I have used in our company. It has the best features in data integration field and of all products it has performed exceptionally. It was our selection from the time go and everybody was interested in it. I have not come across such flexible and user friendly tool since we invested in this product.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion is cloud-native, therefore it doesn't need virtual machines to set up. It is easier to use compared with some of them. It always does query pushdown, while other ones don't'. It is integrated with Snowflake, while other ETLs need to use workarounds in order to perform the same steps.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta loads on the warehouse (i.e. updating only those records updated in the database since the last execution). Some other tools seemed to assume that you were accessing data from transactional databases where records were not updated, only ever created. This meant that we could not use them to deliver our Warehouse.

Other tools that did have equivalent flexibility/functionality were a lot more expensive than Matillion.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion offers the unique capability of digital platform connectors (API connectors) and special functionality for Snowflake (which is our primary database). Also various sources including AWS S3, sFTP and various databases connection. In Pricing, the matillion option has economical than Informatica with our usage and Talend doesn't resonate well with flexibility, which we were looking for.
Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Server Integration Services (SSIS) is built around the Microsoft ecosystem; we needed something that was either "ecosystem-agnostic" or focused on AWS, which Matillion is. SSIS has very limited ability to parameterize jobs/packages compared to Matillion, reducing the reusability of jobs/packages.

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.
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
It is much easier to use in terms of GUI capabilities. The only reason we would use an ETL tool other than our own manually written SQL scripts, is to be able to allow other engineers to use it without having one domain expert stuck on the inner working of complex scripts. So the GUI is essential for that, otherwise we wouldn't bother considering an off the shelf product.
October 05, 2020

Simple and Powerful

Score 7 out of 10
Vetted Review
Verified User
Review Source
At that time, ~3 years ago, none of the competitors were as easy to start using as Matillion. As our team was not so experienced with ETL, Matillion was the best and easiest way to get our hands dirty with defining pipelines.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have direct experience with a number of ELT tools: SAS, Informatica, Pentaho, and others.
Matillion's ability to interface directly with Google BigQuery, the quality of its design, and the ability to be immediately productive made it the only product in the marketplace that we evaluated for this effort.
Paul Cebulski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
It's all in the Google ecosystem so integration with various offerings from Google is seamless. We can connect to various Google products with very little extra config.
Score 7 out of 10
Vetted Review
Verified User
Review Source
If you choose the Pentaho community edition, you need to take care of all deployment, server costs, etc.
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.
Aleksa Topalović | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Before the ETL tool we made the decision to stick to Redshift as a database. Compared to listed products (that I used) I would say that the decision was easy if we consider the sync with AWS and Redshift, cloud-based solution, team collaboration, built-in scheduling, and monitoring.
Score 10 out of 10
Vetted Review
Verified User
Review Source
I have used Microsoft SSIS in the past to collect, transform, and organize data. SSIS is harder to learn the details of. Additionally, it is harder to follow and understand. SSIS documentation is lacking and does not have relevant documentation in the product. You must google everything.
Antonello Supino | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Pentaho was used initially but the support was terrible. It was taking years to fix bugs and the scheduler was buggy, and it took an eternity to get the issue with the misfired job on the quartz Java scheduler to become made reliable. Informatica is a great tool that was considered, but Matillion was chosen as it is younger, cheaper and specific to Redshift. Jenkins is another tool we used. It is very reliable and free, but it was so difficult to create a simple and clear workflow to understand.