Linked Service with ADF for SAP BW Open Hub

Question

Hi,

We are trying to extract some data form SAP BW (7.3) using ADF Gen2 to Azure SQL. So we created the following linked services:

We followed this doc:
https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-business-warehouse-open-hub

We downloaded and installed 'SAP .NET Conector 3.0' in our Integration Runtime and followed all the other steps.

Test conection is ok:

Then we created a Data Set and verified that can see all Open Hub tables we've got on SAP BW side:

But the problem is when we try to load data. If we click on 'Preview Data' then:

We've checked on SAP BW and doesn't have the function called before. So we are trying to install it.
Is this the correct aproach? I've read somewhere that this function is deprecated.

Thanks!!
Regards

Answer 1

Hello @LeandroSerraino-5640 ,

Thanks for the question and using MS Q&A platform.

As I understand the ask here that you were able to establish connection to SAP BW table using SAP BW OpenHub connector, but you are getting the above error while trying to read/preview the table data.

By looking at the error message it seems like the function/module /BODS/RFC_READ_TABLE2 is missing on SAP side which is causing the issue. And you are trying to install the function. I believe you can add that function to resolve the issue.

But to double confirm on the same, you will have to reach out in SAP community forum or contact SAP support team. As this is not Azure related issue, I recommend getting in touch with SAP support to get the expert advice to avoid discrepancies/delays.

Here are SAP Community links:

• SAP Community forum
• Related error discussed here - 2891200 - Azure Data Factory (ADF) and /BODS/RFC_READ_TABLE2

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators