Web Services are software systems designed to support interoperable machine-to-machine interaction over a network. In this section we are going to talk about SOAP Web Services. This Web Services use SOAP (Simple Object Access Protocol) as protocol to exchange messages. Following the specification, the messages are:
Denodo can publish base/derived views/interfaces as Web Services to enable external applications that cannot use the JDBC or ODBC interfaces, to retrieve data from the Data Virtualization layer.
Let's create your first SOAP Data Service in Denodo. These are the steps:
"New > Data service > SOAP Web service".
In the first tab (Operations) you can add new operations to the Web Service. You only have to drag any view/stored procedure/interface to this dialog. In this example, you are going to create a SOAP Web Service to search clients using the 'ID'. To do this, you have to drag the previously created 'i_client_info' interface to the workspace.
What kind of things are you able to do now?
Ok, your SOAP Web Service definition is complete but there is an important point to keep in mind: security. By default, created Web Services doesn't have any authentication method so any person could use it. Surely, you will want to protect the access to the service by configuring an authentication method. This task can be done in the second tab (Settings).
There are several authentication methods available:
For this example, select WSS Basic with VDP method (leaving empty the Accepted user(s) field) to delegate the authentication to the Denodo server (users with privileges to connect and execute queries in Denodo will have access to the Web Service).
That's all! Finally, click on "Ok" button to create the SOAP Web Service.
In the next section you are going to see the same process but, in this case, for creating REST Web Services.