You can translate the question and the replies:

Issue in accessing OData4.0 service

Hi Team, OData4.0 service is accessible only from default database (admin). We need to access OData4.0 from other databases as well. Let us know the configuration changes to be done to access it from other databases also. Please help us to resolve this issue.
user
25-06-2021 07:18:26 -0400
code

3 Answers

Hi, The [Denodo OData 4.0 service](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/odata4_service/odata4_service) is used for accessing elements of the Denodo Platform and I would utilize this service, for accessing elements from different Virtual DataPort databases using the following URL: > http://<host>:<web_container_port>/denodo-odata4-service/denodo-odata.svc/<database name>/ For your scenario, for <database name> specify the Virtual DataPort database from which you need to access the views. You could also open OData service by Right-clicking on the view in the Server Explorer of the Virtual DataPort Administration Tool which will provide the link to access that specific view through OData Service. NOTE: All the views in Virtual DataPort are accessible using OData, provided the user should have the right privileges. For modifying the configuration of the OData service, take a look at the [Configuration](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/restful_architecture/odata4_service/odata4_service_configuration#configuration) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
28-06-2021 08:27:30 -0400
code
Hi Team, My database name was denodo and used the below mentioned url http://<host>:<web_container_port>/denodo-odata4-service/denodo-odata.svc/denodo/<baseviewname> which was not working previously. But after changing the database name from denodo to some other xyz db name , it worked. Could you please confirm if denodo is the reserved word?
user
02-07-2021 06:53:54 -0400
Hi, With my experience, I was also not able to access views under a database named "**denodo**" through the OData service. This is a known issue and is expected to be resolved in the later updates. At the moment, you could use the different database name for accessing views through OData. Additionally,** denodo is not a reserved word** and for a detailed list of reserved words, you can take a look at the [Reserved words](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_data_vql/syntax_conventions/syntax_conventions#basic-elements-of-vql-statements-reserved-words) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
13-07-2021 07:07:19 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here