Item: Matillion
Rating: 9
Author: Verified User

Use Cases and Deployment Scope

We use it as the main ETL for our DWH ingesting data from transactional apps and various web sources, mostly marketing related to social networks. It is being used across the whole organization.

Pros and Cons

Simplicity
Performance
Documentation

Dealing with semi-structured data
Data profiling

Return on Investment

Improved decision making
Improved operational efficiency in data integration
Improved transparency of data integration

Usability

Easily accessible through any browser, supports versioning and concurrent collaboration.

Time to Value

Very quickly, within days we had Matillion installed and configured on AWS. Setup is straightforward and docs are good.

Scalability

We haven't had high data volumes so far, so Matillion performed as expected.

Alternatives Considered

Tableau Prep

Matillion is more mature and it has more data connectors.

Other Software Used

Tableau Desktop, Tableau Server

Likelihood to Recommend

It is well suited to ingesting data from web sources, such as social networks. It is less appropriate for dealing with semi-structured or unstructured data.

Lean & Mean Data Integration with Matillion

Overall Satisfaction with Matillion