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

[former_member532376]

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

[kenneth_dalvik]

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-p...

[former_member532376]

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

[ThomasK]

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!

[ThomasK]

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

[former_member532376]

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