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

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

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 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

(204)

Attribute Ratings

Reviews

(1-25 of 124)
Companies can't remove reviews or game the system. Here's why
March 29, 2024

in my opinion, Meh

Score 1 out of 10
Vetted Review
Verified User
Incentivized
I prefer code that is source controlled. Too many things can go wrong when your operating on production analytics data, and making changes.
Tenancy is also an issue; in my experience, the server can't handle too many logins at the same time. If multiple people make changes, the project can become unusable and it's extremely difficult to backtrack.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have created Matillion code builder which helped us in building pipelines even by the Business analyst just by passing a config file. It helps in less development time and early visualization on the transformed data
Score 9 out of 10
Vetted Review
Verified User
Incentivized
While everyone on our team has a general ability to work with technical data processes, we do not have a profound coding background. Matillion enables us to still set up all the data pipelines that we require and maintain them in an easy-to-use way.
Callum O'Connor | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The drag and drop component design allowed customers to create complex data models at the speed of thought. The prompts/errors are useful in terms of getting components to work, and you can see exactly where along the pipeline/transformation process something breaks. Branching off the pipeline and dip-checking/sampling the data as it goes is also super helpful for debugging. From an engineering perspective, we’re able to take complex SQL models, re-create and visualise them in Matillion, refactor the design, then use the SQL output from Matillion to create new data model.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
The ability to both do SQL "the old way", and the drag and drop which also can provide the SQL in the background, makes it a future-proof tool that has had a great impact on our team's workflows.
February 07, 2024

Matillion Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
It has been easy to train new employees who don't have previous experience with Matillion. It is quite self-explanatory. There are quite a few things that can be done with Python, however, we have not really looked into this feature much but likely will do in the future. Mostly, it is drag and drop of components and environments can be set up so easy to set up connections as well.
Matthew Belo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is very easy to do what is needed for replication, but working with the ETL product is a bit daunting. Since it is not our primary tool from Matillion, we have yet to receive any training on it so it is not intuitively obvious what we need to do to accomplish many of our plans.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I do love the low code feature. It's easy for anyone to follow the flow. There are some file formats that are more complicated and do require a bit of python programming to implement them though. However, having the option to write some code to parse things is very beneficial.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Simple to use, however there is always room for improvement and the cloud offering looks exactly like that. I am glad that have taken a n update to their UI. Options for debuging during each stage of the pipeline have been very helpful when performing ELT and placing data in the destination correctly.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Easy to follow steps in building a data pipeline. We have brought in people with minimal SQL experience and they have been able to quickly and successfully being able to pick up the skill set and contributing in reducing the time to market with various data assets. Matillion does provide a long array of components to select from to perform data transformation. But like any other tool, there are more than one way of doing the same thing. Some are more performant than the others, but easy to follow and easy to tweak to improve.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion’s no code features helped the team to get on boarded quickly. The team has to put less effort on training on coding and can directly start using the tool. The no code feature of Matillion also helped in debugging the easily and helps in saving lots of time in debugging.
March 28, 2023

Solid ETL tool

Score 7 out of 10
Vetted Review
Verified User
Incentivized
There is a lot of information available online so when you go looking you can find articles that provide answers. However in a number of instances a better UX might have meant not needing to go looking for those answers. The shared jobs feature would be a good example of this.
Return to navigation