Works at a tech services company with 10,001+ employees
Real User
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-
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
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
Real User
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-
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.
Cloud Data Warehouse solutions provide scalable, flexible platforms enabling organizations to store and analyze large datasets efficiently in a cloud environment.These solutions offer integration capabilities with existing data systems, allowing businesses to optimize data management processes. Cloud Data Warehouses support advanced analytics by providing powerful tools to query vast data sets quickly. Designed to scale based on demand, they help reduce costs related to hardware maintenance...
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-
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-
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.