Q&A

Virtual dataport (VDP)
answered 04-03-2021 07:22:25 -0500

Some queries to Virtual DataPort are failing due to a data source being unavailable. What will be the behavior of Virtual DataPort in this case

Answers: 1

The EXECUTE permission was denied
answered 04-03-2021 07:04:05 -0500

Hi Team, I am trying to execute a synapse stored procedure from denodo view. I am getting the below error message while doing the same. com.denodo.util.exceptions.InternalErrorException: The EXECUTE permission was denied on the object 'usp_abc', data...

Answers: 1

Execute permission

Association
answered 04-03-2021 06:28:56 -0500

Who can configure Associations

Answers: 1

Open LDAP
answered 04-03-2021 05:06:39 -0500

Hi Team, How to configure open LDAP in denodo? Can you please share some useful denodo documentation links which details the procedure to enable it? Thanks, Manju

Answers: 1

#LDAP #open_ldap

How to select distinct elements of an array column in a view
answered 04-03-2021 04:55:15 -0500

I need to select distinct values from few array columns in a view. My view consists few Array columns and I cannot group by them. SELECT * from {view} where {parameter} = '03645' Parameter Column 2 Column 3 Column 4 ...

Answers: 3

ARRAY Distinct #array #customfunction

Resource Manager
answered 04-03-2021 04:34:58 -0500

The Resource Manager allows a user to .......

Answers: 1

Arrays
answered 04-03-2021 04:33:06 -0500

how arrays are handled within Virtual Dataport (VDP) Views.

Answers: 1

Derived views
answered 04-03-2021 04:24:55 -0500

what happens If we create a derived view that includes an aggregation operation

Answers: 1

Associations
answered 04-03-2021 03:44:37 -0500

Why is it important to correctly define Associations between virtual views?

Answers: 1

Cache index causes deadlock during load. Can it be dropped or disabled during the load?
answered 03-03-2021 23:56:44 -0500

Platform Denodo 8.0 on Linux Cache database: MS SQL Server 2017 My denodo view has full cache and an index on the cache, If I try to run a denodo query while the cache is being loaded, and that query filters on the indexed column, the query will fail ...

Answers: 1

"full cache" index lock