If you want your client application to utilize the information through stored procedure then, you could create views by importing or developing a new stored procedure in Virtual Dataport and then expose it to client application.
Virtual DataPort uses a VQL language which extends the similar behaviour of SQL. The insert/update is an additional functionality available in Virtual DataPort which you could utilize for inserting/updating statements to modify the data stored in the underlying data source.
For more information, you could refer the [Inserts, Updates and Deletes Over Views](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/inserts_updates_and_deletes_over_views/inserts_updates_and_deletes_over_views#inserts-updates-and-deletes-over-views), and Knowledge Base Article [Executing VQL statements from a stored procedure](https://community.denodo.com/kb/view/document/Executing%20VQL%20statements%20from%20a%20stored%20procedure?category=Custom+Elements) and [Use of Stored Procedures](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/use_of_stored_procedures/use_of_stored_procedures#use-of-stored-procedures)
Hope this helps!!!