Q&A

You must sign in to ask a question. If you do not have an account, you can register here

How to set default values for web services parameters format_parameter and reduced_format_parameter
answered 02-07-2021 06:59:10 -0400

Using Denodo 7 2019 09 03 When publishing a web service I have set default representation to JSON and disabled all others. I import the service to Azure API Management and discover it says: Default value must be present in the list of values ...

Answers: 3

Rest Web service End point

getting 'statement too complex' issue while doing 'data catalog vdp sync refresh'
answered 02-07-2021 06:56:15 -0400

getting 'statement too complex' issue while doing 'data catalog vdp sync refresh'. i tried to check which view is creating this issue. but i'm unable to see any log on this. i could see some error details like 'Java class file format limit(s) exceeded:...

Answers: 1

JSON Datasource Request
answered 01-07-2021 08:26:20 -0400

Hello, Is there a way to send a the current user name logged in or current session in a JSON Data Source Request. PS: I don't want to create 2 views and create a derived view just to pass the session id. Would it be possible to pass it directly in th...

Answers: 1

JSON Data Source

Truncating Oracle cache table through DENODO Scheduler.
answered 01-07-2021 06:14:59 -0400

Hi , I have a situation where I have to schedule a DENODO job through which I can run 'Truncate table ' command so that Cache is truncated everyday . May I know how can I achieve it ? As in, what type of data source & Job type I should use ? ...

Answers: 1

How to import snowflake stored procedures in Denodo
answered 01-07-2021 06:12:46 -0400

We can't able to import snowflake stored procedures into Denodo , can you please let us know if any work around .

Answers: 3

snowflake

No suitable driver exception when trying to connect using Jmeter
answered 30-06-2021 07:30:44 -0400

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to se...

Answers: 3

Jmeter JDBC AWS SQL

Move view from a folder to a database
answered 30-06-2021 07:28:23 -0400

Hi Team, I am working on denodo 8.0. So i created few sub-folders with a virtual database folder 1 folder 2 folder 3 Bow i want to move the folder 1 to virual database 1 , folder 2 to virtual database 2 and folder 3 to virtual database 3. How to pr...

Answers: 1

command line to get the Execution Trace of one query
answered 30-06-2021 06:01:28 -0400

Hi Team, Do we have the command line to get the Execution Trace of query, I understand we can get it from VDP GUI tool once query running done from VDP client. SIcne we have many query needs to run and compare the execution tace and we want to have pyt...

Answers: 3

Execution Trace command

Users Access / Privileges
answered 30-06-2021 05:31:39 -0400

can i just run a quick check here to understand the privileges for users? if the privileges are set for the VDP, is it the same as the access for the data catalog for the users?

Answers: 1

#privileges #users #denodo

Denodo JDBC connector for PostgreSQL 11
answered 30-06-2021 02:38:05 -0400

Hi, I am trying to connect to a PostgreSQL 11 from Denodo 7.0, but the latest available JDBC driver seems to be for PostgreSQL 10. Does any of you know if there exists a JDBC connector for PostgreSQL 11 available in Denodo 7.0? If not, is it safe to us...

Answers: 1

Denodo 7.0 PostgreSQL