Item: Matillion
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

We use Matillion as our main tool for all ETL/ELT processing. Our DWH target DB is Snowflake. We extract data from different sources; ex: SQL Server, BOX, S3, SAP HANA.
We also use Matillion to execute Python scripts. We are working currently to configure Matillion to connect to Github.

Pros and Cons

Executing Python scripts
Data Lineage
Easy to search of objects included in our project
Creating job templates

Jobs metadata to be available in Snowflake
Error messages some times are not so clear
Job Optimization recommendation

Key Insights

Do you think Matillion delivers good value for the price?

Not sure

Are you happy with Matillion's feature set?

Yes

Did Matillion live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Matillion go as expected?

I wasn't involved with the implementation phase

Would you buy Matillion again?

Yes

Return on Investment

Less development time
Less training needed to use the tool
Possibility to connect to various types of source systems

Usability

Simplicity and less time consuming.

Time to Value

Not much time, as I already had previous experiece using ETL tools, and Matillion is by far was the easiest and more user/developer friendly

Scalability

So far, I was able to connect to most of the data sources I need with no issues

Alternatives Considered

IBM InfoSphere DataStage

Matillion is way much easier and faster

Likelihood to Recommend

Matillion is a very easy to use tool, does not require much experience in the tool to start using it, so juniors and new joiners can start working with it easily.
Matillion has so much components that fits majority of our business needs.
A mising point in Matillion is the metadata to be available in Snowflake.

Simplicity in implementing ETL/ELT

Overall Satisfaction with Matillion