Matillion for cloud data integration.
March 25, 2024
Matillion for cloud data integration.
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Matillion is used to build the data pipeline on the Google Cloud platform. There are multiple use cases: 1. Data is received in GCS storage and picked by Matillion based on the active sensors and on a specific schedule. Data is transformed and then loaded into big query tables. 2. Data is read from HTTP endpoints, transformed using Matillion, and then loaded into big query tables. 3. The data quality framework is built on top of Matillion to apply some business checks.
- Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
- It provides the security capability as well. All the credentials can be securely stored in Matillion.
- Reusable templates can be built which reduces the redundancy.
- Time to production is very minimal.
- There is a scope of making it more developer friendly in terms of reusability.
- Many configurations required to set up the Matillion pipeline can be reduced significantly.
- In built python executable is quite slow.
- It provides the capability to connect to a wide range of data sources.
- Faster onboarding of tenants.
- Reusability
It took us around one week to understand the tool. The primary time was spent understanding how to configure variables and connect to different sources. Creating a reusable template and then using it in other workflows is initially a bit complex. In a week, we became more comfortable with the product.
Matillion is a good tool for integrating multiple clouds. Informatica has been a market standard for many years, it provides multiple capabilities for data governance, data quality, etc. However, Informatica is pretty expensive compared to Matillion. Also, Matillion is more user-friendly, and it is easier to collaborate; hence, Matillion is a better choice.
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?
I wasn't involved with the selection/purchase process
Did implementation of Matillion go as expected?
Yes
Would you buy Matillion again?
Yes