Item: Matillion
Rating: 7
Author: Verified User

Use Cases and Deployment Scope

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.

Pros and Cons

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.

Return on Investment

It provides the capability to connect to a wide range of data sources.
Faster onboarding of tenants.
Reusability

Usability

It has definitely increased the team's efficiency. There is less code to maintain, and similar logic in a different flow can be easily integrated.

Time to Value

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.

Scalability

The company uses both AWS and GCP. Data movement across the cloud and different stacks, like file, SQL, and no SQL, is really helpful. It also integrates well with API endpoints. The tool is very performant; even a huge amount of data can be easily transformed and loaded into the warehouse.

Alternatives Considered

Informatica Cloud Data Integration, dbt and Fivetran

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.

Key Insights

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

Other Software Used

Google BigQuery, Google Cloud Functions, Apache Airflow

Likelihood to Recommend

It is very well suited for ETL on the cloud. Whenever there is something that can be accomplished with no code or little code, Matillion is a good tool. However, if your pipeline requires a lot of customizations, Matillion should be avoided.

Matillion for cloud data integration.

Overall Satisfaction with Matillion