Q&A

PowerBI Dataset
answered 25-08-2020 07:38:22 -0400

Good Day, The data that I need Denodo to access is a PowerBI Dataset. Can you please assist with the connection settings for this. Regards, Kaashief

Answers: 1

Sign in to Data Catalog
answered 25-08-2020 02:48:57 -0400

Hi, Team, It's my first time to sign on to Data Catalog. Data Catalog is running and I used admin and admin to log in. The "Sign In" button is grey. Does that mean I don't have access for some reason? or I am missing some steps? Thanks Ming

Answers: 3

Data Catalog first time ever

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