Visual ELT at its best
Updated June 30, 2021

Visual ELT at its best

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

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.
Works well for people that like to visualize things, as each job and transformation is displayed on a graphical interface. A job or transformation can be a large set of tasks or can be broken down into individual ones so that diagrams do not get too complicated and out of hand.
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.
Seems to working well and we are now look to upgrade to a higher plan
Prefer Matillion's visuals in terms of viewing jobs. We may end up using both Matillion and Fivetran
Matillion is very well suited to connecting to online data sources, as it has an array of connectors that are already set up with third parties. It is easy to get started and can be hosted in AWS or Azure. You only get charged per hour so it is cost-effective if set up correctly.

Matillion Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
9
Complex transformations
9
Business rules and workflow
9
Collaboration
5
Testing and debugging
7

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