Matillion powers our BI stack
October 10, 2025

Matillion powers our BI stack

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

Overall Satisfaction with Matillion

As a digital company we do have several different B2B and B2C systems. Mostly their data is about the same but as anywhere else, nothing is unified. We use Matillion in order to load all of the different source systems and transform and unify the data. It fully empowers our DWH based on AWS redshift.

Pros

  • Using different type of sources
  • Simplify SQL statements by providing an nice UI
  • Team collaboration between the data engineers

Cons

  • Template system
  • Data inspection playground
  • Speeding up the process of having data available in the DWH
  • Transparent overview for everyone what happens during the DWH build
Yes, in all of the mentioned points. However, this is highly dependent on the general setup in which Matillion is used. We do have rules how to work with Matillion as it allows a lot of freedom - without, chance is high to end up in chaos.
We finally managed to have a working DWH - it gives a nice overview about our scattered IT landscape.
By giving full transparency. We love the freedom and after working several years with Matillion is clear to everyone what to do and what not to do. As we do allow read only access for non data engineers, every process is clear to everyone.
Stakeholders are not directly impacted as we do use Tableau on top of the DWH. This is the main entry point for stakeholders.
Well, everyone is able to write and understand SQL in the team. However, by having the no-code structure (especially when used to it) speeds up everything. Changes are a lot easier to do. The downsite is the complex SQL outcome which isnt ideally every time - however, by using Redshift we dont care much about that one as its efficient.

Do you think Matillion delivers good value for the price?

Yes

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

No

Did implementation of Matillion go as expected?

Yes

Would you buy Matillion again?

Yes

An overwhelming system landscape with different types of databases and APIs to deal with. For generating complex SQL statements and having them nicely displayed to a full overview.

Matillion Feature Ratings

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

Comments

More Reviews of Matillion