2017-07-10 13:56:00 UTC

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
Vendor

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-16 16:46:07 UTC
author avatar
Vendor

Snaplogic

2017-07-13 14:01:30 UTC
author avatar
Vendor

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

2017-07-13 12:34:06 UTC
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-13 12:23:50 UTC
author avatar
Consultant

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

2017-07-13 11:59:34 UTC
author avatar
Vendor

Informatica is the way forward

2017-07-13 11:52:50 UTC
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-13 11:33:51 UTC
author avatar
Vendor

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

2017-07-13 11:25:53 UTC
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-13 11:21:52 UTC
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-13 11:03:10 UTC
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-13 11:01:43 UTC
author avatar
Top 5Consultant

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-13 10:55:01 UTC
author avatar
Vendor

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

2017-07-13 10:50:09 UTC
author avatar
Consultant

Matillion or SAP BODS can be used as etl.

2017-07-13 10:44:47 UTC
Find out what your peers are saying about Snowflake Computing, Microsoft, Micro Focus and others in Cloud Data Warehouse. Updated: May 2020.
419,794 professionals have used our research since 2012.