Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

different type fields
answered 06-03-2019 07:20:29 -0500

Hi Team Issue with follwoing statement , i am getting error `QUERY [JDBC ROUTE] [ERROR] Received exception with message 'DB2 SQL Error: SQLCODE=-581, SQLSTATE=42804, SQLERRMC=null, DRIVER=4.19.26' case when A.a is not null then A when B is not nu...

Answers: 1

files not available for on-demand course
answered 05-03-2019 08:25:39 -0500

Good morning, We are doing online training for developers ‘DEN70EDUD01 Data Virtualization Developer (Introduction) - On-demand’. Almost all the files that are to be downloaded to run the tutorials tests are not reachable. Is it possible to have all th...

Answers: 1

Import script-How to pass folder names that contain spaces when importing a repository elements.
answered 05-03-2019 07:55:10 -0500

Hi, Using export.sh I exported some of the views from a database into a repository. During the process the export utility has also created a folder named 'folder.base views' and create folder 'views' inside it. so if my view name is v1 which is prese...

Answers: 1

Can we connect Denodo from SAP HANA SDI using JDBC drivers? If so, can you please provide instructions?
answered 05-03-2019 06:49:35 -0500

Please help in these two quesitons. They are most critical to prove Denodo as tool which can connect from SAP HANA SDI also.

Answers: 1

Denodo 6.0 JDBC

Cache Error Modifying View
answered 05-03-2019 06:48:57 -0500

Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...

Answers: 2

Cache

connection with phyton
answered 04-03-2019 11:47:46 -0500

we install the ODBC and it does not mark us any error, nevertheless when executing from the Python (version 3.6) it marks us error for lack of the file denodoodbc.so: import pyodbc pyodbc.dataSources() {} cnxn = pyodbc.connect('DRIVER=Deno...

Answers: 1

connection from phyton to denodo
answered 04-03-2019 11:39:30 -0500

we install the ODBC and it does not mark us any error, nevertheless when executing from the Python (version 3.6) it marks us error for lack of the file denodoodbc.so: import pyodbc pyodbc.dataSources() {} cnxn = pyodbc.connect('DRIVER=Deno...

Answers: 1

Number of Denodo Servers that can run simultaneously
answered 04-03-2019 07:38:00 -0500

Please let me know how many servers can run simultaneously in Denodo? What is the affect of all the servers running? (WRT The licenses only keep a limitation of the number of Denodo servers you can run simultaneously, in addition to certain limitations...

Answers: 1

VDP server

Getting column specific information on the views
answered 04-03-2019 07:19:59 -0500

Hi, is there any dendo predefined procedure that tells the infomation about when a particular column was last modified with either the description info or any other changes. I see the predefined procedure like "get elements" which is giving info at th...

Answers: 1

Join view OR Operator
answered 04-03-2019 05:53:50 -0500

Hi How to use OR operator in join condition my query looks like this bv_1.id = bv_order.id AND (UPPER(bv_code.CODETYPE) = 'ADMINISTRATIVEGENDER' **OR** bv_ce.C_CODE IN('4','5')) ERROR what i am getting currently The join condition is not vali...

Answers: 3