Easy to implement and scale
Updated June 29, 2021

Easy to implement and scale

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

Overall Satisfaction with Matillion

We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across the whole organization. We use Matillion to automate the ingestion and transformation of data pipelines. We utilize Snowflake as a data warehouse, so we use Matillion as the tool to load data into the Snowflake database.
  • Automation and scheduling
  • Security and authorization
  • Ease of use
  • API Calls using python
  • More community support and forums
  • Allows for custom data refresh schedules
  • Requires little maintenance or support from the team
  • Affordable and scalable ETL solution
It is generally user friendly in terms of the various tools, but I think there is room for improvement in terms of seeking support or examples from other users.
I watched training and example videos/seminars for about two weeks before getting an instance set up for the company. And from there, I had a usable workflow going within another week.
Matillion easily integrates with Snowflake which is a huge selling point. It is also affordable fro the amount of data source connections that it comes with.
Matillion works well if the data sources are coming from common applications or databases.

Matillion Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
7
Simple transformations
9
Complex transformations
6
Business rules and workflow
7
Collaboration
6
Testing and debugging
5

Evaluating Matillion's Business Outcomes

Yes, Matillion allowed for daily schedules to provide updated data for reporting at the same time each morning. It also removed any need for manual data updates.
Yes, Matillion allowed for connections to all SQL based data sources via JDBC, all files from FTP sites, and all REST API sources. It simplified all of the different data pipelines and allowed for more interaction between them.