Amazing ETL tool for Redshift

• By Oleg - BI Solutions Architect
• on 11/08/2018

I met with Matillion team at AWS Summit 2018 at Sydney, Australia. At that time we were using one of the legacy products as an ETL for our Redshift Data Warehouse.

We were trying to adopt Continuous Integration/Continuous Delivery framework for our ETL and found it to be challenging for our environment. It was time to look for something new and say goodbye to our bellowed old ETL tool. So we had a conversation with Matillion team and quickly decided to do a POC. We’ve evaluated couple of other tools in the past but nothing came close to Matillion.

First of all, setup was a breeze. The migration was quick and painless, the system is very easy to work with. Almost more importantly, the Matillion team is very friendly and always willing to help, their support is outstanding! Matillion has dozens of native connectors out of the box, so we had no problem with integrations at all. In fact, migration to Matillion allowed us to drop couple of third party ETL components required for old tool to work with AWS infrastructure.

Python scripts component allows to use Boto3 and hundreds of other libraries, so practically there is no limit of where you can use Matillion.

We were finally able to build full scale CI/CD pipeline. Our setup uses combination of JIRA, Bitbucket and Bamboo build server and it works like a charm, thanks to Matillion’s REST API.

I give Matillion ETL 5 out of 5 rating.