Latest Activity

code

Set parameter for Scheduler E-Mail Handler

Dear Denodo Support-Team, is there a possibility to set the E-Mail handler for the scheduler job via parameter ? For example like it works with the subject ? Denodo Scheduler Notification - @{jobResult} [@{projectName} @{jobName}_@{jobID}] at @{...

code

Lastdayofmonth for prior month is Denodo

Im trying ot get last day of the month with : LASTDAYOFMONTH(addmonth(current_date(),-1)). The above query gives result as : 2023-12-31 However when I run the same with few more lines of code: select field_name from "table_name" where "field_name" bet...

code

JDBC connection errors to create data source for a database

I am using Denode Express in Demodo Platform 8.0 in Window 11. When I tried to create a Data Source for a database through JDBC, I got the following errors from Test connection : Unable to establish connection: The JDBC driver was not found. The Deno...

code

Enable compound types isn't providing all the options

When I select the "Enable compund types" box from the Edit Interface screen, I only get the additional option "relation_link". I don't get the array option. This is the first time I've experienced this problem; why wouldn't all the compound types be av...

code

PK and FK during meta data creation

Hi Team, When we create base views from source RDBMS - does Denodo also picks up all the constraints from base source tables ? Like PK and FK ? I see details about primary key in community but what about other constraints ! Regards, Sandeep

code

denodo express usage policy

Hi, I want to use the denodo express. However, I need to check if I can install it on my company's computer. I think it doesn't matter because it's a free version, but is there any documentation that can confirm that there are no problems with the in...

code

Create Base View from query

Hello, When creating a base view from query, I am always successful when creating a base view from query when I do a straight select with condititions. However I noticed when I try to put in a query where I create temp tables it does not work. Is there...

code

Got ORA-12705: Cannot access NLS data files or invalid environment specified when testing connection to Oracle 11g data source

I installed Denodo Training QuickStart Virtual Machine (DQVM) and Denodo Express 8.0 for Windows. And when I try to test connection to data source (jdbc:oracle:thin:@data-server:1521:xe) the "ORA-12705: Cannot access NLS data files or invalid environme...

code

how to rename a derived view column name

ALTER VIEW xyz( ALTER COLUMN abc RENAME column mnn); how can we rename a derived view column name

code

Store procedure does not execute connect statement

I am getting error message while executing connect statement in Store procedure. Is there other syntax or way to connect database within store procedure? Error message: 'Finished with error: Could not execute a connect during a transaction.' I have use...