If you are after an ETL tool that provides for seamless integration and ease of setup and management, go for Matillion
May 14, 2019

If you are after an ETL tool that provides for seamless integration and ease of setup and management, go for Matillion

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

Overall Satisfaction with Matillion

Matillion is being used with Snowflake to address enterprise data warehousing needs and provide for a seamless ETL solution for our data to be processed in Snowflake and generate business ready reports and analytics.
  • Ease of Administration and Management
  • Better visibility over ETL processes
  • Seamless solution with complete integration into Snowflake
  • Authentication methods need to be broader
  • UI for projects could be better
  • Ability to manage it using both AD and local accounts.
  • Helped us speed up ETL processes
  • Helped me with simplifying Metadata management
  • Has helped us in quicker implementation and quick turnaround of data analytics
It is a very straight forward tool setup with all the required features and caters for situations such as S3 buckets requiring data to be encrypted from Matillion when being loaded. It us very easy to setup and very easy to manage.
Matillion offers a variety if instance sizes in AWS for use with Snowflake and hence customers are free to spin up an instance that would fit in with requirements and can be scaled up and down according to requirements. However, I have given it 8 scores out of 10 because in today's world products like this should have capabilities of auto scaling built in where as at the moment it is not there.
Matillion ease of use and feature set along with integration capabilities and built in integrations are definitely a step ahead than the other tools and it provides the ability for us ti integrate with refshift, Snowflake and on premise data sources and hence becomes a versatile tool.
If you are looking for a good ETL solution to use with Snowflake, Matillion fills that gap very nicely.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools