April 20, 2019


Mark Grace | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Matillion is used by the BI team as our ELT tool. It's not used by the rest of the organization, but they get the benefits.
It helps us keep logic all in one place, and is a foundation piece of our data pipeline. It also allows us to quickly work with data and get it into the format required for data purposes.
  • Speed to connect to data sources; the power of ELT tools is in pre-built integrations.
  • Support services are excellent and very quick to respond
  • My devs enjoy using it. It has an easy simple GUI and allows for repeatable processes.
  • It's very hard to version control out of your system. If I connect to Git it's impossible to tell the changes that we have made. It's the same for most GUI tools, but I would love to solve that.
  • Documentation is sometimes slow to keep pace with the changes in the tool, meaning confusion or lost time.
  • It's not clear what integrations are coming next.
  • Changing things across multiple workflows is quite involved and doesn't easily allow us to make changes across our entire ELT section.
  • We had to build all logging ourselves. Matillion tells us easily that a job failed, but it's hard to extract in an automated way why it failed.
  • Increased speed to insight
  • reduced amount of time spent on managing logic
  • Add robustness and repeatability into data pipeline
It does what you expect it to do, it's great, well priced and you can achieve good results with it. Not hard to implment
Fairly quick, Matillion was not our bottleneck. The learning curve was still a point that our developers had to overcome so anything more you can do ere to help that would be best. Also would have been brilliant for someone to share best practice, talk-through the set-up and how to leverage it. What things to avoid etc!
Very scalable for simple tasks but not sure of the more difficult use cases as I said before. I'm not sure we'd still use MAtillion if we had much more complex interdependent data processes. It's great for our starting point, we were basically using nothing beforehand, apart from Stored procedures!
It's a GUI so we don't live just in the code in AWS. For what we neede alteryx wouldn't be best suited. altough as we move to more analytics focussed team it's something i will look at again.
I think it's great for lightweight ELT processes. If we got super complex and starting running loads of heavy processes then I think I would need something more robust.
I don't know if it will handle real-time use cases. Right now we live in the batch world so it's safe and easy to use Matillion for that

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Not Rated
Integration with MDM tools
Not Rated