Latest Activity

code

Convert dictionary key value pair to new columns

We have a column having value like [{'a':'b','k':'e'},{'a':'h','k':'r','y':'q'}]. Can you please suggest how we can create new columns based on key in denodo?

code

Denodo data base not found in Power BI

Doing the lab DEN80EDU16BDS03LAB01 Launch Power BI Desktop and click on Get data > Database > Denodo i got " your search does not match any data source

code

npgsql driver

for the DEN80EDU16BDS03VID02 the " Using the ADO.NET Data Provider " from where and how to download the npgsql driver ? i could not do all the steps something is missing even after downloading https://github.com/npgsql/npgsql/releases/tag/v2.2.7 and in...

code

Execution plan says completed but query still running

Hello Denodo Gurus, I am hoping someone can shed some light on the below scenario: In the VDP shell, am running a simple select query from a base view, and clicked on retrive all rows. 2.The query keeps on running for a long time. 3.Upon checking ...

code

Error when changing the local repositories home path for GIT integration

We would like to make the repositories home dir shared across the vdp servers to make the VDP cluster highly available. When we change the Local repositories home path any path other than default we are getting below error when trying to refresh enviro...

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...