Great tool for the data transformation of your data warehouse in the cloud
April 25, 2019

Great tool for the data transformation of your data warehouse in the cloud

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

We use Matillion to load all our business data to our DataWarehouse. The data is later used by nearly all departments across the whole organization, for reporting, analytics, etc.

Pros

  • Matillion is easy to use
  • It is very customizable and has a lot of connectors to third party systems
  • The Matillion support team is very good and you get a really fast solution to your issue/problem
  • Everything in one tool -- The ELT-process done in a easy to use GUI, scheduling, monitoring
  • Nice variables concept - they can be used nearly everywhere
  • Matillion uses the native SQL-Code of the cloud based data warehouse (in our case Snowflake) for most of the processes, so the heavy load is done by the database system

Cons

  • Sometimes the "windows" with detail info are too small and cannot be resized
  • Connectors that can write back to 3rd party systems
  • More statistical info about the execution of steps/jobs (maybe in tables)
  • Most positive impact was that we had the first production data live in about 1 week using Matillion
  • We can use generic processes and control them through our MetaData configuration tables - So if we need to at a new data sources it takes only minutes to configure and start the load process
  • We don't see any negative impact
The overall usability of Matillion is great. The learning curve of a new developer is very high, the documentation is good and Matillion provides a lot of very helpful video tutorials. It is easy to use, easy to understand. The UI sometimes has some flaws, sometimes you can not resize the windows. It also lacks some more statistical info about your jobs. But these are minor "flaws", which do not interfere that much in the usage of Matillion.
We started with the installation process and a short (1h) live webinar provided by Matillion, with our new project. The documentation of setting up Matillion was very good and it was "quite" easy to set up everything, from Amazon AWS - Snowflake - FireWall settings to access our on premise SQL Servers, etc. After the Webinar which gave us a first look at how to start with Matillion, we got the first production data live in about 1 week. We requested a second Webinar were the Matillion support explained us how to use grid-variables. That was very helpful. After an additional 2-3 weeks we had the generic process running using metadata config to do the load process for most of our data sources.
We are running in with a medium setup. A lot of our jobs run in parallel using the "concurrent" mode in calling a job. The scalability is very good. As we do not have to take care how many processes/threads run at once. This is controlled by Matillion. Because we use a meta data config concept we run different jobs at different times. Most of the time we have about 13-20 jobs running in parallel and each job loads from more than 1 different source. Some of them from about 10-20 sources. This all runs in parallel. We haven't reached the limit... So I would say it is very scalable. And we also could upgrade to a "large" machine.
Matillion gave us more flexibility for our purposes, and we didn't have to program a lot in Python or any other programming language to transform the data. With Matillion we could implement our metadata-driven approach and we had everything in one tool. New developers can easily start developing and loading data with Matillion. The price was also a benefit...
If you want to transfer data in an easy and fast way from all of your different data sources to your cloud based data warehouse, then Matillion is for me the best tool. It gives you access to all different kind of data sources (sftp, REST, SalesForce, GoogleBigQuery, on-premise servers like SQL Server, etc.). It is easy to handle, and you can even create generic processes which use MetaData to load the data to the data warehouse.

Matillion Feature Ratings

10.0
Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
10.0
Simple transformations
10
Complex transformations
10
7.3
Data model creation
Not Rated
Metadata management
5
Business rules and workflow
7
Collaboration
9
Testing and debugging
8
Not Rated
Integration with data quality tools
Not Rated
Integration with MDM tools
Not Rated

Comments

More Reviews of Matillion

  1. Home
  2. Data Integration Tools
  3. Matillion Reviews
  4. User Review of Matillion