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 124)
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
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
Incentivized
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
Incentivized
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
Incentivized
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.
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
Usability
9
I'm really satisfied with the whole Matillion/AWS/Redshift environment. For me, it was easy to switch to an ELT approach and to rebuild all jobs. After just two months, I felt familiar with the tool itself and built some complex stuff really fast. I measured my experience, and after working with different enterprise BI tools, I can say that Matillion is really user-friendly and useful for many business cases.
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
Usability
10
Regardless of one's needs, Matillion has different tools to address even the most complex issues that can occur in the ETL process. It's easy to use and get along with, whether it is using the drag and drop of built components or creating your own from scratch.
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
Usability
9
The interface that can be edited by multiple users at the same time makes it very usable. It's not a script based tool but it can be so it is great for all levels of professionals. The interface is responsive and there is no need to install desktop clients which is great. Sometimes after upgrades, we have to manually clear browser cache which is a bit annoying.
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
Usability
9
Rich features include easy configuration, integration capabilities to different software like Salesforce, scheduling capability, ability to create projects to reflect multiple environments, isolation between projects, simple code export and import features, ability to use a lambda-based trigger, Python and Jython component, community and technical support, very responsive account team, license cost, and pricing model.
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
Usability
7
Matillion has a graphical user-friendly interface, you can drag and drop to control the details of the component and connect to others. The version stays updated and you can easily update to the latest version. It provides an easy way to set up from the cloud marketplace. It is easy to schedule jobs.
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
Usability
10
In previous organizations and projects, I utilized Microsoft's SQL Server Integration Services (SSIS) to perform all data transformation. I found the transition to Matillion to be much easier and flexible to fit the needs of our organization. The key benefit that we experienced with Matillion is the reduction in the amount of time required to deploy changes and work through modifications to the code. Being a cloud-based system, it is very easy for all of our team members to access the most recent code and not have to concern themselves with source control problems.
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
Usability
8
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
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
Usability
10
Matillion is drag and drop. It is extremely flexible, intuitive, and easy to get started with. Python scripts allow you to do pretty much anything you need. If you don't know scripting, there are widgets that can do what you need as well.

Scheduling a job is a few clicks. Couldn't be easier.
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
Usability
9
It has a very intuitive workspace and organization of components. The job/task components are very easy to configure and not overly complex like some other ETL tools. The task history and error logging makes it very easy to troubleshoot job failures.
Return to navigation