Good for Quick Starts, but can be a bit pricey for small enterprises at scale.
August 14, 2020

Good for Quick Starts, but can be a bit pricey for small enterprises at scale.

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

Overall Satisfaction with Matillion

We use it to take data from many sources and ingest them into our data lake. We then use Matillion to orchestrate transformation jobs on that data to eventually land it in our data warehouse.
  • Variety of connectors
  • Graphical interface
  • Source control integration
  • Some connectors have significant limitations (web services, NetSuite)
  • Runs out of memory easily
  • Logging not easily exportable
  • Cost is okay, but is going up significantly soon. Value proposition is dwindling.
  • It made it easy to get up-and-running as far as getting data into our data lake. Good for a "quick win."
  • Pay-as-you-go model is good for smaller organizations.
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
We were able to get up and running very quickly. This is really Matillion's strength. Once we got past the peculiarities of setting up our environment, we could connect to data sources right away and ingest data into our data lake. Putting on more pieces after that was easy.
That's the beauty of a cloud-based solution, right? We can scale up if needed, although the cost jumps pretty significantly. And we can always add more developer nodes as needed given source control integration.
I did not make the purchase decision, but Data Services has a very high upfront cost and is not cloud-native not *was* Snowflake capable (it may be now). It's a good piece of software though.
It's very well suited for data ingestion. Many connectors and loop components particularly make it easy to grab lots of data in a source system programmatically. Python scripts make it extensible. It's not as good for modern data warehouse ELT - you can use it as a "traffic cop" in those situations - but is it really work so much money per hour at that point?

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