Excellent AWS Data Integration Platform
Updated November 25, 2020

Excellent AWS Data Integration Platform

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

Overall Satisfaction with Matillion

Matillion is used by the software department for data integration, for syncing up data from the OLTP database to the OLAP system, and populating data for our data warehouse.
  • Easy to build data integration job
  • compatible with AWS cloud platform
  • lots of components for different use cases
  • No powerful job monitor console
  • Flexibility for supporting scripting languages
  • Expensive license fees
  • License fees are expensive.
It's good for building a data warehouse on AWS Redshift.
It's easy to set up an environment and start a project quickly.
Matillion supports multiple DBMS systems and multiple data format files, which means it has strong scalability.
Matillion is fully designed for AWS Cloud products, and aligned with AWS Redshift data integration perfectly.
Matillion is well suited for building a data warehouse on AWS Redshift, but less suited for on-premise data integration.

Matillion Feature Ratings

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

Using Matillion

6 - Data team uses Matillion for data integration tasks such as: Populate Data Warehouse, transform and ingest Data Lake data into Redshift Data Mart.
2 - DBA and Devops people provides support and maintenance for Matillion, which have AWS EC2 maintenance, Cloud Formation, ETL development, and DBA skills.
  • Data Mart Integration
  • Data Lake Integration
  • Third Party Data Integration
  • Transformed data from different AWS region
  • Support Data Scientist AI project
Matillion is powerful and multifunctional for data integration on AWS Cloud.

Evaluating Matillion and Competitors

Yes - We replaced Pentaho ETL tool with Matillion as Matillion is aligned with AWS Cloud products perfectly.
  • Advisor recommendation
We tested and evaluated Matillion tool based on advisor recommendation, which convinced us that Matillion is best data integration tool we need for supporting Data Warehouse on AWS Cloud.
We wouldn't change the decision.

Matillion Support

Most of time Matillion provided support on time and helpful.
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
Matillion support team provided support for resolving ETL task caused out of memory issue.