Latest Activity

code

dEVELOPER

How to create a data source in denodo

code

Workay connection in Denodo

Hello team, Can we create a workday/concur data source connection in Denodo using Rest API. Thanks

code

Denodo slower performance querying SQL Server databases using Windows AD Authentication compared to SQL Authentication

Hi, We have Denodo cloud setup off prem however we have noticed that when it is trying to query our on prem MS SQL 2016 server authenticating with a Windows AD account the connection when querying the databases is extremely slow (taking minutes). We no...

code

Denodo virtual database audit trail

Hi, Is there a way to find out when a virtual database was first created in Denodo? Does the output of call get_elements('dbname', ) sorted by created_date indicate the first date when the database was created or does the created_date only apply to th...

code

Cu

Can joins be dynamically added to a live query through a custom policy using the condition parameter ? Or are the contents of the condition parameter always added to the end of the currently executing query's WHERE clause? Can somone change the topic ...

code

Unable to execute custom function imported from oracle source

I have imported a custom function created on one of the sources. I have the following questions. After importing, I see it as a stored procedure in denodo. Is this a default behaviour? Why are functions identified as stored procedures in denodo? ...

code

Re-joining same table

Update i found the error in my code. i had the rnGroups next to the wrong parentacies. it is working now In the VQL i was writing, i used a specific where filters on a nested select statement. I then did a row count statement on the first stateme...

code

Long running query timing out even with querytime=0 in context

Denodo 8, update 20230914, sql server db. The following query is finishing with error: select * from metrics_dashboards.dv_monitor_datasources CONTEXT('cache_preload'='true', 'cache_wait_for_load'='true', 'cache_return_query_results'='false', 'cache_in...

vdp
code

DBA

Hi, where can I find the End of Support Date for Denodo8? Thanks!

code

Error saving stored procedure: Syntax error: Exception parsing query near '''

Hi Denodo Team, I have created a VQL Stored Procedure which runs SQL statement based on the user input ui (hard-coded here for testing.) (paramName IN VARCHAR) AS ( // Declare Variables ui VARCHAR; ) BEGIN ui := 1; # CASE Statem...