Latest Activity

code

Denodo VDP cache

Hi, I am trying to create a VDP cache Job that invalidates and loads data every 30 min. It was throwing the below error when I checked "Load / Invalidate data in a single transaction" box on our demo environment but it is not happening when we do it ...

code

SPLIT and FLATTEN in the same query statement

Hi, regarding to the FLATTEN documentation you have to create a view containing a split first, before you can use FLATTEN. https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/from_clause/flatten_view_flattening_data_stru...

code

Invoke Snowflake procedure

Unable to invoke snowflake procedure(mentioned below) from Denodo. Getting error as CALL not supported CALL uspLoadBatchKey('2022-06-06',8,'N','N','10','MonthlySta') Note: Not able to see this procedure from Denodo during base view creation. Could ...

code

Kerberos vs third party identity provider

The documentation is rather vague on the scope of the different SSO authentication methods There is basically SSO using either Kerberos or a third party integrator using SAML/Oauth etc. Thats clear. Whats not clear however is what parts of the Denodo s...

code

Pull Passwords and Logins From Excel File

How do I pull logins and passwords from an Excel file? So, my processes can automatically login to the needed cites using the login info from our excel spreadsheet. We already have our Excel file deployed as a data source in the Web Automation Schedule...

code

Aggregate data via restful web service

I've seen this question asked a couple of times but last answered in 2017. Is there now a way to aggregate (e.g. sum) data via the restful web service? E.g. '...$groupby=category&$select=category,sumValue&$format=json'

code

Can denodo Support to recursive queries ?

Hi Experts, We have below requiremnet : Transaction records are available in multiple source systems and recursive query is needed to create unified transaction record. Hence There are multiple scenarios besides this where recursive feature is needed...

code

Setting up links, the link does not work without ?auth=login#/

Hello. In Denodo, it is possible to access each component directly through the vdp server, bypassing the solution manager. I use links where at the end is ?auth=login#/ eg :9090/denodo-design-studio/?auth=login#/ Is it possible to configure login witho...

code

JDBC source refresh

Is there any way to do JDBC SOURCE refresh in base views for updating the database name and connection details. We are using Azure SQL database.

code

refreshing remote tables

I have tried refreshing the remote table using scheduler>job>vdp In parameterized query, I used REFRESH <remote table base view> command. But it was not working.It is showing as complete but no rows were refreshed. Also, not able to save t...