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:

Note

“SOAP Web services” are not currently supported on the Design Studio but future updates will extend the current options to progressively add them.

  • 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:

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).

Privileges Required

To create and manage web services (REST and SOAP), the user needs these privileges:

  • To create and modify web services (SOAP and REST):

    1. Create data service over the database in which the user creates the web service.

    2. Execute over the views that the service publishes, or their database.

  • 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.