The go to ELT solution for Redshift datawarehouses
May 22, 2019

The go to ELT solution for Redshift datawarehouses

Arnob Bordoloi | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

Currently driving the ETL /ELT processes to load a Redshift Data warehouse. We have 5+ data sources that include on-premise/cloud databases, CRM and marketing tools that are feeding the data warehouse. Matillion is also used to automate various marketing processes.
  • Cloud-based solution
  • Seamless integration with Redshift
  • Minimum scripting required
  • Good feature documentation
  • Easy to learn/good tech support and tutorials
  • Installation/setup
  • Better out of the box support for CRM tools like Zendesk would be helpful.
  • Limited the number of resources to invest in ETL work.
  • Less technically inclined users could be involved.
The learning curve was not too big and was able to kick off the data warehousing project soon after a small POC. Additionally, minimum scripting was required with good out of box support for connecting with Marketing, CRM tools. Various SQL views could be recreated in the UI which made maintenance easy for less tech-savvy users
Matillion has options for migration, import/export jobs which makes it flexible during instance changes. Strong limits on the number of concurrent users can cause issues.
  • Talend Data Integration and SQL Server Integration Services
1. Cloud Solution
2. Easy to create and manage ELT pipelines.
3. Works great with redshift databases.
Stitch, Periscope Data, Zapier
Suited for:
1. People looking for cloud-based ETL/ELT solutions.
2. Works great with Amazon Redshift data warehouses.
3. Large transformation jobs, as it leverages the power of redshift to run transformations.
4. Great UI for users to create, maintain and document jobs.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Not Rated
Testing and debugging
Integration with data quality tools
Not Rated
Integration with MDM tools
Not Rated