Auth error using OData to read Sharepoint list
I'm trying to read a Sharepoint 2010 list using an OData 2.0 source in SAP BusinessObjects 4.1.
Every time I test the connection I have the same authentication error
A problem occurred while communicating with the provider. Detailed message: Server error: (response: status=401, reason='Unauthorized', request='/myURL/$metadata')
I confirmed that the user name and password are correct, the same for permissions
I made some basic test and I can connect to my OData feed using Excel/PowerPivot and IE for example. Also, I can connect to "sample" OData feeds in SAP BusinessObjects (http://services.odata.org/V3/Northwind/Northwind.svc/)
Any help about it ?
We finally got this working. The main requirement is that SharePoint is configured for BASIC authentication. This may be a sticking point for you as it means that credentials are not encrypted when transmitted. However, the Data Access Guide states that OData connections support only basic HTTP authentication or a GET access token.
In SharePoint 2013 Central Admin, click Manage Web Applications, then select the Web App (1), click Authentication Providers (2), then click the Zone name (3):
In the popup, then enable basic authentication as follows, and save the changes:
Note the warning that credentials will not be encrypted when sending requests.
In the Information Design Tool, create a new Generic OData 2.0 connection and enter the Service Root URI as shown below, replacing the blanked out area of the URI with your own site and specifying an appropriate User Name and Password.
Test Connection should work successfully. Finish the steps to create the connection as normal.
Right-click the new connection in the Local Projects area and select New Data Foundation.
You should be able to see any lists that you have access to listed with other endpoints under the connection. Just add it to the data foundation as if it were a table. Right-click the list and choose Show Table Values to confirm.
Let me know if you need any further clarification.