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
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools