Call SAP OData Service in Logic App through On-Premise Data Gateway

%3CLINGO-SUB%20id%3D%22lingo-sub-1321999%22%20slang%3D%22de-DE%22%3ECall%20SAP%20OData%20Service%20in%20Logic%20App%20through%20On-Premise%20Data%20Gateway%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1321999%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20want%20to%20call%20an%20Odata%20Service%20of%20my%20SAP%20system.%20The%20service%20is%20only%20available%20in%20the%20private%20network%2C%20therefore%20the%20call%20only%20works%20via%20an%20On%20Premise%20Data%20Gateway.%20%3CBR%20%2F%3EThis%20gateway%20is%20already%20set%20up%20and%20works%20in%20the%20Azure%20Portal.%20%3CBR%20%2F%3EUsing%20a%20Postman%20Collection%20I%20have%20built%20a%20Custom%20Connector%20which%20I%20call%20in%20my%20Logic%20App.%20%3CBR%20%2F%3EThe%20connector%20is%20connected%20via%20the%20gateway%20to%20a%20computer%20that%20is%20logged%20on%20to%20the%20VPN.%20%3CBR%20%2F%3EMy%20problem%20is%20that%20I%20can't%20provide%20the%20authentication%20data%20for%20the%20logon%20to%20the%20SAP%20system%20and%20therefore%20for%20the%20call%20of%20the%20OData%20service.%20%3CBR%20%2F%3EIs%20there%20an%20possibility%20to%20include%20this%20authentication%20data%20in%20the%20request%3F%20%3CBR%20%2F%3EI%20have%20already%20been%20able%20to%20connect%20successfully%20to%20the%20SAP%20system%20via%20that%20gateway%2C%20but%20only%20to%20call%20RFC%20modules%2C%20for%20example.%20Is%20there%20a%20way%20to%20do%20this%20with%20an%20OData%20service%3F%20%3CBR%20%2F%3EWhat%20is%20the%20best%20way%20for%20calling%20an%20on-premise%20SAP%20OData%20Service%20in%20a%20Logic%20App%3F%20%3CBR%20%2F%3EOr%20is%20there%20maybe%20a%20way%20to%20send%20an%20Http%20request%20via%20the%20On%20Premise%20Data%20Gateway%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1321999%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecustom%20connector%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELogic%20App%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOdata%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eodata%20service%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOn%20Premise%20Data%20Gateway%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESAP%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414190%22%20slang%3D%22en-US%22%3ERe%3A%20Call%20SAP%20OData%20Service%20in%20Logic%20App%20through%20On-Premise%20Data%20Gateway%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F629405%22%20target%3D%22_blank%22%3E%40Julia2195%3C%2FA%3E%26nbsp%3Bconsider%20using%20a%20REST%20custom%20connector%20with%20auth.%20OData%20is%20a%20REST%20endpoint.%20Logic%20App%20support%20REST%20both%20as%20native%20HTTP%20request%20as%20well%20as%20wrapped%20in%20a%20convenient%20custom%20connector%2C%20the%20later%20which%20may%20further%20make%20use%20of%20the%20On-Premises%20Data%20Gateway%20you%20noted%20you%20needed%20to%20access%20the%20network%20where%20you%20SAP%20OData%20endpoint%20is%20present.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fcustom-connectors%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fcustom-connectors%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fmodules%2Flogic-apps-and-custom-connectors%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Flearn%2Fmodules%2Flogic-apps-and-custom-connectors%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.serverless360.com%2Fblog%2Fcustom-connectors-in-azure-logic-apps%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.serverless360.com%2Fblog%2Fcustom-connectors-in-azure-logic-apps%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20can%20also%20use%20Azure%20Logic%20Apps%20Integration%20Service%20Environment%20(ISE)%2C%20then%20you%20bring%20Logic%20App%20in%20the%20same%20network%20as%20SAP%20and%20can%20just%20use%20HTTP%20REST%20actions%20-%20no%20gateway%20required%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fannouncing-azure-integration-service-environment-for-logic-apps%2F%22%20rel%3D%22noreferrer%20noopener%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fannouncing-azure-integration-service-environment-for-logic-apps%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

I want to call an Odata Service of my SAP system. The service is only available in the private network, therefore the call only works via an On Premise Data Gateway.
This gateway is already set up and works in the Azure Portal.
Using a Postman Collection I have built a Custom Connector which I call in my Logic App.
The connector is connected via the gateway to a computer which is logged on to the VPN.
My problem is that I can't provide the authentication data for the logon to the SAP system and therefore for the call of the OData service.
Is there a possibility to include this authentication data in the request?
I have already been able to connect successfully to the SAP system via that gateway, but only to call RFC modules, for example. Is there a way to do this with an OData service?
What is the best way for calling an on-premise SAP OData Service in a Logic App?
Or is there maybe a way to send an Http request via the On Premise Data Gateway?

Thank you!

2 Replies

@Julia2195 consider using a REST custom connector with auth. OData is a REST endpoint. Logic App support REST both as native HTTP request as well as wrapped in a convenient custom connector, the later which may further make use of the On-Premises Data Gateway you noted you needed to access the network where you SAP OData endpoint is present.

https://docs.microsoft.com/en-us/connectors/custom-connectors/

https://docs.microsoft.com/en-us/learn/modules/logic-apps-and-custom-connectors/

https://www.serverless360.com/blog/custom-connectors-in-azure-logic-apps

 

You can also use Azure Logic Apps Integration Service Environment (ISE), then you bring Logic App in the same network as SAP and can just use HTTP REST actions - no gateway required:
https://azure.microsoft.com/en-us/blog/announcing-azure-integration-service-environment-for-logic-ap...

For people reading this thread in 2021, we now have a private preview for OData connector. If you are interested, register at http://aka.ms/odatapreview