Skip to main content
TrustRadius
Matillion

Matillion

Overview

What is Matillion?

Matillion is a productivity platform for data teams.Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed…

Read more
Recent Reviews

in my opinion, Meh

1 out of 10
March 29, 2024
Incentivized
We are moving away from Matillion to MWAA Airflow with dbt.
Maintaining source control in github is important to us.

We have used Matillion …
Continue reading

Matillion - Decent

6 out of 10
March 19, 2024
Incentivized
We use Matillion to schedule and run our ETL jobs. This helps our company to have accurate and timely data in order to make data-driven …
Continue reading

Matillion Review

8 out of 10
February 07, 2024
Incentivized
We use Matillion for loading data from various sources into Snowflake Data Lake. We have data in various source systems such as SQL …
Continue reading
Read all reviews

How Matillion Differs From Its Competitors

Time to Value

It has to be taken into account that the learning curve is high. It is a new tool that requires some understanding about its myriad of functionalities. However, jobs and ETLs can be done fast after getting a grasp on its components.
Continue reading

Time to Value

After just two months we had complex processes running on a production environment. And now after six months, we became really proficient users of Matillion which are also taking care of optimization improvements and not just a development.
Continue reading

Time to Value

It takes less than two hours for Matillion to be up and fully operational. If creating a backup instance, all code and settings can be downloaded as json files and then reuploaded in the new instance.
Continue reading

Time to Value

The learning curve for Matillion is relatively low. It is a great product and allows you to draw out a data flow diagram. Within 6 months, I was becoming fluent and efficient with using Matillion to collect and transform data into our Data Warehouse.
Continue reading

Time to Value

We got Matillion from the AWS marketplace, and we got up and running within less than a week. Starting the server was simple, then we had to do a bit of configuration and integrations with our servers adding the credentials, git repos etc. The experience was really good as Matillion blends …
Continue reading

Time to Value

We were able to develop the components in Matillion in a span of two months. We had a newly formed team of 3 people with almost no experience with Matillion. Once we are out of initial challenges in understanding the interface, it was almost nonstop for us with no interruptions and we were able to …
Continue reading

Time to Value

It took me about a few days to study those advanced features, due to not much community support, but I still was able to get support from Matillion. For those standard features, you can run it maybe within a few hours.
Continue reading

Time to Value

Matillion was already implemented at our company and any time requirements to learn the tool was based on my ability to translate my previous ETL coding experience into Matillion's structure. Our team inherited an existing ETL process built-in Matillion and were able to add/modify/delete new …
Continue reading

Time to Value

We were able to get up and running very quickly. This is really Matillion's strength. Once we got past the peculiarities of setting up our environment, we could connect to data sources right away and ingest data into our data lake. Putting on more pieces after that was easy.
Continue reading

Time to Value

We tested Matillion for about two weeks. By the time we were done testing, we were writing transformations. At that point, we were extremely comfortable with the tool, and we successfully migrated all of our existing code over to Matillion in a few weeks. The learning curve for Matillion is …
Continue reading

Time to Value

It has been an ongoing learning curve for a year. The basics are simple to pick up but after that, you have to turn to support for answers as there is nothing on the web. Support can take days to get an answer after emails are sent back & forth to gather the information required to answer your …
Continue reading

Time to Value

With the help of the support team, we had a proof of concept up and running in an afternoon. Since Matillion comes as an AWS package, there was no configuration needed to get the instance spun up, which was fantastic. Connecting to data sources that require their own JDBC drivers took as much as …
Continue reading

Time to Value

I was able to get my very first proof-of-concept instance up and running in under 10 minutes and get started building and executing my first basic ETL job in the Redshift product right away. And within about an hour, I had a basic prototype version of an SQL Server Integration Services(SSIS) job …
Continue reading

Time to Value

We were up and running with our first Matillion jobs in about a month. As time went on, we continually iterated upon our orchestration and transformation job designs and came up with standard templates to use for new projects. We did not immediately take any professional training courses - the …
Continue reading

