Matillion: flexible and complex
October 01, 2020

Matillion: flexible and complex

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

Overall Satisfaction with Matillion

We use it as an ETL tool to process data from Redshift and other software, create tables in Redshift, and transform data as it goes.
  • Fairly customizable: can piece together components like Legos.
  • Responsive support and good standard documentation.
  • Deployment, upgrades, and migration are very smooth.
  • Many connectors, APIs, python scripting.
  • Bugs in Zuora API; no SFDC push component.
  • Few “best practices” like Legos without instructions.
  • Next to no information in "google land" or stack exchange on gotchas or tips. Too much help in video form and not enough searchable text.
  • Pay AWS and Matillion by the hour.
  • Allowed us to replace an ancient tool (pentaho) and move forward into the new era.
  • Quick deployment and smooth upgrades make us look good to our customers.
It's a mixed bag of usability: takes some getting used to, learning curve (not sure why some components can be used in "transformation jobs" but not "orchestration jobs" ?) but once you understand it, it's fairly usable.
Took 1 day to deploy, get logged in, and connect to Redshift.

Took 1 month to make it useful in production, and 9 months in, I'm still learning features and quirks of Matillion.
I didn't do the compare or eval, tool was chosen before I was hired.
Good for highly customizable jobs, takes some learning curve but then very flexible.

Less appropriate: the Zuora API has some issues and we had to build the data pull from a bunch of basic API components instead of the proper highlevel one.

Matillion Feature Ratings

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