Latest Activity

code

Solution manager account

Do we have to use admin account to login to solution manager,? is there a role or something similar to grant to indivisual id, so indivisual can login with his credentials. we dont want to use admin account to login to solution manager

code

Row_Number command

Hi. I am getting a SQL Error [1100]: Syntax error: Exception parsing query near '*'. Can someone show me how to properly code the below. I am trying to aggregate this to one record per key. With V5035_C12_POL_CT as (SELECT ROUTINE2.AGENT ,ROUTINE2.POL...

code

Complex filtering on blocks with labels

Hello, I am creating an app where teachers can search for resources. Each resource is tagged with topics which are used to flter results. I have a complex use case and am looking for some advice For example: Resource 1 is tagged with topic "Math...

code

What is a Scheduler Job misfire?

The only documentation I can find regarding the word misfire is located in the Denodo job Handler section. https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/handler_section Can ...

code

Denodo in Automated Release cycle

We are evaluating Denodo for one of our prestigous client. There are few queries which we have, if you can let me know the response. Wrt Testing, we want to compare Denodo Testing Tool vs SoapUI / Postman. Can you let us know the pros and cons of ...

code

Build and release process for denodo / CICD process for denodo

we are doing POC on cicd/pipeline process for denodo(.vql extensions). someone please help with build and release and stages involved.

code

Query timeout while loading the cache

Hi Team, When caching the data set we are getting query time out. And it is timing out around 30min or so. Query timeout under Tools--> Connections--?set as 33.33 min (2000000 millisec). We are not sure if this setting is affecting the caching? An...

code

Can Case be used with Join conditions.

I am using a code where after using the left outer join i need to add case statement, but I am gettig error while using it. For example:- SELECT * FROM sys.indexes i JOIN sys.partitions p ON i.index_id = p.index_id JOIN sys.allocation_units a ON CASE W...

code

Connect to embedded Denodo database (Apache Derby) using REST API (required metadata view_custom_property.json, localviews.json).

Hello all, I would like to connect to the "live data" of the files view_custom_property.json and localviews.json. And afterwards I would like to create these as a base view. Unfortunately I can't find the right schema to access it via REST API: ...

code

How to connect ADLSv2 container with Denodo docker container running on a Azure VM.

How to connect ADLSv2 container with Denodo docker container running on a Azure VM.