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.

Denodo Data Catalog Unable to Query
answered 06-11-2019 04:14:41 -0500

Whenever I try to query a view from the Denodo Data Catalog, it gets stuck saying "loading query tab" which never goes away, keeping the data catalog from being usable. Is there any way to fix this, and how would I go about it? Thanks, and I really hop...

Answers: 1

data catalog

Microsoft Query (Excel) not Compatible to Denodo Query
answered 05-11-2019 12:41:13 -0500

Hi team, I used excel to connect denodo for views data visualization, I follow this link: https://community.denodo.com/tutorials/browse/basics/4connect2odbcclient . And it works. However, when I want to do some advanced query, not only get the detail...

Answers: 3

double quote Excel single quote Microsoft Query

Provide access to SINGLE view to MULTIPLE roles
answered 05-11-2019 08:54:33 -0500

Hello team, As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30). The procedure is to select each role, click on edit in the database and give wh...

Answers: 3

Denodo stored procedure database assign privilages Base View descrptions Stored Procedure Access and Role VQL Role Role and User Management Roles Users

Denodo jdbc jar usage in Python
answered 05-11-2019 06:52:02 -0500

Hello.. I'm attempting to create a JDBC connection using the Denodo JDBC jar in Python. I'm using the Python JayDeBeApi module establish the connection, however on connect I'm receiving a certificate chaining error. java.security.cert.CertPathValidat...

Answers: 3

Denodo 6.0 JDBC

XML file configuration as view
answered 05-11-2019 05:21:16 -0500

We can configure below format of XML as view in denodo <Quote> <XSD_PERSISTID>"PRV123456"</XSD_PERSISTID> <XSD_PERSISNAME>"Srinivas"</XSD_PERSISNAME> <XSD_PERSISADDRESS>""</XSD_PERSISADDRESS> <XSD_POSTCODE&...

Answers: 1

XML

query fails when data source is unavaialable
answered 04-11-2019 23:00:43 -0500

Some queries to Virtual DataPort are failing due to a data source being unavailable. What will be the behavior of Virtual DataPort in this case

Answers: 1

Base View date field is populating incorrect format
answered 04-11-2019 13:50:34 -0500

Hello, We have a base view that is populating a date field incorrectly. The date field should be populated under the format of date time with the time being zeros (example Tue Jul 29 00:00:00 EDT 1947) , however for a number of recrods we are seeing Tu...

Answers: 3

datetime locale date field

Finding Enhancement Details
answered 04-11-2019 04:49:10 -0500

Hi, in the Denodo release notes, all the fixes and enhancements refer to a ID, e.g. #42312 The one line desicripns however can be vague and its not clear how the enhancmeent can be used. Is there a way to find out more deails for the enhancements. ...

Answers: 1

Enhancements

Missing Configuration parameter
answered 01-11-2019 18:56:05 -0400

when i connect to VDP admin. thorwing an error "Missing configuration parameter" it is working properlyu in virtual workplace. coud somone please suggest

Answers: 1

Unable to pass where clause parameters when connecting to VDP using Oracle DB links
answered 01-11-2019 04:59:16 -0400

We are connecting to VDP from Oracle (running on Linux) using DB Links and the parameters in the where clause in Oracle query are not sent to VDP which is causing queries to fail due to missing manadatory input fields. ORA-28500: connection from ORACL...

Answers: 2

Oracle DB links