Latest Activity

code

Unable to use row_number() function when JSON as Data source

Hi,I am using JSON as data source. I would like to use row_number() function in my view. Getting data source from API in JSON format. Base view is created from the root JSON array. I have used flattern view to remove the top JSON array. From the fla...

code

Linux startup scripts for License Manager is failing

Hi Team , We are in the process of configuring different services of the Denodo Solution manager to be started automatically as part of the startup process of an operating system. Followed the steps in https://community.denodo.com/kb/en/view/document...

code

TRUNC of a localdate does not seem to return a localdate

Denodo 8.0 documentation states that TRUNC of a localdate returns a localdate: https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions#trunc TRUNC( <value:localdate> [, <pattern:text> ] )...

code

Adding or Editing Items in a Sharepoint list via a Denodo view/query

Please advise if there is anyway to Edit or Add Items on a Sharepoint List via an existing OData connection view. is this possible or are you only able to "read" a SharePoint list via Denodo?

code

Excel at Sharepoint online as a data source - error "Unable to establish connection: Stream closed"

I am trying to set up a new data source for my Denodo: xlsx file that is located in our Sharepoint Onilne. I followed this instruction: https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Denodo%20with%20SharePoint%20Online "Conn...

code

Delete community account

Hi, How can I delete mij account on the Denodo community? Regards, Gert

code

Split a column into different rows where value for the column is a list of strings.

There is a view a with one column value as ['avc','ghy']. How do I split these value in different rows? Output should be like avc ghy

code

Denodo LMS Down

Is Denodo's LMS (https://denodolearning.litmos.com/home/dashboard) down? I'm getting the error message below when accessing it: This page isn’t working denodolearning.litmos.com didn’t send any data. ERR_EMPTY_RESPONSE Reload

lms
code

changing values and formats after saving denodo results to excel

Hi , I m trying to save the results from denodo to a csv or excel file . The problem is after saving the results to excel the format of certain values is changing . Like for example date in denodo results is of the format yyyy-mm-dd but when we save th...

code

How to get token with server configuration Oauth2 introspection

With server configuration Oauth2 introspection, I tried to setup a REST service with Oauth2, but it doesn't work. Can someone help me to setup a REST service using Server introspection From the documentation I read => At runtime, the Denodo serve...