Latest Activity

code

denodo hardcoded column in join view

Hi Team, I want to create a view with below query- select distinct 'H' as home, 'O' as office, a.id, a.address from tableA a left join tableB b on a.id=b.id But when I give this hardcoded values to newly added columns in a join view, at the executio...

code

Denodo Express 8 error in installation

Hi, Our team is trying to install Denodo Express 8.0 on VM, but we are getting below errors. Could someone please provide a solutions or have come across simialar issue? (Note: regardless of these errors during installation, Setup GUI says " installati...

code

Blank value when date is 1900-01-01 00:00

I would like to show a blank when the value in a date field is showing "1900-01-01 00:00". Assistance is greatly appreciated.

code

SELECT SPECIFIC FIELDS versus ASTERIC (*) - why would the asteric query fail?

Executing the exact VQL... -a) Ran a query using * on the SELECT, it FAILS -b) Ran the query using SPECIFIC fields on the SELECT, it is a SUCCESS Why?

code

Azure Service Bus integration with Denodo

Hi, We are exploring to use Azure Service Bus with Denodo 8.0 but Denodo only have listener for JMS and Kafka. Any idea how to connect Azure Service Bus with Denodo ? Thank you

code

Connection to Coupa

Are there API's available for the Coupa solution?

code

Row count of all views

Hi, I want to know if there is an easier way for getting the row counts of all the views inside a folder in denodo? without having to calculate for each view at a time

code

DMR login issue getting error in vdp.log Error loading database 'denodo_monitor'

Hi DMR login issue, getting error in vdp.log Error loading database 'denodo_monitor' First time configuring DMR on this VDP server. Please let me know how can we fix this issue. denodo_monitor data base is not available in vdp. Thanks and regards,

code

UTC date time field conversion - add hour VERSUS convert time zone - yield different result over daylight saving dates.

Hi, Need to understand why the two do not produce the same values when a UTC date/time field crosses over a change of daylight savings on lst March the 12th. Thanks. VQL SELECT "Event Time UTC" AS "A" ,formatdate('HH:mm:ss', convert_timezone('UTC', ...

code

denodo predicate pushdown uses questions

Here are two base view sourced from two Oracle databases: view1: admin.order-> source table:oracle1.order view2:admin.order_extend -> source table:oracle2.order_extend it can normal predicate pushdown if I execute:select v1.oid,v1.wcc_num,v...