Does anyone have experience with integrating SAP Analytics Cloud with AWS Redshift? In particular, are the SAC JDBC connectors a performant and reliable way to exchange data, or do we really need to move data thru files & S3? If we have to make all of our SAP instance data available in both Redshift and SAC, would it be better to use live connectors with SAC to the SAP instances, and use import/export of files to S3/Redshift independently, or to use a more consistent approach (ie import/export files to both). Are there specific tools that anyone would recommend that have been used to reliably perform SAC<=>Redshift integration at scale?
Request clarification before answering.
Hi Matt,
You might what to look at the APOS Live Gateway to enable you to read data S3 and Redshit via https://www.apos.com/content/apos-live-data-gateway
No comment on performance etc but this looks promising .
Regards
Afshin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.