You can translate the question and the replies:

Denodo , Stored Procedures, & Insert Updates

Have a questions, Why we need store procedures and insert update operations in Data Virtualization tool.
user
14-03-2018 08:25:09 -0400

1 Answer

Hi, 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!!!
Denodo Team
15-03-2018 09:15:24 -0400
You must sign in to add an answer. If you do not have an account, you can register here