You can translate the question and the replies:

DBT connection to Denodo

Can DBT consume data from Denodo ? if yes how do I connect to denodo from DBT
user
16-03-2023 11:56:15 -0400
code

1 Answer

Hi, To use Denodo as a data source to DBT you will need to create a **Northbound** connection. The Denodo Virtual DataPort can be accessed via JDBC, ODBC, SOAP, REST, JSON and RSS Web Services (see section [Publication of Web Services](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/publication_of_web_services/publication_of_web_services)), JSR-168/286 Portlets and Microsoft Web Parts (see section [Publication of Views as Widgets](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/publication_of_views_as_widgets/publication_of_views_as_widgets#publication-of-views-as-widgets)) and the RESTful Web service (see section [RESTful Architecture](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/restful_architecture)). To connect to Virtual DataPort, for example, using any JDBC client, the driver information and a valid URL must be provided. The latest version of the JDBC driver is located at: `<DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar` and the class that implements the driver is: `com.denodo.vdp.jdbc.Driver` The syntax of the connection string is: `jdbc:vdb://<hostName>:<port>/[<databaseName>][?<paramName>=<paramValue>[&<paramName>=<paramValue>]* ]` You should refer to the [Connection using third party SQL clients](https://community.denodo.com/kb/en/view/document/Connection%20using%20third%20party%20SQL%20clients?category=Northbound%20Connections) Knowledge Base article for more information.The [How to connect to Denodo from Python - a starter for Data Scientists](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists) Knowledge Base article has additional information on using Python to connect to Denodo. In case you need further assistance and if you have a valid Support Account then you can reach out to Denodo Support by raising a support case on [Denodo Support Site](https://support.denodo.com/MainPage.do) and the Support Team will assist you. Hope this helps!
Denodo Team
17-03-2023 11:52:18 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here