Latest Activity

code

Upgrade from Denodo driver version 8.0.20220126 to 8.0.20220815

We have been running Denodo version 8.0.20220126 for quite some time. Every day a process is executed that executes a query using the denodo driver. We are using Virtual Dataport Server 8.0.20220815. Denodo Platform 8.0 Denodo Design Studio 8....

code

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

map
code

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

code

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

code

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

code

Admin Tools

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

code

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

code

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

code

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

code

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