Which ETL or Data Integration tool goes the best with Amazon Redshift? Ex: Matillion, Informatica Cloud, Alooma, SnapLogic, SSIS
I am currently working as a solution architect for a tech vendor with 10,000+ employees.
I need to perform a comparative analysis for ETL tools available to populate data from OLTP to OLAP.
The main criteria I am considering are:
I want to evaluate both Oracle and Open Source options. I am also open to both tools (ODI, Golden Gate, etc) and technology- e.g. Oracle Materialized view.
Thanks! I appreciate your help.