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

How to use oracle functions such as sysdate, to_date, to_char etc in VQL
answered 15-11-2016 14:13:04 -0500

Version 5.5 installed on a windows server (2008). For example (getting all babys born since yesterday: SELECT name, birthday FROM persons WHERE birthday > SYSDATE - 1 This gives the error: Error in select view conditions: Field not found 'sysdate'...

Answers: 1

Multiple policies on Web Services based on Users
answered 15-11-2016 07:08:56 -0500

We are trying to see if we can have a web service that is authenticated by LDAP, that will have multiple accepted users. Do we have capabilities in Denodo to have different policies setup for each user? Policies can be like maximum number of rows or an...

Answers: 1

custom policy Web Service

Slowest views in denodo
answered 15-11-2016 03:54:40 -0500

Hi, Is there any way to find out the the bad performing views or top slowest views ??

Answers: 1

denodo 6.0 base view

Denodo Scheduler services
answered 15-11-2016 03:08:51 -0500

Hi, I am unable to start scheduler services from services.msc, but in control center scheduler server seem to be running. When i checked scheduler log i saw "Scheduler Server: server could not be started: Another instance of Derby may have already boot...

Answers: 1

denodo 6.0 scheduler scheduler log

Error executing query.
answered 14-11-2016 06:47:26 -0500

Hi All, I'm Getting an error while executing a query in VQL please provide a solution for below error Error executing query. Total time 0.646 seconds. QUERY [CACHE] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception wi...

Answers: 1

Server.xml
answered 11-11-2016 20:44:31 -0500

Can you please elaborate your answer to previous question. I have denodo 6, trying to make the modification in server.xml file but don't see the following entries clientAuth="true" sslProtocol="TLS" keystoreFile="$KEYSTORE_TOMCAT" keystorePass="$KEYST...

Answers: 1
Related to: SSL Self-Signed Cert Installation

SSL

Scheduler extract
answered 11-11-2016 12:02:49 -0500

how should i extract the select statement executed in Scheduler.e..g extractor section has a Select, how should i extract a text value, manupulat eit with some function and execute it. is filter sequence helpful for this?

Answers: 1

#scheduler

specifying custom i18n on scheduler extractor for csv
answered 11-11-2016 08:16:02 -0500

I have specified a custom i18n and am trying to apply this to an extractor btu so far have been unsuccessful. I have tried the following. Setting the i18n on the base view Setting the i18n on the final view Specifying the i18n during the query in the...

Answers: 1

scheduler date csv export i18n

Multiple input parameters in REST service
answered 10-11-2016 13:14:49 -0500

HI Please let me know how to pass or query multiple inputs for a REST service. Eg. If my REST service has a view with 'Rollnum' in where condition then how shall i fetch the records for the roll numbers "1,,3,6,7" in one go ? Thanks

Answers: 2

input REST parameter multiple Parameters

how to configure mail configure in scheduler
answered 10-11-2016 07:11:56 -0500

what are the steps to use scheduler configuration for mail. I have smtp server name and port , but looks like scheduler is not able to recognize it and errors out while trying to send email.

Answers: 1

#scheduler