Linked Service with ADF for SAP BW Open Hub

LeandroSerraino-5640 21 Reputation points
2022-02-01T17:21:29.307+00:00

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:
170226-image.png

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:
170206-image.png

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

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

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,528 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2022-02-02T23:51:43.74+00:00

    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:

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

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

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful