Most flexible and user-friendly ELT platform to support a modern data stack
November 06, 2021

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

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Matillion is helping resolve use-cases related to transparent orchestration workflows. These workflows often involve custom Python, SQL, staging locations, and sending data to external systems such as Salesforce and cross-channel marketing platforms all in one workflow. When FiveTran & DBT don't meet our exact requirements and use-case, we use Matillion to help resolve these use-cases in an easily understandable workflow that technical users, new engineers, or non-technical users can understand/troubleshoot.
  • Extremely user-friendly workflow orchestration between multiple languages such as SQL, Python, bash, and various API connectors
  • Salesforce connectors to pull and push data between systems save us a ton of time
  • Matillion Exchange workflows allow for easy sharing of templated best practice transformation jobs with ease
  • Very responsive support
  • GIT Functionality needs works, has unnecessary steps and needs "GIT DIFF"
  • A cloud hosted version would help resolve a lot of issues
  • Serverless solutions for scaling up storage and compute for certain jobs in Matillion if we wanted to run data science workflows

Do you think Matillion delivers good value for the price?


Are you happy with Matillion's feature set?


Did Matillion live up to sales and marketing promises?


Did implementation of Matillion go as expected?


Would you buy Matillion again?


  • Saving us time reduces our need for headcount
  • Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity
  • Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why
  • Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc.
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.
Overall I think Matillion is very flexible and scalable. The only thing Matillion could improve on is a serverless backend to handle heavy compute workflows rather than an EC2 instance. At that point, I feel it's basically the SNOWFLAKE of ELT tools.
If your company has ever had issues with un-transparent data pipelines, difficulty understanding orchestration of workflows, and issues with data engineering retention and ramp-up, then Matillion is likely the right solution for you. It doesn't require heavy technical skills, just a strong understanding of Data-Eng Concepts. It's low-code/no-code optionality allows for everyone to come in and quickly understand how jobs are interconnected without having to cross navigate multiple systems for connectors, transformations, loads, and logging. It's an all-in-one solution that complements more specialized solutions like Fivetran and Hightouch. You can even set up python connections to orchestrate Fivetran and Hightouch into a Matillion workflow.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Business rules and workflow
Testing and debugging