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.
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
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!
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.