Edit

Share via

Get started with the SAP ERP connector

  • Article

The SAP ERP connector for Power Platform helps you seamlessly integrate your SAP systems with Microsoft Power Platform. This article walks you through setting up the connector as a proof of concept.

Important

The settings and recommendations presented in this article are not intended for production use. Review the Microsoft Power Platform admin documentation and consult your security team, internal policies, and Microsoft Partner for guidance in setting up the SAP ERP connector in a production environment.

Prerequisites

It's important that you review the following to ensure you can move forward with the steps to connect Power Platform and SAP with the SAP ERP connector:

Set up your on-premises data gateway

An on-premises data gateway acts as a bridge to securely transfer data between on-premises systems and Microsoft cloud services. Installation of the on-premises data gateway includes installing several components on the same network domain as the Windows virtual machine (VM) that hosts the gateway.

  1. Download and install the on-premises data gateway on your Windows VM.

  2. Use the following PowerShell command to verify that your Windows VM can access your SAP instance on port 3300. Replace sap.example.com with your SAP server name.

    powershell telnet sap.example.com 3300

Install the SAP .NET connector

To enable the on-premises data gateway to communicate with your SAP system, you need to install the SAP Connector for Microsoft .NET (NCo) on your on-premises data gateway Windows VM.

  1. Go to the SAP support portal and download the appropriate 64-bit NCo to your Windows VM.
  2. Run the installer. Make sure to select SAP .NET Connector for Microsoft .NET during installation.

Restart the gateway service

  1. Open the on-premises data gateway app.
  2. Select Service Settings.
  3. Select Restart now.

Verify the connection

  1. Go to the Power Platform admin center.
  2. Select Data.
  3. Select On-premises data gateways.
  4. Find and select your new gateway in the list.
  5. Make sure that the status shows as Online.

Create a test flow with the SAP ERP connector

  1. Go to Power Automate and create a flow.
  2. Search for the SAP ERP connector and add a Call SAP function (V3) action to the flow.
  3. Set up a new connection:
    • Name your connection (for example, SAP-Test-Connection)
    • For Authentication Type, select Basic.
    • Choose your on-premises data gateway.
    • Enter your SAP credentials.

Set up and test the SAP action in the flow

  1. In your flow, select the Call SAP function to open the settings panel.

  2. For SAP System, enter your configuration values in JSON format; for example:

    json {"AppServerHost": "sap.example.com","Client": "100" "SystemNumber": "00", "LogonType": "ApplicationServer"}

    For more parameter options, refer to the documentation.

  3. For RFC Name, enter STFC_CONNECTION.

  4. Wait for the input parameters to load.

  5. Enter a test sentence for the required REQUTEXT parameter.

  6. Save your flow.

  7. Select Test.

After you verify that the SAP action is working, learn best practices for building powerful Power Platform solutions that work with your SAP system. You can also try out more complex functions in your flows.

Troubleshooting tips

  • If you see an SAP Library load failure error, make sure that the SAP .NET connector is installed correctly and then restart the on-premises data gateway.
  • For connection issues, double-check your SAP credentials and System ID.
  • Remember that the first connection might take up to two minutes to establish.

Next step

Set up Secure Network Communication