Visual ELT at its best
Updated June 30, 2021
Visual ELT at its best
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Used by developers and business analysts in the IT department to extract and transform data into our Snowflake data warehouse. We have different data sources after a company merger and needed combined reporting. We also needed to pull data from third-party data sources such as Xero, Google Analytics, and so on.
- Breaks jobs down
- Graphics Interface
- Has lots of AWS documentation but not as much Azure.
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
- Essential in rolling out our data warehouse strategy.
Proof of concept took a couple of weeks. Getting access to private SQL databases was a little fiddly as we needed to install some drivers which we would have expected to be installed as default, but once up and running, we have had no issues. Tweaking firewalls settings to allow Matillion access took a while.
Matillion Feature Ratings
Evaluating Matillion's Business Outcomes
Reports that took approximately 3 hours to pull together and performed on a manual monthly basis were handled automatically and daily in a matter of minutes. These manual reports were pivots in Excel and were pushing Excel to its limit (Excel would freeze). There was a lot of data being shifted and transformed.
As it was automating a manual process, the savings were more in terms of saving resource. Automating has also opened up the report to more internal users.
We are able to connect our bespoke systems and third party systems. One that proved quite difficult was the Xero connector. Although hooking up with Matillion was straightforward, the data Xero connector was not provided the data we needed so are looking at our ETLs for this this specific issue.
More data used in reporting has streamlined various financial reports and improved company KPIs
More data used in reporting has streamlined various financial reports and improved company KPIs
The project has been stop and start over a couple of years. We moved from AWS Matillion to Azure Matillion but it is now stable and pulling various sources in reliably. Setting up success/failure notifications has been key.