Q&A

About cache
answered 14-06-2022 10:25:33 -0400

I have a question about caching. I couldn't understand it by looking at the document, so could you please tell me a little more concisely and clearly? 1) What is Partial mode? 2) When "Explicit loads" is turned on and off 3) When "Match exact querie...

Answers: 1

Partial cache Cache

On base views created from query with parameters-how can we pass the parameters from a subquery in where statement
answered 14-06-2022 05:57:06 -0400

I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...

Answers: 3

Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery

How to create a Data Source for accessing web app output via RESTful API?
answered 13-06-2022 19:21:03 -0400

Is there a way to create a Data Source for accessing the output (JSON format) of a web application via application provided RESTful API (e.g.

Answers: 1

Data Source JSON Data Source

Importing Metadata from VQL
answered 13-06-2022 17:34:33 -0400

I have the DDL script which I have in my destop in .vql extension how could I execute the same with actually copy pasting it into VQL window.

Answers: 1

Import

How to create a derived view with OFFSET, FETCH, LIMIT
answered 13-06-2022 17:08:52 -0400

I want to use the Admin tool and use the "OFFSET, FETCH, LIMIT" below to create a derived view. However, I wonder if it is possible to create a derived view by following the procedure using VQL Shell. How do I create a derived view? https://community....

Answers: 3

Denodo Parameter Error - without search methods
answered 13-06-2022 07:45:22 -0400

I created a view with a parameter. If there is specific value typed into that parameter the view processes just fine.However, I need the parameter field to be blank, so when you open the view the end user has the option to type in the parameter they ar...

Answers: 3

search methods Parameter

Stopping a long running querry
answered 10-06-2022 19:11:46 -0400

Hi Team I am trying to kill a few long running queri's from query monitor by selecting row and click on stop querry button. but it seems it is not having any effect. Am i doing it right way to stop a long running querry ?

Answers: 1

stopping longrunningquerry querrymonitor

GET_JDBC_DATASOURCE_TABLES equivalent to get Stored Procedures
answered 10-06-2022 16:57:56 -0400

We automated our base view creation from a SQL Server using Denodo GET_JDBC_DATASOURCETABLES stored procedure. Unfortunatly, this process ignores the few SQL Server custom stored procedures that we would also like to import in Denodo. Is there a way ar...

Answers: 1

Stored Procedures DataSource

Derby DB meta data
answered 10-06-2022 08:39:47 -0400

We are currently working on upgrading performance validation and upgrading to DENODO 8. While working on noticed Meta data configurations are set to default ehich is initial 4 and max 100.Lookking for way to update these to higher number to support our...

Answers: 1

Derby dB

how can i view excel data using denodo
answered 09-06-2022 11:42:09 -0400

i have added excel as source virtual data port . i want to see the data in denodo for excel . how can i see it .

Answers: 1

Denodo Excel Add-In