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
Review Source

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?

Yes

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

Yes

Did implementation of Matillion go as expected?

Yes

Would you buy Matillion again?

Yes

  • 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.
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.
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
10
Connecto to Big Data and NoSQL
10
Simple transformations
10
Complex transformations
10
Business rules and workflow
10
Collaboration
10
Testing and debugging
10