Question Re: SAP Analytics Cloud integration with AWS Redshift in Technology Q&A

SAP Analytics Cloud integration with AWS Redshift

Former Member — Mon, 04 Nov 2019 08:27:56 GMT

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?

Re: SAP Analytics Cloud integration with AWS Redshift

former_member6443 — Tue, 05 Nov 2019 00:05:23 GMT

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

Re: SAP Analytics Cloud integration with AWS Redshift

mikethespike — Thu, 14 May 2020 15:08:14 GMT

Hello Matt,

were you able to use the SAC JDBC connectors to make a connection to Amazon Redshift ? We would like to do the same thing. Any info you can share.

Best Regards,

Michael

Re: SAP Analytics Cloud integration with AWS Redshift

deepusasidhar — Fri, 15 May 2020 05:35:43 GMT

You could use a similar approach as mentioned in the blog below for SnowFlake integration.

You could replace the SnowFlake driver with Amazon RedShift.

https://blogs.sap.com/2020/05/14/connecting-analytics-cloud-to-snowflake-import-mode/

Re: SAP Analytics Cloud integration with AWS Redshift

diana_victorero — Tue, 23 Jun 2020 21:31:34 GMT

connection-error-sac.jpgHi Matt,

Did you could integrate SAP Analytics Cloud to Redshift?

We have just applied all the steps from de blog below:

https://blogs.sap.com/2020/05/14/connecting-analytics-cloud-to-snowflake-import-mode/

But gives as an error: "The database drive is misconfigured. Please contact your on-site Analytics Cloud agent administrator." (image attached) .

We have configured Agent and also the config file (c4a_agent_drivers.properties) but we get stuck in the step when we need to create connection in SAC.

We are using the JDBC driver: redshift-jdbc42-1.2.36.1060.jar

Provided by our SQL Client Aginity Pro. Also tried with the driver from Amazon: https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver and also give us same error.

Hope you could help us.

Thanks in advance,

Best regards,

Diana Victorero

Re: SAP Analytics Cloud integration with AWS Redshift

andreipg — Wed, 24 Jun 2020 22:06:18 GMT

Hello Diana,

Were you able to make this work?

Re: SAP Analytics Cloud integration with AWS Redshift

diana_victorero — Thu, 25 Jun 2020 00:20:02 GMT

Hello Andrei,

Unfortunately no :(, we have created an incident with SAP Support and still waiting for response. But any help would be appreciated.

mattsquire mikethespike deepusasi_2020 : Did you be able to configure SAC with Redshift?

Best regards,

Diana Victorero

Re: SAP Analytics Cloud integration with AWS Redshift

mikethespike — Mon, 06 Jul 2020 13:53:11 GMT

Hello Diana,

We also created an incident with SAP support and waiting for the response.....

Best Regards,

Michael

Re: SAP Analytics Cloud integration with AWS Redshift

nathan_qi — Tue, 15 Jun 2021 20:28:42 GMT

There is additional requirement for Redshift:

You must use a Simba JDBC driver for Amazon Redshift, Amazon EMR, Apache Hadoop Hive, Cloudera Impala, Apache Spark, and Hortonworks Data Platform.

This is written in SAC's help -> Home -> Connections -> Import Data Connection -> Import Data Connection to an SQL Database

BTW, I run into the same issue even with Simba driver. Meanwhile, the connection is working there via generic connection: https://answers.sap.com/questions/13173656/connect-sap-cloud-analytic-to-redshift.html

Re: SAP Analytics Cloud integration with AWS Redshift

moray — Tue, 14 Feb 2023 12:14:47 GMT

Hi diana.victorero ,

hi mikethespike,

could you do the connection to Amazon Redshift? I got the same error message that The database drive is misconfigured. Can you please share the solution with me if you found it.

Thanks in advance

Re: SAP Analytics Cloud integration with AWS Redshift

carlospinto — Mon, 13 Mar 2023 18:02:55 GMT

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

Re: SAP Analytics Cloud integration with AWS Redshift

moray — Tue, 14 Mar 2023 11:14:44 GMT

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

Re: SAP Analytics Cloud integration with AWS Redshift

carlospinto — Tue, 14 Mar 2023 18:11:24 GMT

Hi moray,

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

Thanks,

Carlos

Re: SAP Analytics Cloud integration with AWS Redshift

carlospinto — Sun, 19 Mar 2023 18:18:42 GMT

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

I hope it helps.

Kind regards,

Carlos