Sign in
Categories
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

Matillion ETL for Snowflake

Matillion | 1.50.6

Linux/Unix, CentOS 7.5 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

22 AWS reviews

External reviews

25 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Airlines/Aviation

A good ETL tool where you don't have to worry about setting it up (a good scheduler built-in)

  • January 08, 2021
  • Review provided by G2

What do you like best?
There's no need to spend much time setting it up. You can dive in right away and start configuring your pipelines. The components provided are more than enough for a typical ETL. It covers all types of data sources including the script support if one needs to write custom logic.
What do you dislike?
The project structure can a bit confusing at times. Also, people have a hard time understanding how it is coupled with the redshift instance.
What problems are you solving with the product? What benefits have you realized?
I have done a typical full load and incremental loads from postgres to redshift.


    Telecommunications

Perfect go to ETL tool for cloud users

  • December 11, 2020
  • Review provided by G2

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.
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.
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!


    Hospital & Health Care

Business Intelligence Architect

  • December 09, 2020
  • Review verified by G2

What do you like best?
Matilion is good working with Snowflake. and also it has good component to work with various sources like S3, SQL and other databases which makes its best ELT tool.
What do you dislike?
Look and Feel can be make better which will allow end use to work more effectively.
What problems are you solving with the product? What benefits have you realized?
Matillion we are using for data extraction and load into snowflake which makes it better to use.
Recommendations to others considering the product:
yes I recommend to use Matillion as its best tool to use for cloud native technologies and very cheap for organization.


    Jared P.

Matillion ETL review

  • December 07, 2020
  • Review verified by G2

What do you like best?
Ease of use and User interface is easy to manage. Also has a short learning curve with a pretty robust set of ETL tools.
What do you dislike?
There is a healthy lag time on getting bugs fixed.
What problems are you solving with the product? What benefits have you realized?
Mainly using for warehousing data from several different transaction systems. Cloud environment is wonderful for manipulating millions of rows of records in a very quick manner.


    Alwin L.

Data Enginner for Warner Chappell Music

  • December 04, 2020
  • Review verified by G2

What do you like best?
User friendly and contains a lot of source and target endpoint to connect to perform extraction.
What do you dislike?
Certain limitation to connect to the old database due to driver issue like for example Cassandra 1. The cost is expensive measuring by the Matillion spec.
What problems are you solving with the product? What benefits have you realized?
Perform a data extraction from Cassandra to RedShift. A beginner user can able to pick up the skill in a fly.


    Health, Wellness and Fitness

Sr Datawarehouse Engineer

  • December 03, 2020
  • Review provided by G2

What do you like best?
Matillion ETL provides data engineers a platform for rapid development with great GUI as well as flexibility to write custom code using Python. It brings best of both world.
What do you dislike?
A comprehensive debugger tool and scheduler would be helpful. In addition, pyspark plugin would be a great addition.
What problems are you solving with the product? What benefits have you realized?
Building future state data warehouse quickly is highlight of this tool.


    Hospitality

Matillion ETL for Data Integration

  • December 03, 2020
  • Review provided by G2

What do you like best?
Flexibility in integrating with various database types such as SQL, Oracle, etc.
What do you dislike?
None. All features and functionalities are relevant for data integration and building pipelines into Snowflake data lake.
What problems are you solving with the product? What benefits have you realized?
The ability to poll from various data sources (databases, via API, AWS S3), incorporate business logic to process data, and pipe the data into the Snowflake data lake. Matillion ETL is intuitive and easy to use.


    Suchitra B.

Matillion ETL Review

  • December 03, 2020
  • Review provided by G2

What do you like best?
It was interactive and it prompted the new user for next step.
What do you dislike?
Nothing as such.
But I noticed, if we skip a click, it can still be done
What problems are you solving with the product? What benefits have you realized?
I am from ETL Background, so this tool was familiar for me


    Information Technology and Services

A great product to build data pipeline for cloud data warehouse solutions.

  • December 02, 2020
  • Review provided by G2

What do you like best?
It's easy and fast to pull data from various data sources to load into cloud data warehouse, requires less coding experience, the graphic interface is very friendly and intuitive
What do you dislike?
While dealing with complicated transformation logics, I write SQL procedures in the database, however I feel it's hard to call the procedure from Matillion.
What problems are you solving with the product? What benefits have you realized?
Migrated On-premise solution to cloud, build data pipeline to populate cloud data warehouse. The benefits I realized are like less configuration to build end-to-end pipeline for big data/cloud computing solution, besides, data loading performance is amazing.
Recommendations to others considering the product:
If complicated data transformation process is involved, better to use on-premise ETL solution at this moment.


    Banking

Easy to use ETL tool

  • December 01, 2020
  • Review provided by G2

What do you like best?
Extract, load, and transform use cases for big data. Connecting with a variety of sources and extract data into a single data lake.
Overall easy to use tool!
What do you dislike?
Cost, availability and repeated tools within AWS
What problems are you solving with the product? What benefits have you realized?
Connecting my aws data source and performing ETL operations.
Storage and consistency are great.