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.

UNIX Account
answered 19-07-2018 09:17:42 -0400

Hi Team, Can you please confirm if UNIX account will work to authenticate VDAP Thanks

Answers: 1

how do I log out and then log in to a connection (data source)
answered 18-07-2018 18:29:56 -0400

how do I log out and then log in to a connection (data source). The DBA made some object changes and needs me to log out of the database and login. Can it be done?

Answers: 1

Apache Derby Database - Where does it store the cache
answered 18-07-2018 16:38:49 -0400

I am trying to figure out if the Apache Derby database is storing cache when cache status is on. Is it in memory in the heap, or a files on the drive? Thanks, Jamie.

Answers: 1

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

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