Q&A

Can i create dataType of table?
answered 24-08-2020 10:23:47 -0400

I can see denodo provides following dataTypes blob | boolean | date | decimal | double | float | int | long | text | xml ,, I have a stored procedure, but I am unable to create base view of that, I am getting error "unsupported type sampleData for dat...

Answers: 9

Multiple Value Search issue in denodo
answered 21-08-2020 18:06:37 -0400

we are facing one challnge with the denodo Web service. we have a requirement to pass multiple comma seperated values and get the response back. but when we give' is contained' , it bring in other values which are reduntant for us lets say if i pass 92...

Answers: 1

Generic Denodo Workflow
answered 21-08-2020 08:52:01 -0400

Hi All - Just a generic question what normal approach you guys will use to pull the Data into Denodo instance. I have requirment to to read data from Oracle DB from Denodo instance. Lets say 4 tables and we only need to take 50 % of attributes into...

Answers: 2

Installing the CORONAVIRUS DATA PORTAL (VDP Administration Tool)
answered 21-08-2020 06:56:03 -0400

I have setup a Cloud-hosted sandbox for the CORONAVIRUS DATA PORTAL.. However when attempting to Download the VDP Administration Tool, I get the following msg. This XML file does not appear to have any style information associated with it. The documen...

Answers: 2

Covid-19

Power BI Direct Query Sample
answered 21-08-2020 03:03:02 -0400

Looking for a Power Bi Direct Query SQL example to enter into the advanced options SQL Statement. More info: Denodo is linked to a view on MSSQL Aveva Historian Runtime.Events table. https://www.aveva.com/en/products/historian/ The MS SQL is the the f...

Answers: 1

Power BI Historian

What does error message "Memory usage restrictions prevent the execution of the query" mean?
answered 20-08-2020 17:18:05 -0400

We get the following error message when attempting to run a certain query (both from the VDP admin tool and an external client): Finished with error: Error executing view: Memory usage restrictions prevent the execution of the query There is no exec...

Answers: 1

How to set Dynamic value in Json Request Header for OAuth 2.0 Client Credential Value
answered 20-08-2020 08:21:05 -0400

Hi Team, I am trying to do JSON PoC with OAuth Authentication for below scanarios. 1) Request to Get Access Token using OAuth2.0 client credential Authentication 2) Pass this acces token dynamically to client application as a bearer token to get sess...

Answers: 1

JSON Data Source

How to concatenate column values in VQL?
answered 20-08-2020 07:35:33 -0400

Hi, I have this in Oracle. select 'A' || ', ' || 'B' || ', ' || 'C' from dual How do you do this in VQL? Thanks.

Answers: 5

Cache for XML
answered 20-08-2020 05:31:14 -0400

DenodoVDP7.0version

Answers: 1

if yes then how can we do it? Can we use incremental cache for XML data source

Incremental cache for XML datasource
answered 20-08-2020 05:25:16 -0400

For Denodo VDP 7.0 version , Can we use incremental cache option with the xml datasource ?If yes , then how can we do it ?

Answers: 1