Q&A BY TAG 'Access Denodo Express'
How to connect local sql server 2019 db and oracle sql db 11g to denodo express?
answered
22-08-2022 06:12:20 -0400
Hello, How to connect local sql server 2019 db and oracle sql db 11g to denodo express? Not sure what exactly needs to be put for connecting the db with denodo. Please help. Thanks.
Answers:
1
Access Denodo Express DENODO connection How to connect the Denodo Server to the Microsoft SQL Server Oracle 11g
How to connect using JDBC driver in Python?
answered
08-03-2022 06:08:14 -0500
###Connection using JDBC import jaydebeapi hostname = 'server name' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '####' password = '#####' path = '/C:/Users/abc/Desktop/Projects/denodo-vdp-jdbcdriver.jar' url = 'jdbc:vdb://'+hostname+':'+...
Answers:
6
Aggregate query for a denodo view with bind variable
answered
27-12-2021 22:45:11 -0500
Hi - I have a Interface denodo view with 10 columns and storeid as bind variable. When i tried to run a query with aggregate function, it returns syntax error. Also I need to run the query without passing any value to the bind variable column, select...
Answers:
3
Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks
answered
14-09-2021 09:11:26 -0400
I have a problem where my requirement is to Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks . The problem is to set up everything inside docker image so that any developer is able to use denodo...
Answers:
3
Excellent tutorial. Need help with filters resolvers
answered
15-02-2021 06:36:52 -0500
Thanks for tutorial. I got great Idea. Can you help me How your Query resolver? You explained filters. But I have JSON data . I need to execute this Query on JSON Data.
Answers:
3
Related to:
GraphQL in Action - Advanced Query Capabilities
Help Access Denodo Express GraphQL Denodo Query Exceqution Plan
Bring rules of the tables to base views
answered
12-02-2021 03:48:37 -0500
we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...
Answers:
1
Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations
answered
01-02-2021 07:04:36 -0500
Hello, Am using Spring Boot 2.3.4 and spring-boot-starter-data-jpa in order to connect to denodo 8.0 My application.yml is as follows spring: jpa: open-in-view: false show-sql: true generate-ddl: false hibernate.ddl-auto: none properties: hibernate:...
Answers:
1
Denodo 8.0 Access Denodo Express does not support ddl operations com.denodo.connect.hibernate.dialect.DenodoDialect JDBC ddl
Cannot connect to Denodo Virtual port administration
answered
28-08-2020 07:58:04 -0400
Cannot connect to Denodo Virtual port administration after installing denodo express 8.0. Also, VDP server is always running.Not stopping if try to stop VDP server and throwing error "Internal error"
Answers:
1
how to join two table columns using like operator with wildcard search
answered
05-06-2020 07:57:53 -0400
Hi Aall, I have requirement like here. I have two tables first table has a column name is Test which contains data like below Test: SMSReminder Reminder second table has a column called Test1 and data like below Test1 Reminder now I would like to ...
Answers:
1
java.lang.NoClassDefFoundError while trying to connect to hive
answered
03-03-2020 07:37:34 -0500
hello, i have a problem concerning connecting to hive database. i have denodo virtual dataPort version 7 and the quickstart cloudera vm with cloudera version 1.1 .0 but everytime i try to test the connection the following error appears Unable to es...
Answers:
1
Hive Access Denodo Express Hive Issue AWS HIVE JDBI Connection URI