Item: Matillion
Rating: 10
Author: Arnob Bordoloi

Use Cases and Deployment Scope

Currently driving the ETL /ELT processes to load a Redshift Data warehouse. We have 5+ data sources that include on-premise/cloud databases, CRM and marketing tools that are feeding the data warehouse. Matillion is also used to automate various marketing processes.

Pros and Cons

Cloud-based solution
Seamless integration with Redshift
Minimum scripting required
Good feature documentation
Easy to learn/good tech support and tutorials

Installation/setup
Better out of the box support for CRM tools like Zendesk would be helpful.

Return on Investment

Limited the number of resources to invest in ETL work.
Less technically inclined users could be involved.

Usability

The learning curve was not too big and was able to kick off the data warehousing project soon after a small POC. Additionally, minimum scripting was required with good out of box support for connecting with Marketing, CRM tools. Various SQL views could be recreated in the UI which made maintenance easy for less tech-savvy users

Time to Value

I was possible to setup the tool within an hour from Amazon Marketplace and start the ETL/ELT processes.

Scalability

Matillion has options for migration, import/export jobs which makes it flexible during instance changes. Strong limits on the number of concurrent users can cause issues.

Alternatives Considered

Talend Data Integration and SQL Server Integration Services

1. Cloud Solution
2. Easy to create and manage ELT pipelines.
3. Works great with redshift databases.

Other Software Used

Stitch, Periscope Data, Zapier

Likelihood to Recommend

Suited for:
1. People looking for cloud-based ETL/ELT solutions.
2. Works great with Amazon Redshift data warehouses.
3. Large transformation jobs, as it leverages the power of redshift to run transformations.
4. Great UI for users to create, maintain and document jobs.

The go to ELT solution for Redshift datawarehouses

Overall Satisfaction with Matillion