Time to Value

Matillion was able to help us get up and running with our first ETLs in about a week. They assisted us with more complex integrations as we learned the platform.
Continue reading

Time to Value

I didn't set this up, so I can't say anything about setting Matillion up. Skimming through their documentation, I can see that it's fairly simple. An average SysAdmin would get this tested and running in under two hours (this is quite generous). As for getting started with the transformation …
Continue reading

Time to Value

I was not a part of the implementation of Matillion, but given my experience with their support team and using the tool, I couldn't imagine more than 48 hours to get the platform running and proper database credentials to get things moving.
Continue reading

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 11 features
  • Simple transformations (124)
    8.1
    81%
  • Connect to traditional data sources (122)
    7.7
    77%
  • Complex transformations (123)
    6.5
    65%
  • Testing and debugging (109)
    5.5
    55%

Reviewer Pros & Cons

View all pros & cons
Verified User
Employee in Information Technology
Consumer Services Company, 51-200 employees
Verified User
Team Lead in Engineering
Consumer Services Company, 201-500 employees
Return to navigation

Pricing

View all pricing
Matillion

Matillion

N/A
Unavailable

What is Matillion?

Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality…

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.matillion.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

26 people also want pricing

Alternatives Pricing

Fivetran

Fivetran

$0.01
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…

Dataloader.io

Dataloader.io

$99
per month
What is Dataloader.io?

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.6
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

7.3
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

7.2
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8.2
Avg 8.2
Return to navigation

Product Details

What is Matillion?

Matillion is a productivity platform for data teams.

Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions.

The vendor states enterprises including Cisco, DocuSign, Pacific Life, Slack, and TUI use Matillion to move, transform, and orchestrate their data for a wide range of use cases from insights and operational analytics, to data science, machine learning, and AI.

Native integration with popular cloud data platforms such as Snowflake, Databricks, Amazon Redshift and Google BigQuery lets data teams at every skill level automate management, refinement, and data delivery for every data integration need.


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's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.

Matillion Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
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 Data model creation and Metadata management highest, with a score of 9.1.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(204)

Attribute Ratings

Reviews

(51-75 of 125)
Companies can't remove reviews or game the system. Here's why
October 05, 2020

Easy to use and recommended for existing ETL developers

Verified User
Manager in Other
Online Media Company, 51-200 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is well suited for anyone needing to create a BI (ETL/ELT) solution on Redshift. It is very easy to use and provides a lot of components similar to other ETL tools. Please note all processing is pushed down to the DB (think ELT). The only downside is some of the under the hood logic is sometimes not acting in the documented/desired fashion, requiring workarounds.
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
Incentivized
Likelihood to Recommend
It's perfect for the teams who have very little experience with ETL and want to start creating pipelines with very little effort. It's also a very good solution if pipeline complexity is simple and does not require too much scalability.
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
Incentivized
Likelihood to Recommend
Matillion is an excellent fit for organizations that have expertise (and data) in one of the supported engines (BigQuery, Redshift, and Snowflake). ELT workflows are easy to implement and automate against data of varied size. The UI successfully hides the complexity of SQL for users not well verse in it, but provides expert SQL users the ability to implement complex transformations not easily achieved with the standard components.
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
Incentivized
Likelihood to Recommend
Good for highly customizable jobs, takes some learning curve but then very flexible.

Less appropriate: the Zuora API has some issues and we had to build the data pull from a bunch of basic API components instead of the proper highlevel one.
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
Incentivized
Likelihood to Recommend
I would 100% recommend Matillion for any business who is looking for an ETL solution for their cloud data warehouse especially Snowflake. What worked for us with Matillion is the ability to integrate our external sources (Elastic Search, Google Analytics), transform, automate and create a single data source for further data visualization.
October 01, 2020

Great product that does what it says on the tin

