Question Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse) in Technology Q&A

SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

former_member532376 — Fri, 13 Dec 2019 10:41:14 GMT

Hi colleagues,

is anyone of you aware of a plan if and when it will be possible in SAP Analytics Cloud to acquire data from Azure SQL Data Warehouse (like it is possible for Google BigQuery already)?

Regards, Michael

Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

ThomasK — Fri, 13 Dec 2019 10:56:54 GMT

Hi Michael,

I´d potentially see 2 options which could be checked.

a) via OData if Azure SQL Data Warehouse is capable to publish data via OData interface

b) via HANA DB and SDI Smart Data Integration

BR Thomas Karner

Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

former_member532376 — Mon, 16 Dec 2019 06:38:05 GMT

Hi Thomas,

thanks for your prompt reply !

ad a) This is unfortunately no option

ad b) We want/have to stay with SQL Data Warehouse on Azure-side; I guess SAC uses HANA DBaaS as its "own" database - are you aware of any possibility to access this "underlying" HANA ?

Regards,
Michael

Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

ThomasK — Mon, 16 Dec 2019 06:56:51 GMT

Hi Michael,

unfortunately there´s no way to access the "underlying" HANA DB.

The option I meant is:

a) SAC connects live to a HANA DB (which must be available locally on customers´s side)

b) The HANA DB is connected with the Azure DB via Smart Data Integration (which is also a live connection).

With this setup it should be possible to realize a live connection from SAC to Azure DB.

The downside is that customer needs a HANA DB. If not availble it might be a showstopper.

Further I have real concerns about performance and also about data authorizations.

So, if this scenario is not reasonable, I expect there is no other solution possible (at the moment).

Best regards,

Thomas

PS: What a coincidence to meet a former colleague in this discussion 🙂 Wish you all the best!

Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

former_member532376 — Mon, 16 Dec 2019 09:37:40 GMT

Hi Thomas,

we thought about adding a HANA on Azure in front of SQL Data Warehouse (Synapse) but came to the exact same conclusion as you did (costs, performance, authorizations)

It's a small world Thomas and in terms of Microsoft and SAP it is even getting closer 🙂

Merry Christmas,
Michael

Re: SAP Analytics Cloud acquire data from Azure SQL Data Warehouse (Synapse)

kenneth_dalvik — Sun, 22 Aug 2021 18:24:17 GMT

Hi please see this blog

https://blogs.sap.com/2021/08/22/how-to-load-data-from-azure-synapse-sql-dw-to-sap-analytics-cloud-planning/comment-page-1/#comment-586328