How to connect and read data from SAP ECC BAPI using azure data factory

Jeevi Danda 71 Reputation points
2022-10-26T20:39:37.047+00:00

Hi,

I am trying to read/copy data from SAP ECC BAPI (by proving the BAPI name). Is that possible through ADF? When I checked the SAP ECC connector/linked service, It is expecting me to provide a URL with user name and password. But I only have SAP Server name, SAP System Number, SAP Client name, SAP User Name and SAP Password information. Please let me know how I can call SAP BAPI directly and get the information.

Thanks,
Chiranjeevi

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,914 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,271 Reputation points Microsoft Employee
    2022-10-27T20:56:18.603+00:00

    Hello @Jeevi Danda ,

    Welcome to the MS Q&A platform.

    I am going through this documentation page and see URL is the mandatory parameter. I don't think you can use the SAP server name and SAP system number to connect using the linked service.

    also, I found the below article to get the SAP system URL.
    Prerequisite: You must be having SAP GUI Logon pad.

    https://blogs.sap.com/2013/12/17/how-to-check-sap-system-url/

    I hope this helps. Please let me know if you have any further questions.

    1 person found this answer helpful.