2017-07-10T13:56:00Z

Which ETL or Data Integration tool goes the best with Amazon Redshift?


Which ETL or Data Integration tool goes the best with Amazon Redshift? Ex: Matillion, Informatica Cloud, Alooma, SnapLogic, SSIS 

Guest
1414 Answers

author avatar
MSP

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.

2017-07-16T16:46:07Z
author avatar
Vendor

Snaplogic

2017-07-13T14:01:30Z
author avatar
Vendor

I've found Matillion to be very intuitive and easy to use...

2017-07-13T12:34:06Z
author avatar
Vendor

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.

2017-07-13T12:23:50Z
author avatar
Consultant

you can address your question to our SAP department solutions@jet-bi.com

2017-07-13T11:59:34Z
author avatar
MSP

Informatica is the way forward

2017-07-13T11:52:50Z
author avatar
Consultant

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.

2017-07-13T11:33:51Z
author avatar
Vendor

Traditionally SQL is a plus, automation is only by a ETL is smarter.

2017-07-13T11:25:53Z
author avatar
Real User

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.

2017-07-13T11:21:52Z
author avatar
Vendor

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

2017-07-13T11:03:10Z
author avatar
Consultant

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

2017-07-13T11:01:43Z
author avatar
Top 20Consultant

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.

2017-07-13T10:55:01Z
author avatar
Vendor

Informatica is good to go with Redshit, however any open source ETL is good enough. Thanks

2017-07-13T10:50:09Z
author avatar
Consultant

Matillion or SAP BODS can be used as etl.

2017-07-13T10:44:47Z
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: May 2021.
501,818 professionals have used our research since 2012.