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.4
    64%
  • 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…

Astera Centerprise

Astera Centerprise

N/A
Unavailable
What is Astera Centerprise?

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.6
Avg 8.3

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 120)
Companies can't remove reviews or game the system. Here's why
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
Scalability
7
For the first year, scalability for pretty good. We didn't have any issues with number of transformations or overall speed of jobs. However, after we got more experienced with it and started to create more complicated jobs, scalability suffered a lot. Our jobs exhausted memory many times and we couldn't find any way to solve it. Only way was to get to the highest subscription level, which required more money investment and we didn't go with it.
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
Scalability
9
Matillion, because it relies on the computing power of cloud data warehouses, scales effortlessly to process massive data volumes. Scaling user count is the only limiting factor to growth, however, Matillion provides a number of licensing options to suit the needs of a single department to an large scale data engineering practice.
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
Scalability
10
We have been using the same instance of Matillion from when there were about 20 jobs created. At the moment, we are creating about 10 new jobs per day, with a couple of hundred jobs running every day, with performance not being affected at all.
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
Scalability
8
With Matillion, we push most of the computational load down to redshift so it's not an issue to scale up. Perhaps the instance sizes available may not fit if the load becomes too high, however, we did not face any of this issue. We are using multiple projects with multiple users and all is going well.
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
Scalability
9
The architecture of our enterprise data warehouse drives the scalability of the application. It is paramount to invest time and resources into building a proper data warehouse. By having a well-designed data warehouse, our ability to add new input data sources to our system allowed us to take advantage of Matillion's flexibility.
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
Scalability
8
That's the beauty of a cloud-based solution, right? We can scale up if needed, although the cost jumps pretty significantly. And we can always add more developer nodes as needed given source control integration.
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
Scalability
6
Generally, Matillion allows you to scale the size of the servers to fit your needs. It could be easier to increase the size, but it also could be that I've been spoiled by Snowflake in this regard. Having said that, we've already had to increase the size of our server, and did it without too much trouble.
March 05, 2020

Good at its core, but not a commercial dev tool

Mark Austin | TrustRadius Reviewer
Mark Austin
IT Consultant
Universal Music Publishing (Music, 1001-5000 employees)
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Scalability
3
You have certain size servers available from the AWS marketplace but even then it doesn’t seem to multi-thread it allow multiple of the same job to run concurrently. I really would like to see a single use, spin up, process one job and then spin down implementation of Matillion but on demand is not an option
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
Scalability
7
The product scales great for small to medium size teams or groups. For groups larger it becomes more challenging and requires more individual instances depending on the volume of running jobs and concurrent users - it handles 10's of concurrent users and jobs very well but much larger than that would be extremely difficult on the largest instance or cluster that is available at this time.
June 08, 2019

Matillion ELT for Snowflake

Verified User
Engineer in Engineering
Internet Company, 51-200 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Scalability
8
Matillion is an ELT tool - it's more about how well the cloud-based data warehouse it connects to can scale. And of course, cloud-based data warehouses are designed precisely to do just that with ease.
June 06, 2019

A quick impression on Matillion from a junior data engineer/analyst

Verified User
Professional in Corporate
Education Management Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Scalability
9
This can be run on either single or clustered instances so scalability wise, this is already a good start.
By supporting a wide range of input and output components, this can be scaled across different departments where different systems are used. This is ideally hosted on AWS, which opens us up to a great world of "scalability."
Return to navigation