Latest Activity

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

code

Index Propagation in Join Views

Hello, I have a base view (bv) that records events by timestamp, and I'm trying to implement indexing to optimize a join view (jv) that uses bv along with a couple of other views. Basically, jv groups events by getyear(timestamp), so I created an ind...

code

Postgres ODBC driver version for accessing Denodo 7.0

Is client access to Denodo 7.0 supported using Postgres ODBC driver versions later than 09.05? (We know that using the Denodo supplied ODBC driver is best, but some of our client apps use the Postgres driver)