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

We were able to get up and running with Matillion within a week. When we spun it up, we started putting together our first jobs, and they were super simple to set up. Though the jobs were on the simpler side, it was pretty easy to get started.
Continue reading

Time to Value

Matillion has published a step by step guide on support portal which makes it easy to configure up and running test instances in less than an hour. However, production instance configuration will depend on deployment strategy, familiarity with AWS ecosystem, security requirements and connectivity …
Continue reading

Time to Value

I was not involved in the initial phase of implementation, but once we had it set up on an ec2 instance, I was able to start creating flows with minimal guidance.
Continue reading

Time to Value

We were able to get up and running with Matillion within a few months, on and off, while also working on other things, as well as deprecating our old ETL solution.
Continue reading

Time to Value

Well, we worked on Matillion for roughly three months before actually acquiring the product. It was essential to first get training because you tend to miss out certain basic functionalities without a matillion expert guiding you. Also, once we had a little hands-on with the product it wasn't very …
Continue reading

Time to Value

We were able to successfully deploy everything into production in less than 4 weeks. This includes setting up the Matillion (and Snowflake) environments, connecting to on-prem databases, pulling stage data, building the data warehouse transformations in Matillion, and exporting the results into …
Continue reading

Time to Value

It was up and running in about 3 weeks. From initial conversations to Matillion, to infrastructure setup, to testing, to actually ETL being run.
Continue reading

Time to Value

Very quickly. We did a POC in a couple of weeks and then migrated production ETL to Matillion in about three weeks. Support from Matillion was outstanding during the transition and post implementation period.
Continue reading

Time to Value

During our evaluation of different products on the market, I was able to spin up an instance, connect it to Snowflake, and create jobs that accomplished a specific business need in one day. Once we formally adopted it, it's taken us several weeks/a couple of months to convert our existing ETL …
Continue reading

Time to Value

Matillion is VERY easy to set up. I configured an instance of Matillion for a client of mine in about 10 minutes. I had a working automated load combining multiple data s in about an hour. Once configured, it's simple to add addition data sources and additional environments. I love how easy it is …
Continue reading

Time to Value

The Matillion instance and the needed connections were set up in a couple of days, after which the transformation process was started.
Continue reading

Time to Value

It's pretty quick to have it running since Matillion (for Redshift) provides pre-configured EC2 AMI instance via the marketplace. We were also able to emulate this by running Matillion for Snowflake from scratch. After that, the learning curve is relatively simple.
Continue reading

Time to Value

Implementation with Matillion is very quick because of its ability to purchase it on-demand in the AWS Marketplace and get a trial instance running immediately. Converting that instance to production once the trial has expired is painless as well.
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.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 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

(76-100 of 125)
Companies can't remove reviews or game the system. Here's why
June 13, 2019

Easily set up your ETL/ELT pipeline with Matillion

Verified User
Director in Engineering
Financial Services Company, 11-50 employees
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
For organizations that have limited resource with AWS Infrastructure/Lambda knowledge, this is a great tool that works right out of the box. This tool is great for batch jobs and easily works well with AWS. However, for most processes, it could be replaced easily with a simple Lambda.
June 06, 2019

A quick impression on Matillion from a junior data engineer/analyst

