Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse. Updated: March 2024.
Works at a tech services company with 10,001+ employees
Consultant
2017-07-13T11:33:51Z
Jul 13, 2017
it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
https://aws.amazon.com/redshift/partners/
Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.
Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.
Manager BI Development at a comms service provider with 1,001-5,000 employees
Real User
2017-07-13T11:21:52Z
Jul 13, 2017
Any ETL tool that moves data to it's own server for processing will add overhead and will not use Redshift's power ( more specifically parallelism). It is recommended to use standard SQL for data processing.
I have been worked in one of the project which has Redshift as source. There we have used Talend for ETL, but it goes good with Infomatica cloud as well.
Works at a tech services company with 10,001+ employees
Consultant
2017-07-13T11:01:43Z
Jul 13, 2017
Hi,
it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
https://aws.amazon.com/redshift/partners/
Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.
Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.
What is a Cloud Data Warehouse? A cloud data warehouse (often abbreviated as DW or DWH) is a repository that consolidates data from various sources (including internet of things devices, relationship databases, and other data systems) and stores it in a public cloud. It is built for high-performance analytics, scale, and ease of use. Because a data warehouse is dedicated to storing and analyzing data in order to reveal patterns, trends, and correlations it enables businesses to launch...
S3 copy is the best solution to load data into Redshift. I have used Informatica to move data from On premise to S3 and used S3 Copy to load Redshift.
Snaplogic
I've found Matillion to be very intuitive and easy to use...
I wish I could answer that question, but my expertise is limited to SSIS only.
As far as I know 'talend' could be a better choice compare to the other tools.
you can address your question to our SAP department solutions@jet-bi.com
Informatica is the way forward
it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
https://aws.amazon.com/redshift/partners/
Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.
Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.
Traditionally SQL is a plus, automation is only by a ETL is smarter.
Any ETL tool that moves data to it's own server for processing will add overhead and will not use Redshift's power ( more specifically parallelism). It is recommended to use standard SQL for data processing.
Hi,
I have been worked in one of the project which has Redshift as source. There we have used Talend for ETL, but it goes good with Infomatica cloud as well.
Regards,
Narendra
Hi,
it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
https://aws.amazon.com/redshift/partners/
Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.
Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.
Hope the answer helps!
Thanks,
Shib
I have tried snaplogic and informatica cloud. But not sure of others. I would vote for informatica cloud as I have good connectors with them.
Informatica is good to go with Redshit, however any open source ETL is good enough. Thanks
Matillion or SAP BODS can be used as etl.