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
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 11 features
  • Connect to traditional data sources (127)
    7.4
    74%
  • Simple transformations (129)
    6.4
    64%
  • Complex transformations (128)
    5.3
    53%
  • Testing and debugging (114)
    4.3
    43%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

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

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…

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.1
Avg 8.3

Data Transformations

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

5.8
Avg 8.2

Data Modeling

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

6.7
Avg 8.0

Data Governance

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

8.2
Avg 8.3
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 Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

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

(210)

Attribute Ratings

Reviews

(1-25 of 125)
Companies can't remove reviews or game the system. Here's why
Score 3 out of 10
Vetted Review
Verified User
Incentivized
As we had the PaaS flavor of Matillion, our instance was hosted on an AWS EC2 instance that doesn't scale well. We had to pay for a big instance 24/7 while big workflows were only running for one hour a day. However when they did, we sometime saw the instance crash due to out of memory errors.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Score 4 out of 10
Vetted Review
Verified User
Incentivized
Functionality scalability is good (there are many connectors and supported systems out of the box). It's also easy to create a custom component to interact with a system that is not covered by out-of-the-box connectors. From a performance point of view, my experience with scalability is not good (and tied to the Matillion business model): 1. The maximum parallelism of the running jobs depends on the number of cores of the machine where Matillion is deployed. AFAIK it's only possible to deploy Matillion on a single machine (EC2-like). The license price depends on the number of cores that the machine has. 2. The scalability of the UI is pretty bad (random crashes/slowness), and the number of concurrent open sessions is limited by design (again, pricing-related), even if the sessions belong to the same user.
March 29, 2024

in my opinion, Meh

Score 1 out of 10
Vetted Review
Verified User
Incentivized
It might connect to many data sources, and multiple environments; but I would not call it flexible or scalable.
How it Matillion scalable? I'm now confused.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
The company uses both AWS and GCP. Data movement across the cloud and different stacks, like file, SQL, and no SQL, is really helpful. It also integrates well with API endpoints. The tool is very performant; even a huge amount of data can be easily transformed and loaded into the warehouse.
Callum O'Connor | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
There are more and more connections to external sources being introduced each quarter on DPC which is great. And because a lot of the compute work is done on the data warehouse itself it means we can control costs easier. The DPC pricing model is also a lot more scalable compared to METL; where we're charged for the run-time of a pipeline, rather than number of users.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion in a Snowflake environment. But we also get data from Azure, AWS, and a lot of other data sources. So we already use it in a kind of multi-cloud environment, which proves that it is future-proof, with a lot of scalability options.
February 07, 2024

Matillion Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
So far connection to various data sources has worked well. There is a Workday connector that was recently launched which we will be looking into. They have QuickBooks connector as well which was a bit challenging to set up. Scalability is good, however, we have not looked into everything that is available.
Matthew Belo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The current connectivity is set to provide information primarily in one direction; from simpler OLTP systems to big data warehouses. Allowing the big data warehouses (e.g., Snowflake) to be used as a source for transmission elsewhere would be a big extension to the product line and provide more flexibility in architecture.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I have been able to connect Matillion to AWS Aurora Databases, MySQL databases, Rest APIs, Files in AWS S3, etc. Being able to load all of that disparate data into one datalake has made data mining and reporting a lot simpler. I wish everything could be implemented as easily as Matillion.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I would say that Matillion is lacking on the On-Prem connectivity. We had a few problems connecting to a cloud instance since we currently have everything on premisis. Once setup in Azure it is working fine, but it would have prevented weeks worth of connectivity issues if Matillion had an OnPrem client.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
There are multiple options to connect with Matillion in terms of sources and targets and the connections have been robust.
There are also options for out of the box API that can be called through Matillion, but the list can be longer to cater for the more popular data providers. Matillion does also offer an option to build your own API profiles, but the information to do that can certainly be improved upon and on our talks with the vendor, it is in the works.
Return to navigation