Latest Activity

code

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...

code

VQL Query Shows a Long Time Spent in Data Serialization

Hello! We are using Denodo 7.0.20200310 and SQL Server 2017. We have a simple SELECT statement joining 2 base views that runs slowly in our test environment (52 seconds) and fast in our QA environment (<1 second). In looking at the trace information...

code

How to avoid array data conversion into text format while creating base view?

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...

code

How to sync user queries in denodo data catalog servers?

Hi Team, I have a requiredment to automate the process of export and import user queries between 4 production servers through shell script. Is there any export and import commands available only to export the user queries from one server and to import...

code

how to connect denodo

i have downloaded ova file for denodo training quickstart virtual machine i import ova file vmware workstation and started vm which is succesfully started but now its required ip address so kindly guide me which i have to enter in it. thanks

code

how to monitor denodo by prometheus?

We now uniformly use Prometheus as a monitoring tool. How can denodo's information be connected to Prometheus? Currently only this is still pending, please help as soon as possible, thank you

code

COLUMN_DEPENDENCIES ()

Hi, I'm working on the output from COLUMN_DEPENDENCIES () for a given report view but Im having trouble following the lineage for a given column as we have used column aliases to make the column label more useful to an end user. So for example: column...

code

Getting "com.denodo.vdb.engine.customwrapper.CustomWrapperException" error while executing select query on view created from sharepoint

Hi, We have created a sharepoint connection in design studio. we are able to create view from that connection but when we execute the select query we get "com.denodo.vdb.engine.customwrapper.CustomWrapperException" exception. when we looked at the log...

Related to: How to connect Denodo to Sharepoint Online using OData with OAuth authentication

code

Migrate from Denodo 7.0 to Denodo 8.0 - Servers

Hi community,For an installation of DENODO 7.0 with 1 server for PreProduction and 2 Production servers (all with different IPs, non localhost), in terms of migration to Denodo 8.0, would it be necessary to have different machines to install the new se...

code

Getting the stats in a VDP Server

is there a VQL which i can use to get how many number of databases,folders,views or other like how many Cpu's are there in vdp server?