Q&A

I downloaded denodo-v80-update- 20220126 from below link. https://support.denodo.com/resources/update/details/3086 . Followed below steps Launch the Denodo Platform Control Center by running the command <DENODO HOME>bin\denodo_platform.bat Choose...

how to connect to Denodo from SalesForce

Dear Denodo team, i created a view using a single table from a datasource (no joins). It is basically aggregating, filtering by a where condition, as well as doing some minor transformations and functions (cast, to timestamp, trim, case, now). The fil...

Hello dear Denodo team, I have a question regarding the performance of a view based on a MongoDB data source. The base view in question has about 2.7 million records and 256 columns. Running the query SELECT max(date) FROM ; I tried several things...

I'm curious if anyone has had any luck running the Denodo connector with the Power BI gateway using a DSNless connection? We have the April 2022 release of the gateway and are trying to use the connector that comes pre-installed with the gateway for th...

Version 8.0 How to use not regexp_like in a where condition

Getting this error when caching a derived view V1 which using a SQL source S1 and unler lying view ULV1 is the base view from S1. This underlying view executes successfully wihout any issue when ran manually without any truncation error. Not sure what ...

I have created a selection view in denodo where i have applied some transformations and while executing got the error stating function 'leftpad' cannot be delegated to this database. Redshift is the data source. lpad works in reshift but doesn't work ...

My company is moving from Denodo 7 to Denodo 8 and I need to know if it is possible to export the Scheduler Jobs from Denodo 7 and import them into Denodo 8? If so, how is it done?

How to get the username from the current session in Denodo? This username is Denodo user and NOT any of the underlying data sources' login. The close query I found is running the below: select * from get_sessions() which gives all the sessions that ...