Matillion- Simple and Easy Cloud ETL Solution for Snowflake Data Warehouse
March 18, 2024

Matillion- Simple and Easy Cloud ETL Solution for Snowflake Data Warehouse

Souvendra Apiah | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Matillion ETL is used to extract, transform and load data into the Data Warehouse in Snowflake from data sources like Oracle databases and external CSV files. Matillion is used both for managing, scheduling and controlling the ETL processes as well as the data loading and transformations.
  • Executing Snowflake scripts
  • Oracle Database Connection and Data Retrieval
  • Low Code programming by setting properties of the different components
  • Parameter Passing between jobs
  • New components for supporting other programming languages like R
  • Upgrade Send Email component with more features
  • Upgrade GIT Integration features
  • The Low Code programming feature makes it easier to create ETL jobs
  • As a Cloud ETL tool it greatly eases the maintenance and accessibility
The different ETL processes are represented graphically and this makes it easily understandable by development and support team to develop, test and maintain the ETL solutions.
Within a month we were able to create transformation and orchestration jobs for our ETL processes. The ETL jobs were deployed in production and a scheduled was created for its execution.
We have used Matillion with Oracle and Snowflake only so far.

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

Data loading from Oracle Databases to Snowflake Data Transformation within Snowflake Database

Matillion Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
5
Simple transformations
10
Complex transformations
6
Business rules and workflow
5
Collaboration
5
Testing and debugging
9