You can translate the question and the replies:

Accessing Open Data API

Hello there, I was just curious, how can you access an Open Data API with Denodo to retrieve Data in real time to be provided as a web service, self-service, or views that can be combined with other disparate data sources? Thanks in advance.
user
17-08-2017 14:49:43 -0400

3 Answers

Hi, To connect to an Open Data API using Virtual DataPort, you have to create a new data source in Virtual DataPort Admin tool based on the type of the Open Data API such as Web Service, JSON, XML… Over the created Virtual DataPort data source you can create base views. Then, you can combine these views to create new derived views. Lastly, you can publish these views as an web service (REST or SOAP), or even access the views by using the Information self-service tool. For more information I would suggest you to have a look at the sections "[Creating Views]( https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_views)", “[Creating derived views]( https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/creating_derived_views)” and “[Publication of Web Services]( https://community.denodo.com/docs/html/browse/6.0/vdp/administration/publication_of_web_services/publication_of_web_services)” from Virtual DataPort Administration Guide. Hope this helps you!
Denodo Team
21-08-2017 08:24:43 -0400
This does help, thanks! One last question: Does this require the admin user from mantaining the API's?
user
21-08-2017 08:51:38 -0400
Hi, You can provide the admin privilege to a particular user/role. By doing that any normal Virtual DataPort user with this privilege can maintain the elements created from an API. Besides this, you can assign "connect" privilege to the virtual database in which you have these elements created and then click on "edit" link and manually select the elements and assign "read","write","update" and "insert" privilege to a specific user or role. For more information, I think you can refer to this official documentation on [User and Access Right in Virtual DataPort](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#user-and-access-right-in-virtual-dataport) from Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
23-08-2017 07:32:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here