Item: Matillion
Rating: 9
Author: Verified User

Use Cases and Deployment Scope

We use Matillion to create and manage data feeds for our Redshift based data lake. Based on Redshift we provide data for various reporting solutions used across our whole organization.

Pros and Cons

Feeding data into Redshift
Reading data from various data feeds
Excellent support

Pre-defined data feeds (e.g Facebook connector) are not delivering all data that is available by the generic API
Limited number of projects and variables (could be increased by contacting the support team)
Limited licensing model

Return on Investment

We can run our business

Usability

It is easy to make the first steps with the tool, good help, excellent support

Time to Value

we run our fist data projects within the first three months (containing complex data feeds and data modellings)

Scalability

There is a limited licensing model

Alternatives Considered

SQL Server Integration Services and Business Objects SRC

Matillion works better in the AWS context

Likelihood to Recommend

Matillion is well suited when you need to transfer data from various data sources into Redshift; it is less appropirate when you need to transfer data into other databases (Oracle, SQL Server etc.)

Matillion Review DAN Germany

Overall Satisfaction with Matillion