Latest Activity

code

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

code

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

code

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

code

Regular expression

Version 8.0 How to use not regexp_like in a where condition

code

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

code

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

code

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?

code

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

code

Denodo Software

Hi Community, I would like to know where should I download DENODO VDP tool for self training, can you please the link for the same. Thank you in advance. Regards, Sreedher

code

Passing Parent Job Id to Child Jobs

How can I achieve the below scenario. I would like to create a Job which should Generate parent job id and insert values on JDBC destination Need to pick up the newly generated job id and pass it to other child jobs