ETL made easy for non-programmers
Updated January 05, 2021
ETL made easy for non-programmers
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.
- Components available to do work with any source
- Ability to connect to sources without preconfigured component with extensability
- Able to kick off jobs from SNS, SQS
- There are so many options that the learning curve could be long for a newbie
- Can only parallelize the load in 16 partitions so it can't make use of parallelism of Redshift
- Menu items for admins may not always work and would have to resort to shell scripting (offered)
- Allows quick development and deployment
Within 2 days
Matillion is purely cloud solution versus Informatica Cloud still requires PowerCenter to do any serious transformation work.