How to access Denodo Base view in SQL server?

I created base view in Denodo from mutiple source like oracle and other sorces. How can i access the baseview from SQL?
user
17-05-2019 06:45:29 -0400

1 Answer

Hi, You can access Denodo from third-party SQL clients, SQuirreL SQL, DBVisualizer or SQL Workbench through JDBC. You will have to configure or add a Denodo Driver into the client to connect to the Denodo database. The denodo driver is located at <DENODO_HOME>/tools/client-drivers/jdbc You will also need the class information which is com.denodo.vdp.jdbc.Driver and connection string syntax which is jdbc:vdb://<hostName>:<port>/<databaseName> For more details, you can refer to this article https://community.denodo.com/kb/view/document/Connection%20using%20third%20party%20SQL%20clients?category=Northbound+Connections Hope this helps!
Denodo Team
21-05-2019 20:35:07 -0400
You must sign in to add an answer. If you do not have an account, you can register here