Fetch data in ABAP, using SDA connection

[nagaraosunkara]

Hello All,

We have data in table created on SDA connection, and want to fetch in ABAP.

Do we have any direct way to read data from SDA in ABAP?

One possible option for us is to, create virtual table in a database schema and fetch data in AMDP, and CDS table functions.

Thanks.

[Cocquerel]

You may use CDS External Entities
See https://www.youtube.com/live/pu_aa-P3d2o?si=6qSB40ihT4rSMlb4

[christianpunz]

unfortunately one of my customers wants to write to a MS SQL Database table which resides in Azure. In the video Arne Harren said (minute ~39) that write is a planned feature 😞

[christianpunz]

hi @nagaraosunkara ,
you may refer to the other posting: 

ABAP access to SDA virtual table 

Carine gave a hint. I did not try it yet but it sounds reasonable.

br

christian

#SDA #smartdataaccess #HANA #AMDP