Latest Activity

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

code

Debug vql stored procedures

Hi, How to debug vql stored procedures with print statements? I need understand what my vql stored procedure execute in same steps. I try some commands (print, display) but it isn't work. Any ideias? Thanks.

code

Time-out issues when joining multiple tables

Hi i have this timeout issue each time i tried to run a query where joining multiple tables required. I only join between 2-3 tables and it already gave me a timeout issue. How do I fix this errror? The entire message is as follows: Finished with err...