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

I have installed Matillion from the start. To deploy it in Google platform it took me 2 weeks of time as I was very new to the tool. Once the instance is available, to create project, GCP credentials and GIT setup, it may take a day. Finally creating a sample pipeline and to test it will be a …
Continue reading

Time to Value

It took us around one week to understand the tool. The primary time was spent understanding how to configure variables and connect to different sources. Creating a reusable template and then using it in other workflows is initially a bit complex. In a week, we became more comfortable with the …
Continue reading

Time to Value

I managed to install into Azure in a single day.

I watched a few YouTube videos (which I would like to see more of) and managed to create less complex ELT transfers in a single day.

Snowflake connection was a little more complex than it could be....and variable handling takes a while to grasp …
Continue reading

Time to Value

Our initial build was METL (older version of Matillion). This meant we had to create an EC2 instance on AWS. This initial setup took maybe a few days. but once we spun up the mahine and got it all working, we connected Matillion to our data warehouse in a matter of minutes. The new DPC Matillion …
Continue reading

Time to Value

It took just a few hours to get set up with Matillion. Only in cases where we had to connect to data sources, in some cases, it took time as third parties had to white-list the IP address for Matillion to allow the connection. Overall setting up the instance, and setting up environment variables …
Continue reading

Time to Value

At the beginning of the ETL CDC process, it took us several working sessions with the teams to get all of the different components constructed in AWS, and then to find out it didn't meet our needs was a bit disappointing. With the CDC in Data Loader, though, we were up and running in a couple of …
Continue reading

Time to Value

It took us approximately 2 months to develop our data flows. The migration process from existing flows proved to be challenging and time-consuming due to the complexity of our workflows. Although building proof of concepts (POCs) was a quick and easy task, the transition to a production …
Continue reading

Time to Value

Not much time, as I already had previous experiece using ETL tools, and Matillion is by far was the easiest and more user/developer friendly
Continue reading

Time to Value

IT took us a few weeks to get it deployed in a secure environment and get the Single Sign On working with it. After it was deployed correctly, it took no time at all to write the first transformation and get it scheduled. It is a very easy to use application.
Continue reading

Time to Value

Our POC with Matillion went well, everything we testing paid off dividends. From the POC we have moved quickly to implementation and are working with support specialists to make sure that we get full use of the product. Implementation timeline for us has been approximately 4 months, with one of …
Continue reading

Time to Value

We were able to implement Matillion for our development environment in about a weeks time. There was some learning involved but the application was implemented within a weeks time. It took us about 2 more weeks to build some standards around and understanding how to use Matillion as an enterprise …
Continue reading

Time to Value

Its quite easy to learn Matillion and start implementing the use cases. we were able to implement medium level business use cases within 1 week with all complex logic and standard practices. The data were loaded in first run only with no errors and the time taken to load the data was also less.
Continue reading

Time to Value

I wasnt involved with tht implementation however i was able to learn how to fix issues and make changes within a day or two of exposure to the system. However i imagine this could have been longer if the pipelines had been more complex or we had lots more of them. I feel our usage probably wasnt …
Continue reading

Time to Value

It took me about two weeks of exploring pipelines that had already been built before I was comfortable to start writing my own. My first few pipelines used very few of the matillion transformation components and a matillion low code style. Instead I did a lot of raw SQL and python components to …
Continue reading

Time to Value

We were up and running within 2 weeks of procuring the Matillion ETL.
The very first integrations we started were that of Salesforce and that was both inbound from Salesforce and outbound to Salesforce. We were able to build 5 to 6 such Outbound integrations within a month.
And then there were …
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.5
    65%
  • 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…

Dataloader.io

Dataloader.io

$99
per month
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 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

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

Experience the ETL with Matillion

Verified User
Team Lead in Engineering
Consumer Services Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for building simple and complex pipelines. If you are a developer, it is a really great choice to look at sample data previews and detailed logs. It can understand the tasks with minimal configurations. One can easily import or export tasks and can code independently without affecting others work with 'manage version' option. Git configuration and Matillion APIs also available
March 25, 2024

