Matillion ETL

What do you like best?

Best features.

1) Cloud based architecture so we can take advantage of all the available cloud tools

2) Can perform fast data transfers when the files are available in cloud

3) Github integration available

4) Functionality to migrate code between environment is awesome

5) Lots of native connectors available for different applications

6) Its is easy to the application is much fast in terms of other non-cloud ETL/ELT tools.

7) Simple yet powerful

8) The jobs can be triggers using AWS SQS functionality where you can drop a message in your queue to execute a job.

9) Chargers are based on pay as you go.

What do you dislike?

Could have been improved.

1) SSO enabled GIT cant be integrated with Matillion

2) CSV response API calls cannot be handled using the native API client.

3) Scheduling functionally can be improved by providing more features like explicit calendars etc ..

4) Error messages could have been more appropriate

5) Expect slowness in login for the very first time

6) EC2 maintenance could have been taken care by Matillion team like snowflake.

Recommendations to others considering the product:

Get it if you have you other application on cloud already (AWS/AZURE/GOOGLE CLOUD etc) .. License cost is much cheaper when compare to other applications in Market , Since its a pay as you go system you need to pay only when you use it . That is something great!

What problems are you solving with the product? What benefits have you realized?

We are building enterprise data warehouse using Matillion ETL . Since most of the source data available for us are in the cloud and that help us to take the advantage of cloud power to perform faster data loads .

So many native connectors are available to connect various applications ..

Could maintenance and migration became so simple .

Mainly we don't need a powerful machine to build ETL anymore.