Item: Matillion
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

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.

Pros and Cons

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

Key Insights

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

Return on Investment

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.

Usability

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.

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.

Scalability

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.

Likelihood to Recommend

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.

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

Overall Satisfaction with Matillion