Paul Cebulski | TrustRadius Reviewer
Paul Cebulski
Systems Administrator
Parkwood Holdings ltd (Leisure, Travel & Tourism, 5001-10,000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's perfect for pulling data from SQL server no matter of the amount of the data, recently we have pulled 14 millions of rows and transformed this data in the matter of minutes. Matillion is not great to pull large volumes of data from Google Sheets.
September 17, 2020

Good stepping stone for data infrastructure

Verified User
Engineer in Engineering
Real Estate Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for small teams that require fast and graphic development of dataflow jobs. Not so great with its support (it might take several days to get any response and that is not good when pipelines are business critical). When it comes to orchestration of big teams working with GIT, it can become a nightmare: single-lined big jsons not specifying what work was done.
September 08, 2020

My experience with Matillion over the past couple of years!!

VM
Viswanath Manne
Data Engineer
Reportgarden Technologies Pvt.Ltd (Computer Software, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It would suggest Matillion for any medium level startup that is dealing with huge data and multiple sources of data, as it is easier to pull and push from/to multiple databases. Matillion might be a costly solution for early startups in my opinion, but if you are a huge data-based company, I would suggest you check out Matillion.
September 06, 2020

Intuitive and saves money on coders, but tedious and time-consuming in places.

Dan Dow | TrustRadius Reviewer
Dan Dow
Senior Technical Account Manager
PIX System (Entertainment, 201-500 employees)
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is really good at giving you a visual reference to look at data flows. The layout of orchestration and transformation jobs is intuitive enough that I have been able to show people who have never coded SQL in their lives how to use the product and they can understand how the data is moved and how it is transformed.

However, say you need to add a field to a top-level table that you have not written an extract for. Moving that new field across each transformation job for each intermediary fact or dim table can be very time-consuming and tedious and it seems it should not be that hard to add a feature--"populate through transformation as {field name}" should be possible.
September 03, 2020

Matillion: the last puzzle piece in modern analytical solutions

Aleksa Topalović | TrustRadius Reviewer
Aleksa Topalović
Professional Analytical Data Warehouse Engineer
Tamedia (Publishing, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you are in a situation that includes Redshift, a whole AWS platform and developing modern analytical solutions, Matillion is the tool that could improve your whole platform. Instead of writing complex scripts you have possibilities to design the whole process that is also understandable for business users also at the first look - implementing business logic is faster. Using the power of the Redshift you have an impression of instantly doing a job. Matillion also covers some other use cases like processing and integrating unstructured data so that all business needs could be satisfied. At the end synchronization with other tools also works fine so the whole BI process from data to insights is shorter.
September 01, 2020

Matillion - the swiss knife of ETL

Eduard Matei | TrustRadius Reviewer
Eduard Matei
Business Intelligence Engineer
Travis Perkins plc (Construction, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion can be designed to ingest a multitude of file types through an automatic process, allowing less technical users to create and control the end to end process of ETL. API queries, python code, bash script processing, Matillion can be used to solve complex problems, creating an easy-to-follow process.
August 31, 2020

Matillion for ETL and Data Collection

Verified User
Contributor in Other
Information Technology & Services Company, 201-500 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion has many ETL options that allow you to collect data in a multitude of different ways. If one way doesn't work as desired, there is almost always a second option, and lastly, collect it via a Python script. Matillion documentation is great, easy to follow, and specific.
August 29, 2020

Robust ELT with Matillion for Redshift

Antonello Supino | TrustRadius Reviewer
Antonello Supino
Head of Business Intelligence dubizzle / OLX, Middle East, Africa, South East Asia
dubizzle (Publishing, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is great when you want to integrate the data into a single DWH such as Redshift or Snowflake.
Also the task history is very clear along with all the detailed reporting on each single operator.

When you want to export data back to MySQL or to other data sources it is quite difficult, that's an area of improvement.
August 26, 2020

A cool and cost-effective ETL/ELT cloud platform for data integration

Verified User
Director in Information Technology
Financial Services Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
While Matillion is not going to be a silver bullet or just barebones, it provides rich features that are easy to learn and implement in your design and have it executed in a reliable and cost-effective way. Matillion continuously releases new features and upgrades on stability, upgraded documentation, and few micro features are required to make it perfect. It does address diverse capability, provides excellent technical support, costs less, and has interfaces that empower developers to offset for the few missing capabilities.
August 26, 2020

Simple and powerful data aggregation tool

Andy Lai | TrustRadius Reviewer
Andy Lai
Techinical Lead
Skyztree (Computer Software, 11-50 employees)
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is suitable for a use case that needs to support multiple data sources or where you have much data to load into the data warehouse. It is not suitable for a budget-tied project, as it is quite costly if you just deploy it to use it as a data loader.
August 17, 2020

My experience as a newbie to Matillion

DZ
Daniel Zielinski
Database Architect
Innovage (Hospital & Health Care, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is perfect for our organization since we are migrating to a more hybrid cloud-based architecture. I especially appreciate how changes to code are reflected immediately and can be seen by all developers instantaneously. This is of particular importance when employees are working remotely. The data that we ingest is processed twice a day, which is ideal for our organization. Any company that wants to invest in Matillion needs to determine and test the frequency of data ingestion.
August 14, 2020

Matillion is fast, fairly flexible, and easy to use

Avishua Stein | TrustRadius Reviewer
Avishua Stein
Business Intelligence Engineer
3Q Digital (Marketing & Advertising, 201-500 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for ingesting data from multiple sources, especially when the raw data is being stored in cloud storage. We have AWS Lambda connected to S3 and Matillion so triggering ingestion jobs when data is delivered is simple. Sending alerts for job failure or success to Slack/email is easy.

Matillion is probably less appropriate for scenarios where multiple people are going to be working on one job.
August 14, 2020

Good for Quick Starts, but can be a bit pricey for small enterprises at scale.

Britton Gray | TrustRadius Reviewer
Britton Gray
Director of Business Intelligence
Project Lead The Way (Education Management, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's very well suited for data ingestion. Many connectors and loop components particularly make it easy to grab lots of data in a source system programmatically. Python scripts make it extensible. It's not as good for modern data warehouse ELT - you can use it as a "traffic cop" in those situations - but is it really work so much money per hour at that point?
August 13, 2020

Matillion Is Easy Data Pipelines!

HW
Hyrum Ward
Manager of Data Engineering
Purple (Retail, 1001-5000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is a one stop ETL shop. It is extremely flexible, and has been able to manage anything we've asked it to do so far. We love it for any API calls that we want to make. It is also very useful for transforming data that is already in our warehouse.

Matillion might not be appropriate for a very small startup that is relying on free software. Airflow is a better choice in that scenario.

For large datasets being pulled from third parties that have complex schemas, Matillion can be a lot of work. It is possible, but there are other tools that specialize in that. Fivetran is a tool we use in tandem with Matillion to great effect.
June 28, 2019

Excellent Entry-Level ETL/ELT Resource

AL
Adam Labay
Data Systems Specialist
EdOps (Education Management, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is great for a team's first foray into ETL. It holds your hand exactly as much as is needed, and scales brilliantly within the scope of a small team. It becomes less ideal as you add more data sources and processing. It interacts well with Python, but any other scripting is harder to integrate.
June 17, 2019

Matillion is a powerful and easy-to-use, completely cloud-capable ETL/ELT solution.

Patrick Hildreth | TrustRadius Reviewer
Patrick Hildreth
Lead Data Warehouse DBA
Cimpress Technology (Computer Software, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is very easy to set up and get working on right away, anyone with access to an AWS account and the Marketplace can have a fully capable ETL server up and running in under 10 minutes and the 14-day free period allows an adequate amount of time to decide whether the tools works for your use-case. It has a direct hourly billing option that bills through your monthly AWS bill and the option to pay-as-you-go or pay up front and reserve an instance at nicely discounted rate. Overall it's the usability, flexibility, and capability that made Matillion the choice for me.
Return to navigation