Latest Activity


total no. of Column capacity in denodo views

what is the total no. of Column capacity in denodo views

Derived views


Identify all derived views using a specific function

We have a scenario where we are running into an IDMC bug that is loading all null values (for string columns) as blanks and 0 (for numeric columns). and wants to identify all derived views using functions handling nulls. Is there a way we can identify ...

Denodo 8.0 search denodo search Derived views


Add new columns in derived views

Hi, My data source is a mongoDB, As first step I create a collection with a sample of documents. When I add a new document with a new field, I can use "Refresh source" in the base view to have the new field appeared in Denodo, but that's not the case ...

denodo8 new columns views Source refresh Derived views


Dendo Design Studio's problem with Neo4J

Hello Team, I'm using Denodo 8 via Web Design Studio. I created the Neo4j datasource via HTTP configuration with post method, also making use of a Json file. I inserted the fields via the following source query: {"statements": [ \{ "statement": "MATCH ...

flatten Array Neo4j JSON FLATTEN Derived views JSON Datasource WEB design Studio


Using VQL to DROP or DELETE a derived view

Is there a way to DELETE or DROP a derived view using VQL? I would like to programatically do this in python but there doesn't seem to be a VQL command (that I can find) that would allow me to have a list of views to run through and delete. Thanks!

Delete VQL Derived views


dynamically create derived views based on list of multiple base views

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

VQL Dynamic Derived views Loops


About Access to view vql of derived views

Some one of my team wants to exexcute one derived views that I created, and he also wants to have the read access of that derived views's vql. I grant "metedata", "execute" access of this derived view to him, I think it is the read access we mentione...

access to view vql derived views


Compounding a derived view

Hello, I am working on duplicating the behavior of an API, it works pretty good, all the fields are mapped etc. However, the in-place API expose the data after structuring it : { "cat1": { "a":"toto", "b":"titi" }, "cat2" :{ "c":"tata" } } while the d...

VQL REST Webservice Derived views


Joining Census data with Azure dataverse data

Hi All, This is probably mainly to get pointed in the right direction. Here's the problem. I would like to be able to geocode addresses as they appear in the Address table. My idea is 1) Create a base view for the REST API from the census. The censu...

Base view Azure census geocode Derived views


Merge search parameters for derived view to other 3 underlying views

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Denodo 7.0 VQL search methods join Derived views