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

One of the key strengths of Matillion is its user-friendly interface, which allows non-technical users to easily set up data integrations and transformations. The platform supports a wide range of data sources, including cloud-based databases, file systems, and APIs, making it an excellent choice …
Continue reading

Time to Value

We have started doing some research about ETL tools since we decided to do not to develop it a house, and after talking with some colleagues and reading about Matillion, we decided to move it forward, and that was our time schedule: Research and ETL tools try 45 days Developing our project on …
Continue reading

Cost Savings

The long term savings from Matillion have primarily come through decreased work hours associated with building, maintaining and trouble shooting ETL processes.
Continue reading

Business Outcomes

Matillion's connection options are robust. We have been able to connect to many different database types, as well as build direct connections with our partner APIs.
Continue reading

Onboarding

Maybe two weeks to get over the initial hurdle and then we were off to the races. For the most part Matillion is very intuitive, simple, and easy to implement.
Continue reading

Time to Value

My learning curve was long. Matillion is simply not like any other ETL / ELT tool out there, because Snowflake isn't like other cloud databases out there. I had to first learn a different pattern of data movement and error checking. Next, I had to learn which components to use and when. There …
Continue reading

Onboarding

a full year to get fully implemented. The onboarding was immensely painful given the documentation was lite and incorrect in many places. Many patterns of use I had to figure out for myself. At the time of implementation there was no developer community and the only company contact was through the …
Continue reading

Time to Value

The internal communication and collaboration than the setup of Matillion, once the EC2 instance triggered, we were able to get started with transformation jobs within 1 hour.
Continue reading

Time to Value

Matillion was implemented within one week in our organization for full functionality. Our company secured its deployment within this period of time and all our programs were able to run smoothly. The learning curve was easy to master and get it run as expected within a short period of time. Our …
Continue reading

Time to Value

I started reading about Matillion and after one week and talking to their support team I started my project and it was up and running after 2 weeks of developing.
Continue reading

Time Saved

Yes, after I started using Matillion our ETL process became much faster and we are running the instance on AWS only 1 or 2 hours per day which means we are not spending too much money but we are having many benefits once the process is much faster now and our visualization team can find the data …
Continue reading

Cost Savings

Before Matillion we used to use software created by our own company which was already old to date and it was really hard for our new employees to get in of it. Using Matillion we are saving money on training for new partners and now we have a much more organized ETL environment.
Continue reading

Business Outcomes

Yes. We don't have a lot of data sources but all of them we were able to connect smoothly and import our data easily.
As an example of our data sources I can mention, Relational Databases on AWS running SQL SERVER, we have some input from S3 (text files) and of course, some excel files.
Continue reading

Onboarding

Matillion's implementation was really really easy and smooth, most of my questions I could find solve questions using their forum or sending them an e-mail which was replied to within 1 or 2 days. Their documentation about all the components I consider complete and with good examples of how to …
Continue reading

Time to Value

It took some days in order to figure out how to configure the environment and all the basic configurations. Writing simple jobs took a really short time to learn (hours), while in some other days I was able to prepare a full orchestrator. Parameters configuration is a little more complex and I had …
Continue reading

Time Saved

We're using Matillion for ELT and processes are slower. It is a mix of Matillion efficiency and DB performance, but the total result is better than before. We are using a Large account and it is the right choice, while with the Medium size we weren't able to performe the same results and we had …
Continue reading

Cost Savings

We are reading from many different sources. Extraction times are better than before and we found almost all the connectors we needed and the support helped us to obtain the best extraction performance. Matillion costs are coherent with the usage, and it is useful that we are not paying when the …
Continue reading

Business Outcomes

We were able to connect all data source, but we had some issues with SAP: the native Netweaver connector do not allow to read SAP tables in join, as the 2 tables are loaded in memory and the join is apply at the end. Therefore we had "out of memory" issues with this strategy. But we could find …
Continue reading

Onboarding

Matillion is really easy to use, so we were able to start writing our flows easily. The activation is still easy, but you need to have some tech skills to work with putty and install what is missing (specific ODBC etc). For these aspects we moved questions directly to Matillion's support and the …
Continue reading

Time to Value

Within a month of getting Matillion we had an established pipeline that was extracting data from the company's application database and updating the corresponding data in the warehouse. Additional data source (e.g. Salesforce and Netsuite) were quick to implement (c. 2 weeks per data source) …
Continue reading

Time Saved

Yes we did. It was possible to update the data warehouse database every 3-4 hours instead of every 24 hours. In addition, and perhaps more importantly, it provided a more stable ETL process. The previous one was prone to breaking/failing and Matillion provided a more reliable process and one that …
Continue reading

Cost Savings

In terms of infrastructure costs, our costs have gone up using Matillion. Historically we used AWS DMS to clone the production database into a Postgres database. This old process, however, was prone to issues and failures, e.g. when the production database was updated with new column(s)/table(s) …
Continue reading

Business Outcomes

