The go to ELT solution for Redshift datawarehouses
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.
Pros
- Cloud-based solution
- Seamless integration with Redshift
- Minimum scripting required
- Good feature documentation
- Easy to learn/good tech support and tutorials
Cons
- 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.
I was possible to setup the tool within an hour from Amazon Marketplace and start the ETL/ELT processes.
- 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.
2. Easy to create and manage ELT pipelines.
3. Works great with redshift databases.
Comments
Please log in to join the conversation