oData + Tableau

1
We created a oData Service using Mendix 6.6.0 : http://localhost:8080/odata/ChangeRequestsODataservice/ The service works fine in excel We could invoke the service without issues in chrome as well. We get the below response : <service xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom" xml:base="http://localhost:8080/odata/ChangeRequests_OData_service/"> <workspace> <collection href="ChangeRequests"> <atom:title>ChangeRequests</atom:title> </collection> </workspace> </service> But in Tableau Desktop 9.3.5, we get the error "Bad OData Format. Make sure you are using a URL that points to a valid OData Source." Any hints on what could be the issue? NOTE : We seem to have followed all the steps in https://world.mendix.com/display/howto50/Exposing%20data%20to%20BI%20tools%20using%20OData Also, if i publish this to sandbox, what should the url be?
asked
3 answers
1

In Tableau, you have to point to a specific resource within the service:

http://localhost:8080/odata/ChangeRequestsODataservice/Resource

answered
1

Please make sure you have also got the odata request handler enabled in the cloud. Otherwise you won't be able to access the OData resource.

answered
0

What should the URL be if the service is to be used in a sandbox. Below URL gives 404

https://demo.mendixcloud.com/odata/ChangeRequestsODataservice/ChangeRequests – Srinivas (2016-07-29)

answered