Easy to use and recommended for existing ETL developers
October 05, 2020

Easy to use and recommended for existing ETL developers

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

Overall Satisfaction with Matillion

Matillion was used in order to create a Redshift Data warehouse solution. Where the Data warehouse followed the Inmon module and on top of that is a Data mart with multiple aggregations.
It was the product of choice for BI needing to move from an old ETL tool and DB.
  • Ease of use.
  • Multiple source feeds.
  • Very good integration with Redshift.
  • Provides a lot of flexibility with Python scripting.
  • Target should always be Redshift or it gets complicated.
  • Python scripts not in Jython don't comply with commit/rollback blocks.
  • Excel input component is too slow and you are better off processing it in Python.
  • The pricing increased dramatically by 30% with short notice. This obviously hurt the OPEX.
It is easy to use and provides a lot of connections, components and ability to adjust things such as API profiles.
To migrate an existing ETL solution from an old product to Matillion, will require a compete rework with some redesign.
Estimate depends on the complexity required. Would estimate anywhere between 3-9 months.
The EC2 instance size determines the licensing costs and in our case we found it to be stable but not overall scalable.
It is well suited for anyone needing to create a BI (ETL/ELT) solution on Redshift.
It is very easy to use and provides a lot of components similar to other ETL tools.
Please note all processing is pushed down to the DB (think ELT).
The only downside is some of the under the hood logic is sometimes not acting in the documented/desired fashion, requiring workarounds.

Matillion Feature Ratings

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