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.

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

Test Drive never completing provisioning
answered 31-10-2019 23:15:15 -0400

Hi All, I've tried to sign up for the Test Drive evalution. Whilst it starts provisioning and increments up to 75% it never goes past this point (in hours). I recieve the emails for the RDP details prior to provisioning page getting to 50%. I've tried ...

Answers: 2

An Error occurs when I installed Denodo express 7.0 in 64bit win 7 & 10
answered 31-10-2019 09:56:08 -0400

Hello. I tried to install the Denodo express 7.0 in win 10, there is an error occurs in the last steps. Actually, I tried in three machines, inclduding win 7 and win 10, however, the same error occured. Is there are someone meet the same issues?The det...

Answers: 2

Denodo express 7.0