Solved the integration problem with the consuming applications, now you can work with Denodo at your own. The goal is to create derived views as needed and finally add the top derived view as implementation of 'i_client_info' interface.
You already know how to create derived views using the available operations (selection, union, join, flatten, minus, intersect). This topic was covered in the Basics tutorial / DV First steps / Simple derived views.
The derived view must have fields that match the definition of the interface. In the example of 'i_client_info' interface, the schema is the shown in the image below.
This schema is very similar to the schema of the 'client_with_bills' view, so let's reuse it!
As you only need one view, to create the new derived view you should use the selection operation to model the proper schema. You can follow these steps:
New > Selection.
The last step of this tutorial is to configure the 'i_client_info' interface to use 'client_info_impl' as implementation view. So, open the interface in the workspace double-clicking on it and pressing "Edit" button.
Now, open the Implementation tab. Here you have to drag the implementation view of the interface (see next screenshot).
When done, click on Ok button to update your interface.
Ok, your work have been done! Well... not yet... only a last step, let's test again your services (the same steps covered in the Invocation section) to see if when the Services are queried, Denodo executes the implementation view of the interface.
For example, test the REST data service using this URL: http://127.0.0.1:9090/server/tutorial/customer/views/i_client_info?client_id=C005
and test the SOAP data service using in SOAPui application the same request as before:
You are finished the Denodo Data Services Tutorial set.