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

Create a field in a View that contains a Sequence Number
answered 18-07-2018 15:50:09 -0400

In a (Derived) View, can I create a field that contains a Sequence Number (such as the Row number in the View).

Answers: 1

row number sequence number

component views
answered 18-07-2018 15:49:29 -0400

Hi Team, I have suppose 10 views (base + derived) which builds up to an interface view. Is there any stored procedure/ vql way to identify those 10 views which builds up to this interface view. I do not want to use Tree View option. Thanks.

Answers: 1

tree view

unable to start information-self-service-tool
answered 18-07-2018 06:19:03 -0400

Hi Team I got an error while trying to start 'information-self-service-tool' from console. Below is the error: "java.sql.SQLException: Failed to start database 'D:\Denodo Platform\resources\apache-tomcat/../../metadata/self-service-database' with cla...

Answers: 1

Denodo server starting trouble. Virtual DataPort

Error on generated SQL query
answered 18-07-2018 04:26:14 -0400

Hello, I'm using Denodo Express against a MariaDB database. When I execute the view, the have a syntax error because the SQL statement is not well generated. Expected SQL : SELECT id, Order_Id, Client_Id, Product_Id, Date, Qty, amount FROM test.orders...

Answers: 1
Related to: Getting the SQL query delegated by a derived view

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