Q&A

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

Dynamic column names generated from a pivot
answered 30-06-2021 08:03:05 -0400

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

Answers: 6

Dynamic Pivot

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

Error loading extension '***'
answered 29-06-2021 04:52:50 -0400

i m trying to upload some wapper jar to extension management via vdp admin tools. i found that every time i got loading error if the file size over 40mb. it shows connection closed. could you tell me how to avoid this problem?

Answers: 1

extension