Latest Activity

code

When running as admin, receiving "Error storing wrapper: Error accessing the metadata" when attempting to create base view

Hi, I'm currently attempting to create base views in VDP Administration Tool and receiving the following error message: Unable to create base view: error creating 'json' wrapper: Error storing wrapper 'WRAPPER': Error accessing the metadata while lo...

Base view VDP Administration Tool

code

Java Heap space error while running query

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Base view java Select Query 'Java heap space'

code

List all Derived views using a specific Base view

Hi, In Denodo , how can we list out all Derived views which are using a specific Base view ? In Denodo VDP admin tool, it is easy to find using option "Used by" .We are looking for the same option using some Denodo stored proc/command.

base view

code

Denodo Views

Hi Denodo community, I have the following: Data Source: JSON * Name: HTTP CLIENT * Configure: Post * URL: Rest Call The source currently has nested elements, some fields either appear as a register or arrays. I do not want to...

post Json Base view JSON

code

Refreshing a service

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Base view SOAP Interface

code

info about view settings in metadata

Hi, I found this: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures to get information about a lot of metadata. As denodo has a lot of parameters and settings for eac...

metadata Base view Views

code

Using CTE WITH clause for creating base view from query

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Base view quer cte MSSQL

code

How to populate a column in the base view which is not present in the Datasource?

I am trying to populate a column in the base view with same value. For example I have manually added "Year" column in the base view which is not present in the Datasource. I would like to populate the Year column with 2018 for all records. How can I do...

Base view DataSource

code

How to add by default values in the base view?

I have added 2 extra columns in the base view in addition to the datasource. I would like to populate these columns with the same default value. For. e.g. Let's say there are 1000 records in the datasource. I have added "Year" column and I would like t...

Base view

code

Edit query when creating a BASE VIEW

Hi Community: I'm new using the tool and when creating a base view I used he option create from query. I'm trying to edit the query used for a base view created is this possible? If yes please let me know which are the steps Thanks for your help

Base view