Latest Activity

Denodo 8 Admin tool update issue

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

salesforce-denodo

how to connect to Denodo from SalesForce

No delegation cause: "The function 'case' cannot be delegated to this database"

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

Performance Issues with many Columns, MongoDB source

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

Power BI connector for Denodo

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

Regular expression

Version 8.0 How to use not regexp_like in a where condition

Finished with error: Error executing data movement from view V1 to source S1 Exception of plan ULV1: com.denodo.vdb.util.tablemanagement.TableManagerException: String or binary data would be truncated.

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

function 'leftpad' cannot be delegated to this database

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

How to Load Denodo 7 Scheduler Jobs into Denodo 8

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 current user id in Denodo that is logged in?

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