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

[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!