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
16-03-2023 11:56:15 -0400

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](, JSR-168/286 Portlets and Microsoft Web Parts (see section [Publication of Views as Widgets]( and the RESTful Web service (see section [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]( Knowledge Base article for more information.The [How to connect to Denodo from Python - a starter for Data Scientists]( 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]( and the Support Team will assist you. Hope this helps!
Denodo Team
17-03-2023 11:52:18 -0400
You must sign in to add an answer. If you do not have an account, you can register here