We were able to connect to our main data sources using Matillion (a MySQL database, Salesforce and Netsuite). Other data sources, that are API based and didn't have specific components in Matiilion were more of a challenge at the time. Although API functionality has been improved since we …
Continue reading

Onboarding

Onboarding was quick and relatively pain free. The team did have experience using Matillion prior to implementation which obviously helped. However, once the server was setup with the appropriate security groups to access data sources, building the Matillion jobs was straight forward and the UI …
Continue reading

Time to Value

Proof of concept took a couple of weeks. Getting access to private SQL databases was a little fiddly as we needed to install some drivers which we would have expected to be installed as default, but once up and running, we have had no issues. Tweaking firewalls settings to allow Matillion access …
Continue reading

Time Saved

Reports that took approximately 3 hours to pull together and performed on a manual monthly basis were handled automatically and daily in a matter of minutes. These manual reports were pivots in Excel and were pushing Excel to its limit (Excel would freeze). There was a lot of data being shifted …
Continue reading

Cost Savings

As it was automating a manual process, the savings were more in terms of saving resource. Automating has also opened up the report to more internal users.
Continue reading

Business Outcomes

We are able to connect our bespoke systems and third party systems. One that proved quite difficult was the Xero connector. Although hooking up with Matillion was straightforward, the data Xero connector was not provided the data we needed so are looking at our ETLs for this this specific issue.
Mor…
Continue reading

Onboarding

The project has been stop and start over a couple of years. We moved from AWS Matillion to Azure Matillion but it is now stable and pulling various sources in reliably. Setting up success/failure notifications has been key.
Continue reading

Time to Value

I watched training and example videos/seminars for about two weeks before getting an instance set up for the company. And from there, I had a usable workflow going within another week.
Continue reading

Time Saved

Yes, Matillion allowed for daily schedules to provide updated data for reporting at the same time each morning. It also removed any need for manual data updates.
Continue reading

Business Outcomes

Yes, Matillion allowed for connections to all SQL based data sources via JDBC, all files from FTP sites, and all REST API sources. It simplified all of the different data pipelines and allowed for more interaction between them.
Continue reading

Time to Value

Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running …
Continue reading

Time Saved

Yes, there were absoultely increased in reporting speed that our team was able to delivery. Intially we had our own scripting tool to generate result which took 2 weeks (around 80 hours of development time + testing time) whereas using matillion we were able to complete the development in 32-40 …
Continue reading

Cost Savings

While moving away from legacy system towards matillion it offered some significant cost on matillion hosting and licensing part but we were able to save some on legacy system hosting but majority of saving where on people resource which was huge cost saver for our organization. along with that …
Continue reading

Business Outcomes

Our organization work in digital marketing industry and matillion do provides lots of connector related to digital marketers. Matillion was able to solve 90% of our data sources connection problem but there were few of the rarer sources which matillion din't provide the connection to. Hopefully …
Continue reading

Onboarding

Our team member had already the knowledge of other ETL tool in market which made us easier to transform to Matillion as ETL tool. Initally when there were more rigrous update on tool, it took us few months to understand all the different features of the product and use them. We used to reach out …
Continue reading

Time to Value

We were able to get up and running with Matillion within a month. With no real training in the tool, we were able to develop useful jobs and an entire job framework on Matillion within that month. As we got more familiar with it, within three months, we were able to take advantage of additional …
Continue reading

Time to Value

From the moment we bought it on AWS marketplace to connecting to our monolith database it took a matter of hours. Deciding the Redshift table structure we needed for storage actually took longer than the actual setup time! That is a definite plus for anyone who wants to get up an running as soon …
Continue reading

Time to Value

To migrate an existing ETL solution from an old product to Matillion, will require a compete rework with some redesign. Estimate depends on the complexity required. Would estimate anywhere between 3-9 months.
Continue reading

Time to Value

Within 2-3 weeks from starting Matillion, we had our first simple pipeline in production: extracting data from our operational database and putting it into data warehouse.
Continue reading

Time to Value

Our initial POC demonstrated that migrating to Matillion was the logical next step for our organization. Our expectation had been six months to migrate our production loads from legacy tooling to Matillion. We were able to migrate complex production workflows, validate the result, and promote the …
Continue reading

Time to Value

About 1 week which included hands on and looking at online documentation. Part of the delay was just getting access to internal company data.
Continue reading

Time to Value

Used the trial edition initially and was able to set up an ETL process for production, which then started populating real reports in 6 weeks. Previous process was quite manual, a combination of Alteryx and Excel which took a lot of time.
Continue reading

Time to Value

Took 1 day to deploy, get logged in, and connect to Redshift.

Took 1 month to make it useful in production, and 9 months in, I'm still learning features and quirks of Matillion.
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

(26-50 of 124)
Companies can't remove reviews or game the system. Here's why
March 14, 2023

Matillion - Robust ETL tool

