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.

Best Practices for initial set up/organization of the Server Explorer folders
answered 20-07-2018 20:02:05 -0400

Hello, my colleague and I are relatively new to Denodo and currently we are putting together a set of best practices and trying to determine the best way to organize folders in Server Explorer. I am reaching out to see if Denodo has any best practices/...

Answers: 1

folders datasource best practices server explorer

Update statistics automatically via scheduler job
answered 20-07-2018 15:53:15 -0400

Hi, I followed the steps given here https://community.denodo.com/kb/view/document/How%20to%20update%20the%20statistics%20of%20a%20view%20automatically?category=Scheduler to create a scheduler job with CALL GENERATE_STATS procedure. I am getting authent...

Answers: 1

Gathering statistics at VDP level
answered 20-07-2018 09:43:49 -0400

Hi , Is there any possibility that statistics can be gathered at VDP level instead of single views. Is there any stored procedure for the same that can be used? Also can statistics be gathered for interface views? Thanks!

Answers: 3

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