Error authenticating to connector: Unauthorized request: msg=The request to SAP failed with the status code: 401 and SAP error message: Unauthorized.

Question

Hi,
I have created XSODATA to expose SAP Hana tables. I am trying to use that to extract by Appflow. I am getting the below error:

Below are few more details:
1. In the Client Number, I have put in 000
2. There is SSO enabled on my SAP systems. In Appflow, I have tried to bypass the SSO.
3. we dont have SAP BW stack.

Please suggest, if its possible to use XSODATA in Appflow for extraction of data.

Giovanni Lauria · Answer

Did you check the HANA Reports for wrong roles ?

Follow this SAP link.
https://community.sap.com/t5/enterprise-resource-planning-blogs-by-members/extracting-sap-data-from-your-on-premise-sap-system-with-amazon-appflow-sap/ba-p/13546081

And this repost: https://repost.aws/questions/QUv75yYdAnRXmsBFUPq7dW7g/connection-between-aws-appflow-and-sap-odata-fails-with-error-401

Error authenticating to connector: Unauthorized request: msg=The request to SAP failed with the status code: 401 and SAP error message: Unauthorized.

Relevant content