{"id":27829,"date":"2024-04-22T09:00:42","date_gmt":"2024-04-22T17:00:42","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/introducing-public-preview-of-the-sap-odata-connector\/"},"modified":"2024-04-22T09:00:42","modified_gmt":"2024-04-22T17:00:42","slug":"introducing-public-preview-of-the-sap-odata-connector","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/introducing-public-preview-of-the-sap-odata-connector\/","title":{"rendered":"Introducing public preview of the SAP OData connector"},"content":{"rendered":"
We are happy to announce that the SAP OData connector is now available in public preview in all regions for Power Apps and Power Automate.<\/span> <\/span>During public preview, <\/span>you<\/span><\/i> can test the ability to create Power Automate cloud flows that access SAP data through the SAP OData connector, a premium connector, and <\/span>provide feedback<\/span><\/a>.<\/span> The availability of the SAP OData connector opens access to scenarios across the SAP product portfolio.\u00a0<\/span>\u00a0<\/span> Currently the SAP OData connector supports Basic, Anonymous, and API key authentication. We are working on additional authentication mechanisms to enhance the connector and expect to make this available as we approach general availability for the SAP OData connector this summer. <\/span>\u00a0<\/span> In a lot of cases the SAP System (and the SAP OData services) are not accessible from the internet\u2014and in turn are not accessible from Power Automate. To allow Power Automate to connect to these SAP OData services, you need to \u201cproxy\u201d \/ route them through the corporate firewall. Thanks to the on-premises data gateway you don\u2019t need to make any changes to the firewall but can install the on-premises data gateway (see also, <\/span>On-premises data gateway – Power BI | Microsoft Learn<\/span><\/a>).\u00a0<\/span>\u00a0<\/span> Once the data gateway is installed, you should see it in your Power Automate Environment\u00a0<\/span>\u00a0<\/span> https:\/\/powerapps.microsoft.com\/en-us\/blog\/run-your-enterprise-on-power-platform-with-new-enterprise-application-templates\/<\/span><\/a>\u00a0<\/span>\u00a0<\/span><\/p>\n SAP Procurement template for Power Platform – Power Platform | Microsoft Learn<\/span><\/a>\u00a0<\/span><\/p>\n
\nTo learn more about the SAP OData connector please go to <\/span>Microsoft learn<\/span><\/a>.<\/span>\u00a0<\/span>
\nNOTE: There is a known issue with this preview within Logic Apps. <\/span>\u00a0<\/span><\/p>\nAuthentication\u00a0<\/span>\u00a0<\/span><\/h2>\n
\nThe SAP OData Connector supports adding API headers in the request and works well with API Management solutions like Azure API Management or SAP API Management on the SAP Business Technology Platform. If your APIs are protected with API-Keys, you can add these keys to the SAP OData Connector in your cloud flow so that a verification in the API Management solution can be performed.\u202f<\/span>\u00a0<\/span>
\nIf you have the necessary SAP licenses in place, this allows you to create Single Sign-On end-to-end solutions even today to access your SAP system in a secure way.\u202f<\/span>\u00a0<\/span><\/p>\nLeveraging the on-premises data gateway<\/span>\u00a0<\/span><\/h2>\n
\nNote<\/span><\/b>: Unlike with the SAP ERP Connector (<\/span>SAP ERP – Connectors | Microsoft Learn<\/span><\/a>), you do not need to download and install the SAP .Net Connector. Installing the on-premises data gateway is all you need (but make sure to install the latest version).<\/span>\u00a0<\/span>
\nThe steps needed are outlined below:<\/span>\u00a0<\/span><\/p>\n\n
\nNote<\/span><\/b>: If you don\u2019t see <\/span>Gateways <\/span><\/i>on the side panel, make sure to select on <\/span>\u2026 More<\/span><\/b> -> <\/span>Discover all<\/span><\/b> and pin <\/span>Gateways<\/span><\/b> to the side panel.<\/span>\u00a0<\/span>
\n <\/span>
\n\u00a0<\/span>
\nAt this point you are ready to create a new flow connecting to your SAP system through the on-premises data gateway. Create a new flow (as mentioned above) with a trigger of your choice and add the SAP OData query action.<\/span>\u00a0<\/span>
\n
\nYou will be asked to setup a connection to your SAP system. To connect to a system that is only available from within the company firewall (where the on-premises data gateway is installed), select your Data Gateway from the list:<\/span>\u00a0<\/span>
\n
\nProvide the required information (but using the OData Base UR<\/span>I <\/span>L <\/span>from your local SAP System), e.g., <\/span>https:\/\/<\/span>mylocal.sap.system<\/span><\/b>:50000\/sap\/opu\/odata\/iwbep\/GWSAMPLE_BASIC\/<\/span><\/a>\u00a0<\/span>
\nNote<\/span><\/b>: You can test this URL first internally <\/span>https:\/\/mylocal.sap.system:50000\/sap\/opu\/odata\/iwbep\/GWSAMPLE_BASIC\/<\/span><\/a> and verify (e.g., with your Mobile device) that this URL is not accessible from outside of the intranet.\u00a0<\/span>\u00a0<\/span>
\n
\nYou may now use the SAP OData Connector. Select the Entity that you are interested in, e.g., ProductSet, and run the flow as outlined below. <\/span>\u00a0<\/span>
\n
\n
\nIf you have feedback, please go to <\/span>https:\/\/aka.ms\/sapodatafeedback<\/span><\/a> \u00a0<\/span>
\nSAP and Power Platform is an area of continued investment for Microsoft, to learn more, see these other useful resources:<\/span>
\nhttps:\/\/learn.microsoft.com\/en-us\/connectors\/sapodata\/<\/span><\/a>\u00a0<\/span>\u00a0<\/span><\/p>\n