Q&A

Typically the ideal scenario is to have one installation of the Solution Manager to access different environments such as SIT, UAT and PROD. This will allow to promote the changes from one environment to another using single instance of Solution Manage...

We recently started using a Postgres connection in Denodo. We've noticed that on larger datasets (particularly in joins) that performance is impacted when using the ADDMONTH function. ADDMONTH can't be delegated to the data source since it's not a Post...

Hi, I stored my delta tables on Azure Blob Storage. Now I want to access these tables from Denodo. Alternatively, I tried Simba connector to connect Azure DataBricks tables, and that works fine. But that does not show the Blob Store Tables. Ideally Sim...

Is it possible for the user to view the metadata for all the base views across all databases/schemas but limited to query only the data they are entitled to those base views?

I will load Denodo 8 Express on a Windows machine but I don't see required resources anywhere: RAM, CPU? Obviously more is better, but just to try it with minimal data, what do I need? Thanks Judith Judith Ullman Business Intelligence Team Lead The N...

Hi, I created one datasource and on top of it there is a baseview. Suppose the source is unavailable now and base view is throwing error and its not retrieving the data. Now whenever baseview throws error due to any reason. It should trigger an mail ...

Hi, Denodo 8.0 supports listagg function, but can distinct clause can be used inside the listagg?

Hello, I need to connect to a REST API whit a POST requests which returns a json file. In this Post request, I need to put in the body, that must be an application/x-www-form-urlencoded content-type, two parameters. So I created a Json data source c...

Hi team, I am trying to connect Denodo 7.0 to connect with Azure Data Lake through Custom wrapper. I am trying to connect using shared key authentication method. So I have saved the key in core-site.xml file. the format is like Shared Key: using the s...

Related to: How to connect to Azure Data Lake Storage from Denodo Platform

As denodo does not have collate functionality, i have written a custom function that delegates collate to snowflake server and I am trying to use like operator in denodo vdp client with collate as shown below, SELECT * FROM <myview> where colla...