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.5
    75%
  • Simple transformations (129)
    6.6
    66%
  • Complex transformations (128)
    5.4
    54%
  • Testing and debugging (114)
    4.5
    45%

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.2
Avg 8.3

Data Transformations

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

6
Avg 8.2

Data Modeling

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

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

(211)

Attribute Ratings

Reviews

(1-25 of 130)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion to transfer data between our production PostgreSQL databases and our Snowflake data warehouse. This robust integration ensures efficient data migration and significantly enhances our data management processes. By leveraging Snowflake's advanced analytics and storage capabilities, we then gain deeper insights and make more informed strategic business decisions, driving overall growth.
Score 3 out of 10
Vetted Review
Verified User
Incentivized
We used Matillion for a little more than a year to ingest and historize data coming from SaaS tools and internal databases to a Snowflake datawarehouse. This data was then further transformed to build business actionnable data assets modeling the performance and operations of the company at large. Those assets help stakeholders across the business in taking data driven decisions
Diana Pilzer | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion powers our team of 2 data engineers to manage the database of our entire company. Without Matillion there is no way only 2 people would be able to do this. It helps us be more productive and get to the projects we really need instead of spending all our time deep in legacy code for every single process update.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have a data and analytics team at the tech company. We're building a data warehouse/datamarts on Snowflake to produce business-critical reports for our clients. We use Matillion as an ETL tool and have some Matillion jobs to transform the source data into a presentable target for our logical data model.
Score 4 out of 10
Vetted Review
Verified User
Incentivized
Matillion ETL has been used in my company for a few years to run data ingestion and transformation pipelines that populate the main analytical DWH and send data to other systems like Salesforce or the internal customer support tools. In particular, millions of ingestion components are used to integrate with various external APIs, and Matillion Redshift transformations are used to reshape the data in a data model that makes sense for analytics.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion mainly as an orchestration tool to stage data from multiple sources and some light transformation. We also use it to export data to S3 leveraging Snowflake.
The GUI is intuitive, and the web interface helps to be up and running very quickly.
We have some issue related to the resources needed for some jobs, there's no visibility of the system resources used or auto-balancing of some activity to avoid the server to crash.
We don't like the billing mechanism being a cost based on the server CPUS because we host the server so we are already paying for it.
We would prefer a billing mechanism decoupled from the server resources for many reasons including the fact that it crashes on some jobs due to memory issue and upgrading the server would double the bill instantly for the same jobs. It doesn't scale naturally.
Few years ago when we started using it, it was a great player in the cloud ELT world, today it is suffering that while the interface is web, the engine itself is still monolithic and static, hard to migrate and move to a new machine.

We will be looking for other tools that have the creation of the data workflows and the actual scheduling/execution decoupled so that you can use a central hub to plan and create the logic and then decide in which region/sesrver to run them without having to worry about a full server being installed in every region.

Docker/kubernetes comes to mind, but implemented and managed effortlessly behind the scenes. We don't want to deal with it, just use the tool.
March 29, 2024

in my opinion, Meh

