Item: Matillion
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

We use Matillion as an ELT tool to take data from MongoDB and transfer it into Snowflake.

We have over 50 tables being transferred daily and several are multi millions of records and tens or gigabytes.

Pros and Cons

Extracts Nested JSON
Had good DB support for multiple products.
Runs in Azure where your Cloud is (may be).

Upgrade process is sometimes quirky with no updates listed when there are clearly newer versions.
Support is sometimes long winded and multiple people have to get involved.
Docs could be expanded as not enough installed base to make forums or Google results useful in many cases.

Return on Investment

Less hours spend on ETL/ELT
Speed of delivery
Well equipped to use Snowflake

Usability

It is not always cost effective to use a busy programmer when a good business analyst can use the tool.

Time to Value

I managed to install into Azure in a single day.

I watched a few YouTube videos (which I would like to see more of) and managed to create less complex ELT transfers in a single day.

Snowflake connection was a little more complex than it could be....and variable handling takes a while to grasp initially.

Scalability

Can really connect and transfer anything to anything.

Alternatives Considered

Informatica B2B Data Exchange

Much easier to use

Key Insights

Do you think Matillion delivers good value for the price?

Yes

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

Yes

Did implementation of Matillion go as expected?

Yes

Would you buy Matillion again?

Yes

Other Software Used

Snowflake, MongoDB Atlas, Azure App Service

Likelihood to Recommend

Very well suited to JSON documents and un-nesting arrays / objects.

Easy to get started and self learn, which is important.

Good easy to learn ELT tool

Overall Satisfaction with Matillion