Latest Activity

code

Odbc driver to excel

What is the limit of concurrent connections in odbc driver to excel? i get error "too many client tasks" on connection count range 60-64

code

Help - Error processing the privileges for this query

Hi, I am getting the following error message when I run my query - There was an error processing the privileges for this query. Does anyone know what this means and why it happens? I have access to all underlying views. This is the query structure I h...

code

Access External Tables/views in Synapse Serverless Pools

Hello Team I'm facing issue in accessing views in Synapse Serverless SQL Pools. Can you please let me know if it is possible. I know Denodo can connect to ADLS Gen2 but I'm specifically looking for ways accessing views in Serverless SQL Pools. Please ...

code

VQL Stored procedure calling baseview which is a wrapper to a microsoft sql server stored procedure failing with spurious syntax error: 'Syntax error: Exception parsing query near '00''

Denodo Platform 8.0t, Subscription: Enterprise, Administration Tool 8.0 20230301, VDP Server l 8.0 20230301 Windows 10 Enterprise DATA SOURCE :Microsoft SQL Server 2016 (SP3-GDR) (KB5021129) - 13.0.6430.49 (X64) Jan 22 2023 17:38:22 Copyright (c) Micr...

code

tutorials and use cases

i'am searching online for tutorials and use cases to practice my skills i've finished the tutorials that i found in the community site i want more complexe use cases whith available data

code

role privileges for data movement

I'm trying to use a datasource (JDBC connection to Teradata) that has data movement enabled, currently in a Denodo database where all our datasources are kept (Admin). I have a user that is in a role that has connect/metadata/execute privleges grante...

code

Help - There was an error processing the privileges for this query

Hi, I am getting the following error message when I run my query - There was an error processing the privileges for this query. Does anyone know what this means, why it happens, and how to resolve it?

code

How to find invalid views in denodo 7

Hi Team I have to create a job/ view to find all the invalid views in denodo 7. In denodo 8, get_views() procedure can be used to find invalid views. This procedure doesnt have column view_status in denodo 7. I have refered most of the community pages...

code

Issue using EXECUTE in vql stored procedure

Hi Denodo Team, I'm using the Denodo Design Studio Version 8.0 20230301 and trying to create a VQL Stored procedure using the EXECUTE command as described in the user manual : https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/develop...

code

Denodo Express 8 installation on Windows 11 always give authentication error with default admin account.

Hi Denodo Team, I encountered this authentication issue on Windows 11 with Denode Express 8. While the vpd.log gave nothing but vpd-admin.log showed: Connection error:com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: authentication er...