Matillion ETL Review

It is able data sync reliably and ensures that we are compliant with our legal requirements

What is our primary use case?

We use it to migrate data from in-house databases and other data sources into Amazon Redshift.

How has it helped my organization?

  • It is able data sync reliably.
  • It ensures that we are compliant with our legal requirements.

What is most valuable?

  • It is pretty user-friendly, even for people who aren't super technical.
  • It has good integrations with Amazon Redshift and other AWS services.

What needs improvement?

  • It could have better integrations with other databases and other services.
  • I would like to have more customization available.
  • Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

It is very stable. We have not had to deal with many issues. 

It is running at almost 100% CPU for most of the night. So, it is fairly stressed.

What do I think about the scalability of the solution?

It scales okay. It takes up a good amount of computing resources while it is running, but we wouldn't have too much trouble giving it a little more if it needed it. We have a lot of data, therefore it is hard for me to guess how much we send through it.

How is customer service and technical support?

I haven't personally dealt with the support.

How was the initial setup?

The integrations with a lot of the AWS tools, services, and databases are very convenient. 

It works with DynamoDB, Redshift, Salesforce, and Aurora databases. It has good integrations with all of these.

What's my experience with pricing, setup cost, and licensing?

Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing.

It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on.

Which other solutions did I evaluate?

We also evaluated Xplenty. 

We chose Xplenty because we wanted to able to have the data live in our VPC, through our network, and not exit our network. Also, the cost was good.

What other advice do I have?

It does the things that it does fairly well, but it would be nice to have some more features, like custom jobs.

Try different tools as much as you can. Make sure the different data that you are trying to sync fits in with the integration the tool provides (or at least most of them). Otherwise, you are going to be paying a lot for not using most of its features.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email