A great tool for rapid Redshift data warehouse deployment
April 13, 2019

A great tool for rapid Redshift data warehouse deployment

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

Overall Satisfaction with Matillion

Matillion is used by the Technology group to build, manage, maintain and schedule data warehousing pipelines from multiple internal and external data sources to support business intelligence across the organization at all levels. Data sources range from SFTP to operational data stores to external APIs.
  • Manage SQL transformations to capture and document business rules.
  • Multiple components available to ingest quickly from various data sources.
  • Great technical and customer support.
  • Needs more components for piping data to external sources, e.g. enterprise service bus operations.
  • Could have more out-of-the-box API connectors such as Workday, Okta, etc.
  • No webhook support.
  • Matillion has enabled us to empower analysts to generate insights that have significantly proved efficiency, improved executive decision-making, and provide a foundation for more informative data science.
It's fairly easy to use without a deep SQL background, and support is highly responsive.
We got Matillion up and running in a week.
It's as scalable as AWS.
Well-suited for building a Redshift data warehouse (also for Snowflake but have not used that implementation).

Less well-suited for event-driven integrations such as webhooks.

Matillion Feature Ratings

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