Latest Activity


Using VDB identifier with a map works in VQL shell but errors when creating a view with same code.

We've had a use case when querying a view from another VDB connection, that a map doesn't seem to carry over. We ended up with NULLs rather than the expected data. A sensible solution is to add the VDB to the map, "<vdb>.<map_name>" This w...


Admin Tool won't launch

On my windows 11 box running Denodo 8.0, I start the Virtual Dataport Server. I then try to launch the Admin Tool. On Friday it worked find. Today it won't start.In the vdp-admin.log each time I try to start the admin tool I get a log entry like: 3332 ...


active queries

Hi Team, Is there a way within Denodo or by interfacing Denodo with any external applications (like Nagios, CatchPoint, NewRelic or JMX agents) to get email alerts in case number of queries running in Denodo exceeds a 'threshold' value as configured b...


Extracting text from a field using delimiter

Hi I have a field which contains text. Id like to extract a certain part of that text field which being "Model: 123 Customer ABC" I would like to extract only the "123" part of this field Any help would appreciated Thanks D


Admin Tools

Which update in Denodo platform has resolved admin tool latency issue?


"Allow literal as parameter" setting and datatype mismatches

We are using a connection to HANA and running into the following error when aggregating some decimal data type fields using the coalesce function: select year_quarter, item_name, sum(quantity) quantity, sum(amount) amount from ( SELECT year_quarter, i...


unable to connect to jdbc driver

I'm unable to connect to Jdbc driver its showing error as shown below: "The JDBC driver was not found. The Denodo Platform does not include the JDBC driver for this adapter. Upload the jar files of this driver. To do this, open the wizard "File" > "...


Publish Failure with Denodo_jdbc connector

Hi Team, I am using tableau desktop/server 2022.1.6. I want to use the denodo_jdbc connector and i have configured the JDBC 8 drivers for denodo at server as well as at desktop. I am able to connect the data source with denodo JDBC driver but when i t...

Related to: How to connect to Denodo from Tableau Desktop


Denodo query

Hi All, I want to a query which return the salary of emp for lastmonthof day from the given below query. Ex: Select * from emp where p_emp_id=1 and p_doj='3/10/2023. Here p_doj is a parameter and emp is a derived view. I need data like this sal for ...


Systemd startup scripts for VDP services

Good job on the scripts!I have a suggestion and correction. Insted of su - , put a User in the unit file for the service so that dndadmin could run the same command in ExecStart without issues, as is, only root could: [Service] User=dndadmin Type=forki...

Related to: Linux startup scripts for Virtual DataPort, Scheduler and Web Tools