Q&A

GetSession not working outside of the VDP
answered 11-03-2021 07:55:36 -0500

I had the following script and then various views based off this script working in the VDP but then when I tried to run a dervied view from a tool like DBeaver everything is coming up blank because the GETSESSION function is not returning a value. Is...

Answers: 1

select query vdp getsession dbeaver

Ping Query
answered 11-03-2021 07:42:06 -0500

The Cache database configuration allows us to select the option 'test connections' and to set the 'Ping Query'. What is the purpose of these two parameters?

Answers: 1

importé une bas de données mysql dans denodo8
answered 11-03-2021 01:34:01 -0500

Bonsoir je voudrais savoir comment inséré le chemin du Driver class dans Denodo8. J'ai des difficulté car je teste la connection aprés configuration mais le chemin est introuvable

Answers: 1

5.5

creating a base view off of a working script in VQL Shell
answered 10-03-2021 10:04:35 -0500

I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGH...

Answers: 1

select query Vql shell Create Base View

Error saving base view: null
answered 10-03-2021 08:53:52 -0500

Creating a new base view from a custom data source is always fine. Without changing anything on the data source, after "Edit", "Source Refresh", and then "Validates and Saves the base view", "Error saving base view: null" is raised. What might be wrong?

Answers: 1

Custom Connector

Will Denodo supports multiple authentication method simultaneously at server level?
answered 10-03-2021 07:40:06 -0500

Hi Team, We need to enable Kerberos at the server level. But when we refer the manuals, we got to know that SPN to be set up as an HTTP service. But as per our organization policy it is not allowed to create a functional SPN as an HTTP service. IS the...

Answers: 1

#Oauth #Authentication #kerberos

contains search in view
answered 10-03-2021 07:27:09 -0500

Hi Team, I want to filter the data using contains on particular text column (case insensitive) any method available and also using ODATA also any option available Thanks Satish K

Answers: 1
Related to: Oracle SQL to Denodo VQL Quick Reference

contains

String/Text type length limitation
answered 10-03-2021 07:07:35 -0500

Hi, How are you? When invoking a Denodo Rest API call, if one of the parameters is a string/text data type, what is the maximum length allowed for the value? Thanks Amol

Answers: 1

Have Denodo Monitor run constantly in V8
answered 10-03-2021 06:22:06 -0500

We are testing with Denodo 8 and I am working on enabling the denodo monitor on each of the app servers. In running the shell script, it looks like the shell has to constantly run in V8, unlike V6. I wanted to see if there was a way to have the monitor...

Answers: 1

Struggling with using a field with JSON data and tying it back to the original view using an ID field
answered 10-03-2021 01:32:44 -0500

I have a view that has a field called "primaryqa". it contains data that has answers to questions in JSON format that I want to parse and then joing back to the original view using an field called "id". [{"QuestionID":1,"Answer":"Yes"},{"QuestionID":2...

Answers: 1

Interpolation Variables joining of interpolation variables array