Matillion: the last puzzle piece in modern analytical solutions
Updated September 03, 2020

Matillion: the last puzzle piece in modern analytical solutions

Aleksa Topalović | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Within the Business Analytics team, Matillion was introduced as a new ELT tool after team extension. In that time, we had four active BI developers and the main need was a centralized project repository that will make the daily workload easier. We are using Matillion for development and maintenance of the data warehouse and integration of more than 20 data sources.
  • Tailor-made for Redshift, including most of the features like Spectrum.
  • Cloud-based solution with centralized project repository, easy team collaboration.
  • Built-in scheduling and monitoring, everything in one place.
  • Awesome support, the short time from raising a question to the solution providing.
  • Documentation is not always updated in time when new stuff is implemented.
  • Some connectors already implemented still have some bugs which make them useless for our use case.
  • Small fine tuning still missing, in terms of covering all use cases of some connectors.
  • Shorter time to market. Development from a month decreased to two weeks including testing.
  • Developers are more focused (>80% of the time) on a specific topic instead of searching for different technical solutions.
I'm really satisfied with the whole Matillion/AWS/Redshift environment. For me, it was easy to switch to an ELT approach and to rebuild all jobs. After just two months, I felt familiar with the tool itself and built some complex stuff really fast. I measured my experience, and after working with different enterprise BI tools, I can say that Matillion is really user-friendly and useful for many business cases.
After just two months we had complex processes running on a production environment. And now after six months, we became really proficient users of Matillion which are also taking care of optimization improvements and not just a development.
Before the ETL tool we made the decision to stick to Redshift as a database. Compared to listed products (that I used) I would say that the decision was easy if we consider the sync with AWS and Redshift, cloud-based solution, team collaboration, built-in scheduling, and monitoring.
If you are in a situation that includes Redshift, a whole AWS platform and developing modern analytical solutions, Matillion is the tool that could improve your whole platform. Instead of writing complex scripts you have possibilities to design the whole process that is also understandable for business users also at the first look - implementing business logic is faster. Using the power of the Redshift you have an impression of instantly doing a job. Matillion also covers some other use cases like processing and integrating unstructured data so that all business needs could be satisfied. At the end synchronization with other tools also works fine so the whole BI process from data to insights is shorter.

Matillion Feature Ratings

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

Using Matillion

5 - DWH & BI Engineers

Matillion Support

For most of users support can provide needed help. And it is always in a really short time frame.
In some really advanced cases there was necessary to include highly tech people and there was a lot of back and forth.
Because I have a case that is not resolved for more than a year and the bug is based on initial bad implementation (Google AdManager component) I would suggest that sometimes don't rush to publish something that is not ready.
ProsCons
Quick Resolution
Problems get solved
Kept well informed
Immediate help available
Support understands my problem
Quick Initial Response
Poor followup
Yes - Yes. Sometimes I found bugs but in some of next releases it was fixed. Also most of them were not listed in release bug fixes section.
And one bug is still open for more than a year. Even though we agreed that they implemented that API wrongly somehow it is not prio for development team and it was communicated like support team can't influence/track progress on development.
Multiple times! Not needed to elaborate in detail but at the beginning when support was really needed, Matillion provided it.

Using Matillion

ProsCons
Like to use
Relatively simple
Easy to use
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • Concurrency
  • Deployment
  • Debugging
  • Python integration
  • Some data-source integrations