Publication of Web Services¶
Virtual DataPort can publish views as Web services to enable external applications that cannot use the JDBC or ODBC interfaces, to retrieve data from Virtual DataPort.
You can deploy these Web services to the Web service container embedded
in the Denodo Platform, or generate a war
file to deploy them in an
external J2EE applications server.
In Virtual DataPort, there are two types of Web services:
SOAP Web services (Simple Object Access Protocol - SOAP - version 1.1): publish a set of operations that when invoked, the Service executes a specific a VQL query over a view or a Denodo stored procedure.
REST Web services: publish a set of views and associations. In a REST Web service, you do not define operations over these views. Instead, the Service follows the same RESTful approach as the Denodo RESTful Web service (see section RESTful Web Service).
The main difference with the SOAP Web services is that the SOAP ones are “operation-oriented” and the REST ones are “resource-oriented”.
These Web services provide four different representations of the data:
HTML
XML
JSON (JavaScript Object Notation)
RSS
This section describes how to create and deploy SOAP and REST Web services.
Both types provide several authentication methods to validate the credentials of the users (see section Web Services Authentication).
In the previous versions of the Denodo Platform, there was only one type of Web service, which combined the SOAP and REST representations. In the current version of the Denodo Platform, the Web services have been divided into two: the SOAP ones and the REST ones. The reason is that the REST Web services have changed from an “operation-oriented” approach to a “RESTful” approach.
The Web services created with the previous versions of the Platform still work, but they are deprecated. We have moved the sections about the managing of the old Web services to the appendix Web Services Created with Previous Versions of the Denodo Platform.
Privileges Required¶
To manage web services (REST and SOAP) the user needs these privileges:
To create and modify web services (SOAP and REST):
Create data service over the database in which the user creates the web service
Execute over the views that the service publishes.
To deploy, redeploy and undeploy web services: Write over the database of the web service or the web service itself.
To delete web services: Write over the database of the web service or the web service itself.
See more: User and Access Right in Virtual DataPort.