SAP Analytics Cloud integration with AWS Redshift

[#1]

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?

[carlospinto]

Hi all,

In case it helps, I confirm that I have integrated SAC with AWS Redshift using APOS LDG for Live data connection and Cloud Connector / Cloud Agent for Imported data connection. Both connections work reasonably well.

JDBC driver is RedshiftJDBC42-no-awssdk-1.2.47.1071.jar.

Kind regards,

Carlos

[moray]

Hi carlos.p.c. ,

Thanks for your reply. Can you please share with me how you did this exactly (installations - configurations). That will really help me out.

I already tried to create the connection, I got the error message that the database drive is misconfigured.

Thanks in advance

[carlospinto]

Hi moray,

I will try to publish a blogspot explaining this shortly, I will put the link here.

Thanks,

Carlos

[carlospinto]

I just published the blog How to connect SAP Analytics Cloud with AWS Redshift via JDBC.

I hope it helps.

Kind regards,

Carlos