Item: Matillion
Rating: 7
Author: Viswanath Manne

Overall Satisfaction with Matillion

Use Cases and Deployment Scope

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.

Pros and Cons

Pros

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.

Cons

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.

Return on Investment

Streamline major insights for client trends.
Backbone of all data analytics.
Not much of a negative impact.

Usability

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.

Time to Value

Almost everything is up and running, one needs to figure out Lambda and SNS stuff to maintain scheduled tasks.

Scalability

It is pretty scalable, you just need to weigh the run speed of your task verses cost when you scale-up the machine.

Alternatives Considered

Pentaho

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.

Likelihood to Recommend

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

Comments

Please log in to join the conversation

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