Score 1 out of 10
Vetted Review
Verified User
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 in the past for:
Replication - Copy from postgres, load to s3, perform transformation in redshift
Running python scripts
S3 data transfers - bucket to bucket


Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion ETL (extract, transform, and load) with Bigquery to transform customer data to a standard format. There are 100+ sources and file formats are different. We use Matillion to transform these files and apply business logic to create and store it in a standard format which can be used by downstream and we deal with terra bytes of data on a daily basis.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Matillion is used to build the data pipeline on the Google Cloud platform. There are multiple use cases: 1. Data is received in GCS storage and picked by Matillion based on the active sensors and on a specific schedule. Data is transformed and then loaded into big query tables. 2. Data is read from HTTP endpoints, transformed using Matillion, and then loaded into big query tables. 3. The data quality framework is built on top of Matillion to apply some business checks.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Matillion ETL is used to extract, transform and load data into the Data Warehouse in Snowflake from data sources like Oracle databases and external CSV files. Matillion is used both for managing, scheduling and controlling the ETL processes as well as the data loading and transformations.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion perfectly solves the issue of multiple data sources from different technology stacks and formats that need orchestrating into meaningful views of the data to then allow proper data mining. This then means we can provide the insights and trends the individual and group leadership needs in order to run the business in an adaptive and agile way. The technical team also appreciates the care given to building a UX that is easy to follow compared to other ETL tools used in the past.
Callum O'Connor | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We needed a way of empowering people with data in a no-code way. Data is a bottleneck and everyone needs it, but how do we give them this data and enable them to use it effectively? We launched ‘Data as a Product’ - A package of tools and resources that exposes raw data to people and allows them to manipulate it with ease. Matillion is the key tool in this package that allows people to manipulate data at the speed of thought with no code. Matillion’s no-code design, intuitive interface, and collaboration centric architecture allowed us to get people set up and transforming data in a matter of minutes with very little support from the Data team.
February 07, 2024

Matillion Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion for loading data from various sources into Snowflake Data Lake. We have data in various source systems such as SQL servers, many SAAS applications with proprietary databases, Quickbooks, files, and so forth. It is important to have data from all of these sources in the data lake for integrated reporting for the business.
Matthew Belo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We replicate data between PostgreSQL and Snowflake for most of our core business operations. We were using various home-grown techniques for doing that which took a very long time to complete due to the growing size of the data. We turned to Matillion for help and started first with their original CDC product that was part of the ETL server. That could not handle the volume that we pushed, so we switched to their developing CDC product in Data Loader.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion has played a significant role in streamlining your ETL (Extract, Transform, Load) processes and has resulted in substantial time savings for your team. Automating data processing across different domains like Media Data, Sponsorship Valuation, and Consumer Research has enhanced efficiency and productivity.The reduction in processing time by 600 hours is a noteworthy achievement, allowing team to focus on more strategic tasks and potentially accelerating the pace of decision-making within the organization.Moreover, leveraging Matillion to create data products and explore new offerings demonstrates the platform's versatility in supporting innovative solutions and helping organizations derive more value from their data.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Matillion as our main tool for all ETL/ELT processing. Our DWH target DB is Snowflake. We extract data from different sources; ex: SQL Server, BOX, S3, SAP HANA.
We also use Matillion to execute Python scripts. We are working currently to configure Matillion to connect to Github.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We get a lot of different files from different partners/vendors. We also have multiple databases that all need to be centralized. We use Matillion to read in the data from these different files and databases into a DataLake. That datalake then serves the rest of our company from reporting to billing.
September 07, 2023

A Necessary tool

Score 7 out of 10
Vetted Review
Verified User
Incentivized
The main issue at innova is manual process. With matillion we implemented automated data flow for disposal data to Google BigQuery

currently
We have near 50 automated jobs that runs every 5am and finished at 5.30am.

Also we matillion for extract data from HubSpot, zoom, brighspace, PostgreSQL, MySQL, cloud storage.

Score 8 out of 10
Vetted Review
Verified User
Incentivized
They come in far cheaper than other brands with the same level of support and functionality. When they deliver on the cloud based offering this will be a big step forward. Matillion has become an indispensable asset in our organization's data workflow. It elegantly tackles our complex data integration and transformation needs, streamlining processes that were once time-consuming. Our work with Matillion will continue to thrive and provide our business value going forward.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion is used to transform data from organizations transactional systems, sales and marketing systems and logistics. Data is transformed to create data assets that are easily consumed by users to take critical business decisions and also report operations and trend analytics. Matillion is also used to feed data into other systems that do not currently provide direct connectivity from various other applications. Matillion is also used to create and support a hub/spoke model for data assets that we have for self service reporting within different business units
Return to navigation