Verified User
Professional in Corporate
Education Management Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is a great tool that can be used by users with technical skills ranging from average to expert (aka, it's pretty simple to build ETL jobs for your average users with basic knowledge regarding databases and data handling).
June 05, 2019

Easy to use and priced right, but scaling with a team is difficult

BB
Bryan Boutwell
Director of Data
Mailgun (Information Technology and Services, 51-200 employees)
Score 5 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for people with SQL skills and makes it simple to get data into a database quickly without much dev time required.

Source control is not well thought out and is basically unusable.
May 27, 2019

2 Years with Matillion

KS
Kris Shinn
VP, Technology
Jukin Media, Inc (Entertainment, 51-200 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is great at processing an ETL for cloud-based systems (Jira, Salesforce, Google Analytics, etc). It reduces (or in some cases eliminates) the need to put together a custom software interface into these systems. It is also great for non-technical users who want to put together some ETL processes for analytics, but do not want to invest into a Data Engineering team. It's also great for landing data for consumption into end datastores like Snowflake or Redshift.
Matillion is not great for large datasets or prepping for data science. As a single vertically scaled solution, it does not have the power of a cluster oriented ETL technology like Spark. Additionally, to prepare datasets for data science where you would want to bring in a processed dataset in Parquet or Avro formats, it requires you to land the data into Redshift and then dump it back out, then format it, in order to get it into a portable format for something like RStudio.
May 27, 2019

Matillion for Snowflake - Excellent (cloud-only) solution for ELT pipelines and complex transformation needs

Verified User
Analyst in Information Technology
Consumer Goods Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion ETL for Snowflake is an excellent tool to create ELT pipelines to integrate in-house and external applications. It has several integration components which simplified data loading. Provides powerful transformation capabilities which require hours of coding otherwise. Complex transformation requirements can be achieved using the Python component.
May 25, 2019

Matillion has an easy learning curve and expansive customization options

Verified User
Analyst in Quality Assurance
Information Services Company, 11-50 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited to recurring, SQL-based data pulls that happen on a regular basis. It is also easy to modify existing flows via variables for new tasks, as well as leveraging Python to update variables such as dates and date-based table names. It is not appropriate for live data return. "Select" is not supported in that data outputs must be sent to a table.
May 24, 2019

Matillion has met the needs of our data warehousing and ETL better than we had exptected

TS
Travis Schaugaard
Data Warehouse Developer
Xyngular (Health, Wellness and Fitness, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
We also use AWS pipelines to pull data from one environment to another. It works great for a straight data copy. However, it doesn't allow much transforming of the data. Matillion provides a much better way to make transformations on the data prior to loading it into the database.
May 24, 2019

Matillion Review

Verified User
Engineer in Information Technology
Internet Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is good for reading and transforming data to a data warehouse, and has a variety of transformation commands. The flowchart UI makes most workflow composition relatively easy.
One thing to note is that it lacks any built-in version-control management, so you can't really save the state of your Matillion instance configuration very easily in your version control system (e.g. using Git).
May 22, 2019

The go to ELT solution for Redshift datawarehouses

Arnob Bordoloi | TrustRadius Reviewer
Arnob Bordoloi
Data Analyst
SquadLocker (Sporting Goods, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Suited for:
1. People looking for cloud-based ETL/ELT solutions.
2. Works great with Amazon Redshift data warehouses.
3. Large transformation jobs, as it leverages the power of redshift to run transformations.
4. Great UI for users to create, maintain and document jobs.
May 22, 2019

Matillion For All

TT
Tanishka Tikoo
Software Developer
Zscaler (Information Technology and Services, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for all such projects where there is a need for extraction transformation and loading made easy. You can avoid the long cumbersome SQLs by using the various components provided by matillion. It is a fresh new tool which has a lot of potential and a lot of exploring is still required.
May 18, 2019

Matillion: ELT vs ETL

Clark Huang | TrustRadius Reviewer
Clark Huang
Chief Technology Officer
Lime Light CRM, Inc. (Internet, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you have lots of data from multiple transactional data sources and schemas that you need to iterate through and combine into a data warehouse, then Matillion was the easiest solution we found when we were in our proof of concept phase 3 years ago. We had some performance issues initially, but Matillion support and account management were able to help us through those, and now it has been running very smoothly for the last year.
May 15, 2019

Excellent ELT product that helps deliver rapid value and clear, easy to maintain transformations

Verified User
Consultant in Information Technology
Information Technology and Services Company, 201-500 employees
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Same as the pros and cons. Matillion is great for quick integration to may sources, provides an excellent interface to build, debug and test SQL transformations, and has an easy to use schedule. But it has limited on-prem functionality to manage file ingestion, external logs, and triggers. It also performs poorly with queries over large tables due to subquery reliance.
May 11, 2019

Matillion ETL for Amazon Redshift

OI
Oleg Ivashov
BI Solutions Architect
Ansarada (Financial Services, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Fast and easy way to bring all of company's data into Redshift data warehouse. We haven't come across anything which Matillion cannot handle yet. We even control Redshift workload management (WLM) parameters from Matillion, that is we give ETL more Redshift resources during the actual ETL running time earlier morning and then take them back and give to analysts.
Return to navigation