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?

[diana_victorero]

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