You can translate the question and the replies:

Publish derived view as DB

Hi, Is it possible to publish a derived view as a DB that will become a datasource for an external application? Thanks a lot LDB
user
18-09-2019 05:40:38 -0400

2 Answers

Hi, Virtual DataPort is based on a client-server architecture. Hence I was able to access the Virtual DataPort views from External clients using the below interfaces: * Using the JDBC interface (Java Database Connectivity). Virtual DataPort provides a JDBC client driver (located in <DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar) using which I was able to connect to Virtual DataPort server from the external JDBC clients (DBeaver) and query the derived views. For more details, you can refer to [Access Through JDBC](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/access_through_jdbc#access-through-jdbc) section of the Virtual DataPort Developer Guide. * Using the ODBC interface (Open Database Connectivity). *Virtual DataPort provides an ODBC interface and an ODBC driver for ODBC client driver (located in <DENODO_HOME>/tools/client-drivers/ODBC directory). For more details, you can refer to [Access Through ODBC](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/access_through_odbc#access-through-odbc) section of the Virtual DataPort Developer Guide. Similarly, I can also access to Virtual DataPort Server using** ADO.NET Data Provider**, **SOAP** and **REST Web Service interfaces**. For more details about the mechanisms available for client applications to access Denodo Virtual DataPort, you can refer to the [Introduction](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/introduction/introduction#introduction) section of the Virtual DataPort Developer Guide. Hope this helps!
Denodo Team
19-09-2019 08:24:16 -0400
Thank you so, I've just find and try the exercise with DB Visualizer that, along with your answer, has help me to find the answer.
user
19-09-2019 09:39:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here