Q&A

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 #kerberos #Authentication

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

Assign restrictions without execute rights
answered 09-03-2021 06:42:37 -0500

Hello, I have multiple interface views in my report layer with customer sales and sales figures. I used the 'Assign Restrictions' function in a shared base view, so for example German users could only see sales data from Germany. Which also worked very...

Answers: 5

Role and User Management

ER Tool integration
answered 09-03-2021 02:44:22 -0500

We use SAP Power Designer for our logical data modelling. It is possible to populate the VDP definitions from external metadata e.g. definitions of data sources, joing views etc?

Answers: 3

logical models

Unable to download DENODO EXPRESS 8.0
answered 08-03-2021 07:34:13 -0500

Hi, I am trying to download DENODO EXPRESS 8 64-bit for Windows and somehow download is breaking in between though there is no fluctuate in my internet connectivity. Another problem is that a download won't resume in download manager. I think when co...

Answers: 1

Denodo Express 8