Matillion ETL - excellent cloud based data tool
October 01, 2020

Matillion ETL - excellent cloud based data tool

James Hull | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Matillion is our ETL tool to populate our data warehouse running in Google BigQuery. In conjunction with Google Data Studio, we have a daily process used across the whole business with up to date financial, commercial and project data. It is managed by the Technology Team but the whole business sees the results.
  • User friendly.
  • Build complex workflows visually.
  • Support is good.
  • Easier email integration to mail out results.
  • Version control of jobs.
  • Ability to use external APIs to push data not just pull.
  • Saved time in report production - from 2 weeks to automatic in minutes.
  • increased quantity of reports available to the business.
  • Allowed production of external MI to be automated.
Very visual, drag and drop etc but still some complexity there. Some of the structure is not entirely obvious (e.g. projects, environments etc) so it might not be being used as effectively as possible.
Used the trial edition initially and was able to set up an ETL process for production, which then started populating real reports in 6 weeks. Previous process was quite manual, a combination of Alteryx and Excel which took a lot of time.
Well suited - Gathering data from multiple sources to store in a central repository.

Less suited - Pushing output other than CSV or writing to tables.

Matillion Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
10
Complex transformations
8
Business rules and workflow
4
Collaboration
2
Testing and debugging
3