Matillion for cloud data integration.

Verified User
Engineer in Information Technology
Utilities Company, 501-1000 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is very well suited for ETL on the cloud. Whenever there is something that can be accomplished with no code or little code, Matillion is a good tool. However, if your pipeline requires a lot of customizations, Matillion should be avoided.
March 20, 2024

Matillion enables us to manage all ETL/ELT processes without any dedicated data engineering resources.

Verified User
Team Lead in Information Technology
Health, Wellness and Fitness Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Our team consists of analytical and technical-minded people who do not have a deep background in data engineering. Matillion enables us to manage all ETL/ELT jobs independently without dedicated engineering resources.
March 19, 2024

Matillion - Decent

Verified User
Manager in Finance and Accounting
Information Services Company, 51-200 employees
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for the non-technical data user, because it has out of the box third party API integrations. It is well suited for scheduling daily jobs to run. It is less appropriate when you want to store your ETL code in an environment that has version control and QA sign-off
March 18, 2024

Matilion helped grow my business

GD
Gary Drew
Group CTO
nGAGE Talent (Computer Software, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Very flexible and scaleable to a point but I wonder if there are limits with larger data sets and a higher number of data sources. We are a technical team but less technical people may prefer a more wizard-based approach. Splitting out billing across multiple clients doesn't look possible. (Snowflake can do this)
March 13, 2024

Low-code solution to transforming data at the speed of thought

Callum O'Connor | TrustRadius Reviewer
Callum O'Connor
Analytics Engineer
Adaptavist (Computer Software, 501-1000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion lowers the bar for entry into the world of data transformation. it's low-code design, simple drag'n'drop visualisation and SQL code generator makes data transformation easy and educational for those starting off in the world of data. For refactoring, we’re able to take existing complex SQL models, re-create and visualise them in Matillion, change the design, then use the SQL output from Matillion to create new data models in our repos.
Matillion has completely changed the way we serve data to our internal customers at the company; we've exported capability and empowerment rather than allowing ourselves to get swamped with tickets and requests for every possible data question. It's a great tool for getting people to self-serve their own answers to questions about their data.
February 07, 2024

All That You Need in Your Daily ETL Work

Verified User
Professional in Information Technology
Internet Company, 5001-10,000 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion provides a very intuitive way of handling all types of ETL processes. There are tons of built-in components for data sources, such as Google products, where Sheets is a great example that we use for manual data input. And with ease, you can set up API query/extract profiles to get data from all types of API.
February 07, 2024

Matillion Review

Verified User
Vice-President in Engineering
Insurance Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It is well suited for direct data transfer from source to destination. Emailing success/failures of jobs is a bit complicated. Also, upgrades are quite frequent which do take time and testing and setting up backup instances. We always have to remember to keep the backup instance off and remember to delete it after the upgraded version has been tested.
February 07, 2024

Replication with Matillion Saves Time

Matthew Belo | TrustRadius Reviewer
Matthew Belo
Senior Architect
Engage3 powered by Dexi (Retail, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
The current evolution of their CDC offering is where it should have been in the first place. That offering provides replication direction from the PG database to SF without any intermediate steps. The previous version had too many steps: ready from PG, write to S3, run ETL to push to SF, and there were opportunities for missed transactions. Where they need to grow for us is to allow end-to-end replication from PG-to-PG, SF-to-PG, and SF-to-SF. Those are handled by competitors, so it would help them close the gap.
January 31, 2024

Use Matillion - Become the no code superman

Verified User
Manager in Information Technology
Marketing & Advertising Company, 11-50 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Strengths:Cloud Processing Efficiency:Matillion's strength in cloud processing aligns well with its design for integration with cloud data platforms. It's optimized for handling large-scale data transformations and processing in cloud environments.Time Savings for Data Engineers:The tool's efficiency and user-friendly features for data engineers contribute to time savings, allowing the team to focus on more strategic and complex tasks rather than spending excessive time on routine ETL processes.Challenges:Slower Excel File Processing:The noted challenge with slower Excel file processing highlights an important consideration. Tools optimized for cloud data processing might face limitations when dealing with certain local or non-cloud file formats.Complexity for Non-Tech Users:The perceived difficulty for non-tech users aligns with the typical trade-off in ETL tools. While Matillion provides a visual interface, the complexity of ETL processes may still present a learning curve for users without a technical background.
September 12, 2023

Simplicity in implementing ETL/ELT

Verified User
Engineer in Information Technology
Retail Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is a very easy to use tool, does not require much experience in the tool to start using it, so juniors and new joiners can start working with it easily.
Matillion has so much components that fits majority of our business needs.
A mising point in Matillion is the metadata to be available in Snowflake.
September 09, 2023

Matillion Helps Build Out Your Datalake

JT
Jonathan Trick
Director, Software Engineering
Finvi (Financial Services, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is great any time ETL or ELT is needed. I've now used Matillion in 2 different companies and would have no problem recommending others to use it as well. The ease of setting up schedules to just take care of data imports and manipulation is incredible. IT has also been an incredible tool at bringing disparate databases together on a schedule so that I never have to think about it.
September 07, 2023

A Necessary tool

Verified User
Director in Other
Education Management Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Performance is nice, but if you need creating a complex pipeline, you required long hours for developing the job can be really expensive, every minute is billed in design phase.

On the other hand. Matillion help us for integrate data sources like netsuite, HubSpot and others.

August 16, 2023

Consider Matillion as an option.

Verified User
Engineer in Information Technology
Mechanical Or Industrial Engineering Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
They are partnering with Snowflake which will be a huge step forward in the Data Engineering space. Downsides getting an agent setup On-Prem wasn't even an option and with other vendors this was easy.
April 14, 2023

Matillion Transforms Data Quickly and is reliant

Verified User
Team Lead in Information Technology
Logistics & Supply Chain Company, 5001-10,000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It does a great job in data transformations with easy to understand and follow steps, if done correctly. It allows you to check data samples within each step and allows to analyze what query is going to be passed down to the engine to cater for performance improvements. Performance of going through millions of rows of data is quite amazing. So far we have had minimal down time and maintenance windows.
April 04, 2023

Matillion is the future

Verified User
Project Manager in Information Technology
Information Technology & Services Company, 1001-5000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is best suited for loading data from various external sources, Matillion is capable of loading data from almost any of the external system. Matillion needs to add some features for and components to implement slowly changing dimensions. Also Matillion can be made more capable of scheduling jobs based on events in addition of time .
April 04, 2023

Great tool. Does a lot of the hard work for you. And lets the engineers focus on the data.

Timothy Doolan | TrustRadius Reviewer
Timothy Doolan
DevOps Engineer
Awaze (Hospitality, 201-500 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's a fantastic ETL platform. Easy to set up and use. I wouldn't use it for small workload or where adhoc ETL is required. But for day to day operations. It has many benefits for medium to large enterprise businesses.
March 28, 2023

Solid ETL tool

Verified User
Manager in Product Management
Entertainment Company, 5001-10,000 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It isbsuited to low or no code environments where you are linking multiple data sources or systems together and want to leverage automation. Especially small teams where resouce is tight and a pool of developers arent available.
It is difficult to justify if you are not required to make changes and are using large scale systems like AWS and have developer resource available as its probably cheaper and easier to do the ETL in glue jobs and make the developers responsible.
March 20, 2023

Great for maintainable production pipelines

Verified User
Employee in Information Technology
Leisure, Travel & Tourism Company, 10,001+ employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Matillion is well suited for teams that need to develop easy and well maintainable pipelines. It is not great for database extraction with cdc. Matillion is great for Snowflake transformation pipelines.
Return to navigation