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

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.

Query existing roles
answered 17-07-2018 18:38:59 -0400

We are on Denodo 6 and would like to query existing roles to dump into a spreadsheet. I have reviewed the existing functions such as 'CATALOGPERMISSIONS', but we are simply only looking for all roles setup in Denodo.

Answers: 1

query roles

Denodo Base view times out in 15 minutes
answered 17-07-2018 16:52:34 -0400

Denodo Server still times out when I try to access the base view that takes more than 15 minutes to execute. I have already changed Admin Tool Preference -> Connection -> Query timeout(milliseconds) to ZERO. Admin -> Server Configuration -&g...

Answers: 1

Connection Time out QUERY_TIMEOUT

Denodo Performance Issues
answered 17-07-2018 16:44:47 -0400

HI Team, need your help here on performace. I have a view in DB, Viewname is "employee" when I write a query in DB for one specifi parameter like select from emp where empid=100; in DB its talking 1 sec to bring the 100 records. I imported same view i...

Answers: 1

Can I virtualize shape file (*.*shp) in Denodo?
answered 17-07-2018 10:29:08 -0400

Can I virtualize shape file (.shp) in Denodo? If yes, then how?

Answers: 1

shape

Denodo Solution Manager
answered 16-07-2018 18:08:24 -0400

Hi Team While Installing Denodo 7.0 on Linux , I have not installed Denodo Solution Manager . Is it necessaary to install denodo Solution manager on Linux ? Why ? Same case if we isntalled Denodo 7.0 on Windows Machine then is it imporatnt to insta...

Answers: 1

Instllation

Error while copying response file into destination folder
answered 16-07-2018 06:50:39 -0400

Hi Team, While installing denodo client we are getting ErrorMessage=Error while copying response file into destination folder. we are trying to install in C:\DENODO. can any help on this issue.

Answers: 1

Changes made at scheduler level
answered 13-07-2018 14:11:37 -0400

Hi Team, Schedule of one of our prod job got chagned and we are trying to find out who / what / when and how ? Can you guide us how to trace above information or which log to scan for ? Thanks

Answers: 1

DBeaver, SQLserver. java.sql.SQLException: Invalid mapping to BYTE
answered 13-07-2018 11:22:35 -0400

I'm trying to access data from SQLserver via Denodo (I think version 6), using latest Dbeaver (on Win7). I'm not an adminstrator so have no visibility of Denodo setup etc. nor the database itself. I'm getting warnings when viewing data from views of ...

Answers: 2

BYTE DBeaver SQLserver.

Delegate operation minus to the source
answered 13-07-2018 09:59:35 -0400

Hello I have two views derived from the same source, I do a minus operation between them and the operation is not delegated to the source. Can this operation be delegated to the source? I'm using denode 7.0

Answers: 1

Truncate and Drop Data Movement tables from Cache database
answered 13-07-2018 04:37:13 -0400

Hello, How do I remove (Truncate then Drop) the Data Movement tables that have been created in the Cache database? These tables were created - in my example, MySQL - when I had clicked on the Data Movenment option in the Derived View Execution Plan. I...

Answers: 1

data movement tables Cache