Q&A

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

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

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

about resources
answered 29-06-2021 04:45:41 -0400

if both version 7 and 8 run in a same computer simultaneously,what is the exact resource need?? like ram 16gm ,harddisk 30gb ,cpu and all? this information not given anywhere, even in resources manager also

Answers: 1

Not able to escape special character in post body
answered 28-06-2021 22:52:32 -0400

Hello, I am trying to pass this expression: { ^ExecuteIfIsNotNull("\"'"customerId\"'" : "\"", @CID, "\", " ,"\"'"customerId\"'" :null, "), ^ExecuteIfIsNotNull("\"'"employeeId\"'" : "\"", @EID, "\", " ,"\"'"employeeId\"'" :null, "), ^ExecuteIfIsNotNul...

Answers: 1

post Json JSON Data Source