Hi there,
In Lumira, I create a dataset by choosing source 'Query with SQL' and 'Generic OData 2.0 - OData Connector'. I enter the URI I get from SAP gateway client. The URI is like:
https://server:port/sap/opu/odata/sap/C_ODITEM_QUERY_HOME_CDS/. Then I enter the my user, my password and the proxy. An error message shows:
Actually the URI is fine if I use in Chrome. The issue seems to be an authentication issue. And I tried to add the my user and password into the URI however not work https://user:password@server:port/sap/opu/odata/sap/C_ODITEM_QUERY_HOME_CDS/
I find the corresponding information in this thread: https://archive.sap.com/discussions/thread/3941514
Does anyone have ideas for this issue?
Thank you.
Clark
Clark - is there a way for you to check that the OData from the SAP Gateway is OData v2? See https://archive.sap.com/discussions/thread/3702102
Hi Tammy,
Much thanks for the quick response. I am using an S4HANA system. Could you share with me where can I find the OData version?
Kind Regards,
Clark
Hi Clark - see Jamie Cawley's reply in this thread on how to check it: https://archive.sap.com/discussions/thread/3853207
Hi Tammy,
Yeah. DataServiceVersion="2.0".
Any ideas how I can fix the issue?
Regards,
Clark
Do you have access to the OData service in S4? I'm not sure how the security works in S4 - it would be nice to see if a security trace could be done on your ID when you try to logon to the service. In ECC the transaction is STAUTHTRACE
Hi Tammy,
I have not used this tool. So I have some try. I set the system wide trace on and activate the trace.
When I use Lumira to acess the metadata, no trace is available.
When I use Chrome to acces the metadata, some trace like below. The metadata can successfully show in Chrome.
Kind Regards,
Clark