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 

14
PeerSpot user
14 Answers
it_user703824 - PeerSpot reviewer
Associate Partner at IBM
MSP
2017-07-16T16:46:07Z
Jul 16, 2017

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.

Product comparison that may be of interest to you
it_user642633 - PeerSpot reviewer
Workday Integrations at Salesforce
Real User
2017-07-13T14:01:30Z
Jul 13, 2017

Snaplogic

it_user102573 - PeerSpot reviewer
Database Expert at a healthcare company
Vendor
2017-07-13T12:34:06Z
Jul 13, 2017

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

it_user603990 - PeerSpot reviewer
User at a tech company with 51-200 employees
Vendor
2017-07-13T12:23:50Z
Jul 13, 2017

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.

it_user626979 - PeerSpot reviewer
Marketing and Business Development Manager at a tech services company with 51-200 employees
Consultant
2017-07-13T11:59:34Z
Jul 13, 2017

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

it_user414306 - PeerSpot reviewer
Cloud Architect at IBM
MSP
2017-07-13T11:52:50Z
Jul 13, 2017

Informatica is the way forward

Find out what your peers are saying about SSIS vs. SnapLogic and other solutions. Updated: November 2022.
657,849 professionals have used our research since 2012.
it_user592836 - PeerSpot reviewer
User 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.

Vendor
2017-07-13T11:25:53Z
Jul 13, 2017

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

it_user702450 - PeerSpot reviewer
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.

Real User
2017-07-13T11:03:10Z
Jul 13, 2017

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

it_user592836 - PeerSpot reviewer
User 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.

Hope the answer helps!

Thanks,

Shib

Barath Ravichander - PeerSpot reviewer
Data Engineer at Broadridge Financial Solutions
Real User
2017-07-13T10:55:01Z
Jul 13, 2017

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.

Vendor
2017-07-13T10:50:09Z
Jul 13, 2017

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

it_user130794 - PeerSpot reviewer
Consultant at a tech services company with 1,001-5,000 employees
Consultant
2017-07-13T10:44:47Z
Jul 13, 2017

Matillion or SAP BODS can be used as etl.

Related Questions
MR
Lead at Fidelity Investments
Nov 24, 2022
Hello community,  I am Team Lead at a large financial services firm. We have a lot of transformation logic and our data load volume is very large. We are looking for a tool that is easy to monitor and support. Which tool do you recommend: Talend or Snaplogic? What are the pros and cons? Thank you for your help.
See 1 answer
Deepak Damodarr - PeerSpot reviewer
Data Office Lead at a comms service provider with 501-1,000 employees
Nov 24, 2022
Both Talend and Snaplogic are good iPaaS solutions. If you have requirements beyond data integration, then Talend Data Fabric would score better than Snaplogic. If a simple setup, quick deployment, and ease of use are your criteria Snaplogic would score better. In a way, it is not fair to compare Talend with Snaplogic because both are trying to address a slightly different buyer groups.
Deena Nouril - PeerSpot reviewer
Tech Blogger
Jun 8, 2022
Why or why not?
Related Articles
Deena Nouril - PeerSpot reviewer
Tech Blogger
Jun 20, 2022
SnapLogic is a powerful Integration Platform as a Service (iPaaS) platform. The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects - design, development, deployment, and maintenance - whether on premises, in the cloud, or in hybrid settings. Both experts and non-experts can manage all application integration, data integration,...
Product Comparisons
Related Categories
Related Articles
Deena Nouril - PeerSpot reviewer
Tech Blogger
Jun 20, 2022
SnapLogic Review
SnapLogic is a powerful Integration Platform as a Service (iPaaS) platform. The SnapLogic Intelli...
Download Free Report
Download our FREE report comparing SnapLogic and SSIS based on reviews, features, and more! Updated: November 2022.
DOWNLOAD NOW
657,849 professionals have used our research since 2012.