[progress Communities] [progress Openedge Abl] Forum Post: Re: How To Connect Data Direct...

  • Thread starter Thread starter Hans De Smet
  • Start date Start date
Status
Not open for further replies.
H

Hans De Smet

Guest
Hi Godfrey, I found a description of this error in a previous reported case. This might help: "Tableau is different than most other OData clients that I have used in that it wants the URL to a specific entity (table). Most other OData clients are looking for the root URL of the service. To specify a URL for Tableau, copy the OData Service URL from the Data Source configuration screen and then add the name of the table you want Tableau to use. For example I have a data source named SQLServerOPTest and I want to add the Customer table then I would specify the URL service.datadirectcloud.com/.../Customers Note that I have to use the name of the OData entity that maps to the table and the case of the entity name must match. For example in my database the name of the table is Customer. In the OData model the name that is exposed is pluralized so I must us the name Customers. Tableau will successfully access the data when a URL with the entity name appended to the root URL is used To see the name of the entities exposed by the OData service, submit a GET request to the root URL for the service. You can enter service.datadirectcloud.com/.../SQLServerOPTest either in a browser or in a REST tool such as Postman. For my service the response is Default ... " Kind regards, Hans

Continue reading...
 
Status
Not open for further replies.
Back
Top