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.

Create user in a database
answered 29-06-2017 08:12:53 -0400

When I try to run VQL create user ADMIN myadmin 'mypwd'; I got Syntax error. Can you tell me the correct syntax? Thank you very much. Eggo

Answers: 1

Denodo slow performance during simple select operation.
answered 29-06-2017 07:05:01 -0400

Hello, there is a performance issue when I select data from table (MS SQL Server 2014) through Denodo. SQL from Denodo execution trace is like: SELECT FROM TESTTABLE WHERE FIELD1 = ? AND FIELD2 = ?; Parameters [VALUE1, VALUE2] SQL that is sent to...

Answers: 2


Issue adding JMX connection in VisualVM
answered 29-06-2017 06:06:36 -0400

I am trying to add a JMX connection with hostname as localhost and port number as 9999, I am receiving an error cannot connect to localhost:9999 using service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi Can someone help me Please let me know if extra...

Answers: 4


Execute Command in VDP
answered 29-06-2017 06:05:35 -0400

Hi, Do we have any Execute command in VDP Admin to execute the sql strings. For eg: ExecuteQuery("Select EmpId, EmpName from Employee where EmpId IN (100,101,102,103)") I think, this is available only in storedprocedure.

Answers: 1

Denodo to JMS Listener
answered 29-06-2017 03:19:54 -0400

I am looking at the following example - https://community.denodo.com/kb/view/document/Getting%20data%20from%20Denodo%20Virtual%20DataPort%20through%20JMS?tag=JMS In the above example, denodo responds to a message sent to JMS. Can we use Denodo to send ...

Answers: 1

JMS Listener

How to transpose non-array output in single line?
answered 28-06-2017 08:09:45 -0400

Hi All, I have question to implement transpose output in our requirement. We have following example output currently coming. SRC_ID CURRENCY_CD AMT REVMART AUD 100.00 BIC AUD 500.00 BPC AUD 200.00 REVPRO AUD 700.00 Above output comes in 4 different...

Answers: 1

Denodo 5.5 and 6.0

Scheduler: Delay till the data gets loaded in actual databases
answered 27-06-2017 12:36:19 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...

Answers: 2

cache DENODO denodo scheduler SQL Server

500 Internal Server Error when trying to save to a new Git Repository
answered 26-06-2017 08:29:45 -0400

I'm having trouble checking code into a Git repository. I'm getting a "500 Internal Server Error" each time I try to commit. My question is why am I getting this error and how do I fix it? Here are the steps I've taken to try to take a database that...

Answers: 1


Scheduler: Truncate cache tables instead of invalidating.
answered 23-06-2017 09:17:54 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...

Answers: 1

DENODO denodo scheduler SQL Server invalidate cache

Max Query Timeout allowed by Denodo
answered 22-06-2017 08:08:39 -0400

I have set the Query Timeout value to Zero (which means no timeout limit). I ran the Gather Statistics for my Base View and the Timeout occurred after 900 seconds (15 minutes). Is the maximum statistics time allowed by Denodo = 15 minutes (900 secon...

Answers: 3