Vinod Kumar C | TrustRadius Reviewer
Vinod Kumar C
Technical Systems Analyst
Juniper Networks (Telecommunications, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Usability
10
The quick turn around time to build new Integrations with minimum to no-code usage is very much helpful in delivering our deliverables.
The ability to re-use an existing Orchestration flow by using the Shared jobs is another good feature to build the Integrations very quickly and easily.
March 08, 2023

Low Code and Python component review

JS
Jason Schwartz
Programmer Analyst
BISSELL (Consumer Goods, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
Matillion provides an abundance of low code features, especially for SQL that can simplify what a component does (vs just using a plain sql script component). The API components aren't as fluid, and in my opinion, is better suited with python. I can't blame Matillion on this one as so many rules and parameters need to be accounted for.
March 08, 2023

Matillion - easy to use ETL tool

Trupal Patel | TrustRadius Reviewer
Trupal Patel
Senior Software Engineer
Autodesk (Computer Software, 10,001+ employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
One of the key strengths of Matillion is its user-friendly interface, which allows non-technical users to easily set up data integrations and transformations. The platform supports a wide range of data sources, including cloud-based databases, file systems, and APIs, making it an excellent choice for organizations that need to work with data from multiple sources.
September 21, 2022

Matillion, a nice ETL tool.

Verified User
Analyst in Information Technology
Computer Software Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Usability
10
I really like how simple it is to do workflows on Matillion and their really detailed documentation where you can easily find how to do what you need in your projects. They also have a really nice connection with different data sources, which makes their solution very trustable and complete to all our requirements.
April 18, 2022

Build your own customized version of a Stitch and FiveTran-like data replication process, but better, faster and able to evolve with your needs

Jay Archer | TrustRadius Reviewer
Jay Archer
Manager of Data, Reporting, and Analytics
ReCharge Payments (Internet, 51-200 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Usability
9
I would like to give it a 9.5 or so. Only a few aspects of the usability need some work. These are trivial things to fix, but really annoying to an experienced user.
November 06, 2021

Most flexible and user-friendly ELT platform to support a modern data stack

Verified User
Engineer in Engineering
Restaurants Company, 501-1000 employees
Score 10 out of 10
Vetted Review
Verified User
Usability
10
I was able to get up and running with Matillion in 1-2 hours with a simple job my first time using it. It's pretty intuitive and straightforward. No YAML's, config files, local installations, reading of complex documentation, or understanding of unique open-source frameworks.
August 02, 2021

Data Integration and transformation platform

Austin Lee | TrustRadius Reviewer
Austin Lee
Data Scientist
Saggezza (Information Technology & Services, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Usability
10
It has given us excellent services and lead to the growth of our organization. Our organization departments usually get an opportunity to work on data that is secure and make informed decisions. In overall data, Matillion has been very effective in data management. Distribution of data across our organization and effective storage for referencing has contributed to excellent data handling.
July 09, 2021

Matillion Review

Verified User
Employee in Information Technology
Computer Software Company, 11-50 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
9
It's easy to understand how the flow works and all the features provided by the tool. You also can find some information on their website or Youtube channel.
July 08, 2021

Ease and complete tool, I would suggest it!

Verified User
Consultant in Information Technology
Information Technology & Services Company, 501-1000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
It is good. Matillion is easy to use, the connection is web-based, fast, and always works. The "search" into each object simplifies the construction of transformations and joins. The SQL is always retrievable from jobs, therefore the debug phase is also easy to analyze. Moreover, in case of need, you can also write your own SQL into the appropriate object.
July 02, 2021

Building a data warehouse from the ground up with Matillion

Verified User
Engineer in Other
Financial Services Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
8
I find Matillion very intuitive and quickly got to grips with it. I have found that developers with a more purist coding background have struggled to get to grips with it more, particularly in relation to managing variables. For me personally, this has not been an issue and the online documentation has been excellent in digging deeper into specific functional areas
June 30, 2021

Visual ELT at its best

Verified User
C-Level Executive in Information Technology
Insurance Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
9
Works well for people that like to visualize things, as each job and transformation is displayed on a graphical interface. A job or transformation can be a large set of tasks or can be broken down into individual ones so that diagrams do not get too complicated and out of hand.
June 29, 2021

Easy to implement and scale

Verified User
Consultant in Information Technology
Information Technology & Services Company, 11-50 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Usability
7
It is generally user friendly in terms of the various tools, but I think there is room for improvement in terms of seeking support or examples from other users.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Sudarshan Kothari
Lead Analyst
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
9
Matillion providing underline features of the database and unique functionality in connectors, increase our day-to-day work solution using the tool. For example, Snowflake database supports for JSON file system and thus using Matillion with Snowflake offers to flatten as an additional component is exceptional. Another example: Data could relive under FTP, sFTP, Cloud system (S3), databases and matillion have support to all, thus increasing the usability.
November 30, 2020

Ease of Use and Reusability for Excellent ROI

MB
Matthew Burr
Sr. Data Engineer
HireVue (Information Technology and Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Usability
10
It's very easy to use because of its graphical nature. Ultimately, it is a wrapper for activities you could do using SQL, Python, and AWS services, and by presenting those activities in a simple interface it makes it easier to perform them without having to worry about a lot of extraneous details.
Return to navigation