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

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

(51-75 of 125)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion was used in order to create a Redshift Data warehouse solution. Where the Data warehouse followed the Inmon module and on top of that is a Data mart with multiple aggregations. It was the product of choice for BI needing to move from an old ETL tool and DB.
October 05, 2020

Simple and Powerful

Score 7 out of 10
Vetted Review
Verified User
Incentivized
Matillion is being used only by data engineering team, which is part of Data Science department. It's our ETL tool to populate our data warehouse on Snowflake. Orchestration jobs are running on a daily basis and are basis of BI reports, which are used across the whole organization. Except that, it's used to generate new feature sets for data scientist for modelling.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion is primarily used by our Data Engineering team to produce highly curated datasets for use by our clients. We transform extensive volumes of client and vendor data into a highly clean and valuable artifact. Matillion is our primary ELT tool and has displaced a number of other tools previously used by our organization.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion is our ETL tool to populate our data warehouse running in Google BigQuery. In conjunction with Google Data Studio, we have a daily process used across the whole business with up to date financial, commercial and project data. It is managed by the Technology Team but the whole business sees the results.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion has been used to clean, integrate and transform data from multiple sources are prepare data for data visualisation to answer key business questions at our organisation. Our business problem was finding an ETL solution as we moved towards Cloud data warehouse. We right away knew Matillion is the best fit for us.
Paul Cebulski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We started using Matillion a couple years ago across all areas of our business. We use this tool to gather data from various data sources (SQL, Google Sheets, API calls, etc.), and transforming it and eventually outputting to our data warehouse for data visualisation.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Here at ReportGarden, we use Matillion to fetch data from multiple databases and construct a compact and easily referable database using various data blending techniques with the help of various blocks like Python script, SQL, joins, etc. We use the combination of SNS and Lambda to make sure tasks run seamlessly every day and to stop EC2 instances once tasks are done, which is of great use in saving unnecessary costs.
Dan Dow | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We use it as our ETL tool across the entire organization including marketing, finance, customer service, and support. We pull data from our proprietary product use as well as Salesforce to merge data about our product use, customer service, employee time, billing and finance information, and process handling in our AWS cloud core.
Aleksa Topalović | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Within the Business Analytics team, Matillion was introduced as a new ELT tool after team extension. In that time, we had four active BI developers and the main need was a centralized project repository that will make the daily workload easier. We are using Matillion for development and maintenance of the data warehouse and integration of more than 20 data sources.
Eduard Matei | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion as the main ingestion tool within the business intelligence department. We use it to ingest data coming from different legacy systems, outputting data in the cloud datalake solution. It's really easy to learn, configure and spend less time ingesting the data and more time getting insights from the data.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion is being used as an on-premise ETL by our Data and Analytics team. Matillion has been a great tool for our organization from an ETL standpoint. It is scalable and flexible enough to accomplish any task we need to do. Matillion support is also spot on, timely, and responsive. Will work through any problem with you--whether it be you or them. They will see it through.
Antonello Supino | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion for Redshift as to orchestrate data pipelines as our main data integration tool. We are pleased by the usability and reliability along with multi-user interface, git integration, and lots of plugins. Matillion has helped us to have strong data pipelines that we can monitor to run hundreds of jobs a day. Support is also proactive. It's overall a great ELT tool.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion is used as the primary ETL/ELT for data integrations in AWS cloud. We needed a tool that has diverse integration capabilities, rich features, is simple to use and manage, costs less, is easy to learn, and requires minimal maintenance. With a small IT team, we cannot afford to compromise in any of the aspects, as the company’s entire dataload depends on it.
Andy Lai | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
I use Matillion for one project. I use Matillion to solve my data loading issue because Matillion supports many data sources. I use this to aggregate all the data sources to my data warehouse. Before using Matillion, I needed to write my own data loader, which was very time consuming and created a lot of stability issues. By using Matillion, I can load my data within an hour to my warehouse.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We utilize Matillion to transform data from multiple source systems into a cloud-based database. Our department is the sole user of Matillion and is managed exclusively by our team. Matillion allows our organization to consolidate our various data sources into a singular environment where our dashboard tools access data to provide valuable insights into the various units within our organization.
Avishua Stein | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It's being used by our BI team, to ingest data into our Data Warehouse and distribute primarily to clients via Tableau, GSheets, emails, SFTP, etc. We also use it internally. Almost all our usage is for loading data although we use some transformation components when bringing in semi-structured data. Our team supports the entire organization.
Britton Gray | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use it to take data from many sources and ingest them into our data lake. We then use Matillion to orchestrate transformation jobs on that data to eventually land it in our data warehouse.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion is being used by Data Engineering, which is a part of the Purple Analytics department. No other departments are using it. Matillion helps us automate our data pipelines. It gives us a platform on which we can schedule Python scripts, and provides an easy workspace where we can design and implement our workflows. The Matillion server is easy to maintain, which was a problem before we switched from our previous platform. Matillion makes it easy to perform ETL operations on our data, whether it starts in our data warehouse or not. It gives us plenty of flexibility in how we design our jobs. And it's super easy to use.
Patrick Hildreth | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are currently using Matillion as our primary ETL/ELT tool both in our department and supporting others in the organization as well as introducing it to other Business units under the Cimpress brand. For us and others it primarily solves the need of loading and manipulating raw data from multiple sources and making it available in both Redshift and Snowflake. Additionally, the flexibility of the tool and its seamless integration with the complete AWS Services library allows us to perform many operational tasks that are completely unrelated to the ETL/ELT workload.
Return to navigation