Edit

Troubleshoot the SAP Table, SAP Business Warehouse Open Hub, and SAP ODP connectors in Azure Data Factory and Azure Synapse

  • Article

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This article provides suggestions to troubleshoot common problems with the SAP Table, SAP Business Warehouse Open Hub, and SAP ODP connectors in Azure Data Factory and Azure Synapse.

Error code: SapRfcDestinationAddFailed

  • Message: Get or create destination '%destination; failed.

  • Cause: Unable to connect to SAP server, which may be caused by the connection issue between the machine with an integration runtime installed and SAP server, or wrong credentials.

  • Recommendation: If the error messages are like '<serverName>:3300' not reached, test connection in the machine with an integration runtime installed first by following the PowerShell command below:

    
Test-NetConnection <sap server> -port 3300

Next steps

For more troubleshooting help, try these resources: