You can translate the question and the replies:

Can we build/deletion DV objects in VDP through access the RestFul API?

Hi team, Do we have ways to created DV base views, derived views, delete existing views in VDP side through access REST API?
user
15-09-2020 13:24:45 -0400

3 Answers

Hi, In the Denodo Platform, Restful API is used for publishing the contents of the entire Virtual DataPort server. Therefore, you can insert, update, select, and delete data over a view using the RESTful Web service but at this movement, it's not possible to create or delete the view from Virtual DataPort using Restful API. For more information, you can refer to the [RESTful Web Service](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/restful_web_service/restful_web_service) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
16-09-2020 07:23:51 -0400
if we want to create/delete some views in VDP by scripts, how can we do that? such as using python / shell ?
user
17-09-2020 02:09:56 -0400
Hi, To create or delete view in the Virtual DataPort by using Python script, for that you need to connect the Virtual DataPort from python using both JDBC and [ODBC](https://community.denodo.com/docs/html/browse/latest/vdp/developer/access_through_odbc/access_through_odbc) drivers. You can also utilize the Python packages like JayDeBeApi. Then, you can pass any VQL query from Python to execute in the Virtual DataPort. You could find the drivers present at the following locations: * JDBC - <DENODO_HOME>\tools\client-drivers\jdbc * ODBC - <DENODO_HOME>\tools\client-drivers\odbc For more information, you can refer to the following documents and similar Community question, * [How to connect to Denodo from Python - a starter for Data Scientists](https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists?tag=JDBC+driver). * [Access Through JDBC](https://community.denodo.com/docs/html/browse/latest/vdp/developer/access_through_jdbc/access_through_jdbc) * [Python to run vql shell](https://community.denodo.com/answers/question/details?questionId=9064u000000CeoxAAC&title=python+to+run+vql+shell+%28select+%2C+create+view%2C+desc+view%29). Hope this helps!
Denodo Team
24-09-2020 06:34:23 -0400
You must sign in to add an answer. If you do not have an account, you can register here