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.

Potential Typo?
answered 24-05-2019 19:14:26 -0400

Source: https://community.denodo.com/docs/html/browse/6.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_cache/configuring_the_cache The “Maintenance Period” should be greater than the “Time to Live” because removing...

Answers: 1

Typo

Comparing SqlServer and denodo view using testing tool.
answered 24-05-2019 08:12:02 -0400

hello, how do I connect sql server using integratedservices; and compare with vql using Denodo Testing Tool. Please help!!

Answers: 1

Sql Vs vql using denodo testing tool
answered 24-05-2019 08:01:29 -0400

hello, how do I connect sql server using integratedservices; and compare with vql using Denodo Testing Tool. Please help!! Please provide link if there is documentation. When I tried I keep getting java configuration 'encoding' error. I am able to tes...

Answers: 1

Denodo TEsting Tool SQL Server

How to pull all the Non-LDAP users (Service Accounts) list using VQL?
asked 23-05-2019 18:50:27 -0400

How to pull all the Non-LDAP users (Service Accounts) list using VQL? How to pull all the LDAP users list using VQL? Can you some one give the VQL queries how to pull the above users list. I need to pull the LDAP and Non-LDAP users saparatly.

Answers: 0

Denodo 6 error: "Selection queries cannot be delegated to this database"
answered 23-05-2019 10:54:47 -0400

Hello, sometimes I get this error with a SQL Server JDBC connection, which prevents a query from being pushed own further. How can I fix this issue?

Answers: 1

Restful Webservice - page not found
answered 23-05-2019 08:15:02 -0400

Hi When I browse to the default restful webservice ( http://[server]:9090/denodo-restfulws/[database]/views/[viewname] I get a page error: The page you requested was not found. The page may no longer exist, or you may have typed the URL incorrectly. ...

Answers: 4

Run a query in a JOB to create a table
answered 22-05-2019 20:54:44 -0400

I read data from different datasources (EXCEL), and I do a complex process to get a final result. In the middle of this process I created a materialized table, to improve the performance of the process. I have a job in the scheduler, that get data fro...

Answers: 1

Job scheduler materialized table

Get rows with a minimum value from a column
answered 22-05-2019 20:54:11 -0400

I have a view, and for example, the output is: ID Name City Priority 1 John London 2 2 John Paris 1 3 Jane London 4 4 Jane Berlin...

Answers: 2

MIN function

While connecting thru JDBC to Oracle 12c Could not initialize class oracle.jdbc.driver.DMSFactory
answered 22-05-2019 20:53:51 -0400

Hello Experts, While I try connecting to Orcale 12c, I am getting the error "Could not initialize class oracle.jdbc.driver.DMSFactory". Error details below, please note this is first time installed Denodo and trying connect to Oracle db. Details belo...

Answers: 1

Oracle 12c Oracle DB connection Issue

Downloading custom wrapper
answered 22-05-2019 12:44:12 -0400

Hi, I have installed denodo free trail and wanted to connect to s3. It lloks like I need to download custom wrapper from support.conodo.com. But I get the error message as I don't have the licence to perform this task.

Answers: 1

aws free-trial