Latest Activity

code

Generating TEST/Non-Prod data

Is there a way to generate a randomized dataset from a data source? i.e., I would like to create a view that presents real data from the source to be used in a test or non-production scenario but not encrypted or redacted. For example, I may want have ...

code

Denodo 7 License Renewal

Hi What are the steps for renewing denodo license. Does new license scenario has to be created?

code

Array Contains with Databricks driver.

Hi, i've been working with Denodo and Databricks (Using a JDBC connection) and i've encountered an issue with the databricks driver. It seems like when i perform a query like this: Select teammembers from some_table where (teammembers).item = 'some_v...

code

Push down Analytical Functions to Google BigQuery

HI Denodo Team. I'm working with a Bigquery connection and I get an error when I define a derived view in "Virtual DataPort", when the query contains an analytic function, such as: ROW_NUMBER() OVER (PARTITION BY ...). Is it possible to push down Ana...

code

With Clause/statement

Hi There, Can denodo send WIth Clause Query as it is to Oracle Data source? Why denodo try to optimize With Clause into SubSQL Query? Can we pass direct With Clause to any data source via denodo ? thanks,

code

Authentication through Headers

Hi, Denodo Team, We want to delegate the authentication of users to an identity provider using SAML. We know that this is possible in Denodo, but in our case, our applications are redirected to apache machines. The apache machines are in charge of mak...

code

Administer Denodo in a headless environment

Good day - I'm experimenting with Denodo Express on a headless Ubuntu server. Is there any way to administer the server? The article below talks about running ./vdpadmin.sh, but that doesn't do anything in a headless environment. I've tried looking for...

code

Problem with trunc

Haloo,, I have a data table named PlanDate, and the format of the data is timestamptz, i want to make the PlanDate is adaptive to always in the 1st day of the previous month, i created VQL statement like this : PlanDate >= trunc(addmonth(current_d...

code

Catalogue search

In v8 where can I find a guild to how the catalogue search works?

code

Materialized Tables vs Temporary Tables

Is there a way to limit users so they can be able to create Temporary tables and NOT be able to create Materialized tables in Denodo? I could only find this in the Temporary table documentation: Privileges Required The user creating the temporary t...