My experience with Matillion over the past couple of years!!
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.
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.
- Streamline major insights for client trends.
- Backbone of all data analytics.
- Not much of a negative impact.
Almost everything is up and running, one needs to figure out Lambda and SNS stuff to maintain scheduled tasks.
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.
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.
Comments
Please log in to join the conversation