Latest Activity

code

How to get statics of view (object) execution in a month

How to check a particular view got executed how many times by user in a month?

code

Export Metadata from Data Catalog as a table

Hello, I would like to export the view names, view descriptions, tags and categories from Data Catalog as a table. Is there any way to do it? I exported the data from Data Catalog and everything is in the form of JSON. We have several views in our dat...

code

view parameter - multiple input default values

version - Denodo version 8 enterprise plus I am trying to use "view parameters" in a logic and my requirement is to pass multiple default values (i.e. in clause in SQL). I am able to save the view with configuration on view parameter as cpt: text '''2...

code

Oracle Date to Denodo Translation

Could someone translate this from Oracle to Denodo I am struggling to do this and under a time crunch. So much appreciated. Date_item_field BETWEEN CASE WHEN to_char(sysdate, 'DD') = '01' THEN trunc(trunc(sysdate,'Month')-1, 'Month') WHEN to_char(sysd...

Related to: Oracle SQL to Denodo VQL Quick Reference

code

Same table name in multiple databases

Denodo VDP 6.0 Latest update: 20170220 We have the same table in 2 different databases - Oracle, Hive. The reporting tool that we currently use allows the user to select the database that they want the report to run against. Depending on the option ch...

code

Returning a substring up to the first occurrence of a special character

I have a string value that contains data seperated by the symbol "/" muliple times. I need to return a new field with only the string values up to the first occurrence of "/" without including the symbol. sample_string = abc/defg/hi/jk expected_output...

code

Invalid Object error

I have created Denodo base on SQL stored procedure which is using SQL Global global temporary table (##), i am getting below error, when two users are trying to execute same denodo view Error: Invalid object name '##Org_Data' Do i need to setup some ...

code

Issues with Denodo Solution Manager

Dear Support-Team, We noticed following issue. Wehn logging in, in SolutionManager, it makes a diffrence when logging in within SSO or Username and Password. Denodo is recognizing these to logins as two different users. My question: Is this a norm...

code

How to display table column output in upper case

How to display table column output in upper case??? Should I set it separately when creating or change the virtualization parameter option?

code

Unable to login Denodo Scheduler

Unable to login Denodo Scheduler. From the scheduler log we've found below info. Pls note that we've given correct username & password. For this issue we've recycled the scheduler services which got fixed. 2464348601 [RMI TCP Connection(114491)...