Question Re: DWC - Join virtual/remote tables in Technology Q&A

DWC - Join virtual/remote tables

axel_ — Mon, 18 Oct 2021 08:57:37 GMT

Hello DWC Gurus,

we are considering DWC as replacement for an BusinessObjects Plattform szenario that combines several Oracle tables in a BO universe.

Questions we got:

First, can we join (further model) tables that are connect to DWC only virtually?
So basically we would like to re-build the BO universe in DWC but don't want to replicate/persist the Oracle tables in DWC.

Second, does anyone know if SAP is working on a solution that reads a BO universe and then creates the virtual data model in DWC (representing the BO universe) automatically?

Thanks for all replies in advance,
Axel

Re: DWC - Join virtual/remote tables

XaviPolo — Wed, 20 Oct 2021 07:25:05 GMT

Hi,

first question, yes, you can join data from remote sources. Access to remote sources like Oracle is managed by HANA SDI/SDA, you can check in documentation some consideration and optimizations done by HANA when accessing remote data (semi joins, push where conditions, etc)
second question, I have not heard anything about it.

Kind regards,

Re: DWC - Join virtual/remote tables

axel_ — Wed, 20 Oct 2021 08:43:44 GMT

Hello Xavier,

thank you very much for the answer.

Best regards,

Axel