Q&A

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

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

JDBC Jmeter 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

About Compatibility of solution manager of version 8.0 to denodo servers of version 7
answered 30-06-2021 02:30:32 -0400

if Solution Manager 8.0 is incompatible with Denodo Platform servers of earlier major versions (7.0, 6.0…). what if we are using some of 7 version servers and some 8th version servers? how to solve this issue?

Answers: 3