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

Can not change ADMIN password in Express
answered 30-06-2017 09:01:12 -0400

Am I be able to change ADMIN password with express denodo? When I run "create or replace user admin 'mypasswd' SHA512" I got "error creating user: The user does not have enough privileges or does not have ADMIN privileges " Where did I do wrong? Eggo

Answers: 1

VDP and large (2Gb) XML file
answered 30-06-2017 08:48:16 -0400

Hi, Could you offer some guidance on using VDP with a large XML (2Gb+) data source? I tried using an XML data source with unzip option and creating a base view, but the base view does not appear to finish processing. Thanks, Rich

Answers: 1

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

performance

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

jmx DENODO

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

Git