My experience with Matillion over the past couple of years!!
September 08, 2020

My experience with Matillion over the past couple of years!!

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

Overall Satisfaction with Matillion

Here at ReportGarden, we use Matillion to fetch data from multiple databases and construct a compact and easily referable database using various data blending techniques with the help of various blocks like Python script, SQL, joins, etc. We use the combination of SNS and Lambda to make sure tasks run seamlessly every day and to stop EC2 instances once tasks are done, which is of great use in saving unnecessary costs.
  • UI is very simple to understand and documentation complements it very well.
  • Able to mail logs for processed and errors in daily tasks.
  • Having a detailed log of daily tasks maintained in the UI is a good addition.
  • Slightly over priced for a startup.
  • I feel support is a bit slow.
  • Not all the libraries are installed in Python, would be easier if we could install them from the user side.
  • Streamline major insights for client trends.
  • Backbone of all data analytics.
  • Not much of a negative impact.
It is for sure a good ETL tool that is ready to use without much deployment need. Matillion is getting better by adding more and more features.
Almost everything is up and running, one needs to figure out Lambda and SNS stuff to maintain scheduled tasks.
It is pretty scalable, you just need to weigh the run speed of your task verses cost when you scale-up the machine.
If you choose the Pentaho community edition, you need to take care of all deployment, server costs, etc.
I'm not sure how much an Enterprise Pentaho Edition costs though. In the case of Matillion, deployment is handled seamlessly, so it makes it ready to use. At the same time, you might feel there are good features missing in Matillion compared to Pentaho.
It would suggest Matillion for any medium level startup that is dealing with huge data and multiple sources of data, as it is easier to pull and push from/to multiple databases. Matillion might be a costly solution for early startups in my opinion, but if you are a huge data-based company, I would suggest you check out Matillion.

Matillion Feature Ratings

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