Connect to On-prem Database via ODBC from BTP ABAP

[Muthu_raja]

Hello Team,

We have some data stored at On-premise third party database and we would like to consume/process it from ABAP Cloud (RAP)

My questions are below,

• How do I consume the thirdparty db from the BTP ABAP ?
• Do we have to use ODBC or any other efficient way available ?
• Will CDS/RAP framework supported here directly ?
• If not, Please suggest us what other best ways to achieve this requirement ?

Please let me know.

Best Regards,

Muthu

[bernhard_grusie · Accepted solution]

Hi,

looks like this is on the roadmap:

https://help.sap.com/docs/abap-cross-product/roadmap-info/integration-services Outbound SQL via CDS External Entities

Surely you can create an OData service on top and use the Service Consumption Model to use it in your RAP implementation. The creation of the OData service on top is an extra effort 😞

https://developers.sap.com/tutorials/abap-environment-create-service-consumption-model.html

Best regards
Bernhard

[Muthu_raja · Accepted solution]

Hello bernhard.grusie

Thanks for your reply!.

1. this https://help.sap.com/docs/abap-cross-product/roadmap-info/integration-services Outbound SQL via CDS External Entities means we can natively fetch data from third party db via ABAP CDS View entity like how we are reading data from HANA db ? Please correct me if I am wrong

2. We will have create odata service in the third party db layer and consume it in the ABAP Cloud ?

[bernhard_grusie · Accepted solution]

Hi Muthu

1. Mid-/Long-Term the answer is “yes”

With the 2408 delivery we will first focus on the “Secondary DB Connection” scenario: It will be possible to access a CDS External Entity within an ABAP SQL SELECT-Statement and by specifying a so called “Logical External Schema” the ABAP SQL Runtime will use corresponding Virtual Tables and HANA SDA Remote Sources to access the remote DB.

2. Yes

Best regards
Bernhard

[vishnucta]

Hi,
How abut trying some open connectors?

Connectors Docs Catalog | SAP Open Connectors (ondemand.com)

[Muthu_raja]

Hello Vishnu,

Can I consume this in the RAP Framework ? I am looking to integrate in the BTP layer