Simple and powerful data aggregation tool
August 26, 2020

Simple and powerful data aggregation tool

Andy Lai | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

I use Matillion for one project. I use Matillion to solve my data loading issue because Matillion supports many data sources. I use this to aggregate all the data sources to my data warehouse. Before using Matillion, I needed to write my own data loader, which was very time consuming and created a lot of stability issues. By using Matillion, I can load my data within an hour to my warehouse.
  • Quick to set up
  • Tailor-made for data warehouses (Bigquery, Snowflake, Redshift)
  • Graphical UI to connect all the modules
  • Easy to learn
  • Customer response time needs improving
  • SAAS model instead of charging hourly
  • Lack of documentation
  • Versioning logs not updated
  • Shorten the development time
  • Focus on data only
Matillion has a graphical user-friendly interface, you can drag and drop to control the details of the component and connect to others. The version stays updated and you can easily update to the latest version. It provides an easy way to set up from the cloud marketplace. It is easy to schedule jobs.
It took me about a few days to study those advanced features, due to not much community support, but I still was able to get support from Matillion. For those standard features, you can run it maybe within a few hours.
Because Matillion uses instances to run the service, I think in terms of scalability, it should be within computing power only (CPU power). This is in comparison to those services that run serverless, which you don't need to worry about the CPU usage.
It has a drag-&-drop graphical UI, which makes it easy to connect all the components together. It's very fast to set up from cloud marketplace. It supports many data sources and it also provides a customizable data source component.
Matillion is suitable for a use case that needs to support multiple data sources or where you have much data to load into the data warehouse. It is not suitable for a budget-tied project, as it is quite costly if you just deploy it to use it as a data loader.

Matillion Feature Ratings

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