Matillion ETL Previous Solutions

AntonHaupt - PeerSpot reviewer
Data Architect at Capitec

Previously, we relied on an on-premise solution, which often posed performance and capacity challenges due to server limitations. However, this approach involved upfront purchases and heavy licensing fees, which was a different model altogether. What I appreciate about Matillion is that it's available on the AWS Marketplace, allowing for easy installation and billing directly through our Amazon bill. This integration streamlines the process, as there's no need to manage separate vendor payments for ETL services.

View full review »
MG
Director of IT Operations at a financial services firm with 10,001+ employees

We have used Informatica, SSIS, and Alteryx, previously. The primary reason to switch was the scalability. We thought Matillion would bridge the gap between on-premises and on-cloud as we were moving there.

View full review »
Tomáš Hronek - PeerSpot reviewer
Data Engineer at Merck

I previously used Informatica PowerCenter and Informatica Cloud. We switched to Matillion ETL because it was cheaper.

View full review »
Buyer's Guide
Matillion ETL
March 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
it_user628059 - PeerSpot reviewer
Senior Engineer, Big Data/Data-Warehousing at a manufacturing company with 501-1,000 employees

We used Informatica, SnapLogic, and Talend. They do not work well with Redshift and they cost more. They do not understand MPP and much of what they do is outside of Redshift, i.e., not in-database.

You need to put them on a bigger EC2 or buy multiple licenses and have multiple EC2s to manage, in order to get scalability.

View full review »
PH
Senior Data Engineer Consultant at a tech company with 201-500 employees

At the time I joined the company I now work for, two years ago, Matillion ETL had already been introduced. We wanted to switch to something nicer and decided to move to the cloud with AWS Redshift. We also wanted to use a graphical interface for development, rather than lots of code snippets, as it would be faster and easier to maintain. With the graphical approach, it is much easier to spot and go to the root of any issues.

View full review »
HS
Director of Data Architecture at a healthcare company with 201-500 employees

We haven't used any of the on-premise solutions. What we used before was SQL Server Integration Service (SSIS), and when we were moving to the cloud, we wanted to use something that was cloud native (AWS).

View full review »
it_user149223 - PeerSpot reviewer
Senior Engineer, Big-Data/Data-Warehousing at a manufacturing company with 501-1,000 employees

SnapLogic and Informatica: too slow; for MPP, they are just glorified and expensive Python schedulers.

Python scripts: high maintenance.

View full review »
SK
Data Engineer

I have used Snowflake. However, I am beginning the using these types of tools.

View full review »
it_user987312 - PeerSpot reviewer
Solutions Architect at a financial services firm with 501-1,000 employees

We had previously used a homegrown ETL system and used a combination of IBM Cognos and ClickView as the presentation layout. They both had their own ETL steps inside them. What we're doing now is we're taking all of the data and moving it into one central data lake warehouse, which is sitting in Redshift, and controlling all the ETL in one place, as well. We're looking to switch off the legacy products now.

Essentially, I want all my data sitting in AWS and I wanted one product that could handle everything, that also needed to be lightweight. I didn't want to go with one of these big Informatica's or other similar tools that are out there, which are all licensed based and very expensive. I wanted something lightweight that was easy to use and relatively cheap.

View full review »
it_user635448 - PeerSpot reviewer
BI Team Lead (Warehouse) at a tech services company with 1,001-5,000 employees

I am not aware of any previous solution.

View full review »
Buyer's Guide
Matillion ETL
March 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.