Q&A

Denodo write back in SQL Server table
answered 07-09-2020 04:08:54 -0400

Hi, When i try to insert rows in sqlserver table with vqlshell in a table with field (NOT NULL) :TIMESTAMP i receive a 'Error executing view. Received exception with message 'Cannot insert an explicit value into a timestamp column. Use INSERT with a c...

Answers: 1

Row_Number() against Derived view
answered 04-09-2020 19:55:24 -0400

I have a final view which has been derived from two different data sources MySQL and Postgres. I have cached the derived view. and underlying cache DB is postgres. it supports the row_number function When I execute the 'row_number()' function in the ...

Answers: 1

anaytical_function row_number

Enable 2FA for Denodo
answered 04-09-2020 18:09:03 -0400

Can we enable 2 factor authentication for login to Denodo Data Catalog and VDP Admin tool ? If not both then either of them ?

Answers: 1

#2FA

json_object_agg
answered 04-09-2020 08:21:05 -0400

What is the equivalent for postgres function json_object_agg(name, value) function in Denodo ?

Answers: 1

json_object_agg JSON

Get the host name in VQL
answered 04-09-2020 08:10:06 -0400

Hi, I have a load balanced infrastructure, and would like to get the name of the node which is answering to my query. Something like select hostname() from dual Is it possible directly in VQL?

Answers: 1

Email notification on scheduled job failure
answered 04-09-2020 06:14:19 -0400

How to setup notification for any job failure scheduled via Denodo Scheduler ?

Answers: 1

#Scheduler #Email #Notification

Denodo testing tool, compare views with different names
answered 03-09-2020 08:56:29 -0400

Hi, With Denodo Testing Tool, I would like to compare number of lines of my source tables in db2 vs views in Denodo, problem is that names are differents. %CONTEXT tablenames[] = a, b, c interfacenames[] = aa, bb, cc schemavdp = eicorea schemadb2 = a ...

Answers: 1

SharePoint Connectivity
answered 03-09-2020 07:12:37 -0400

I am sorry if this has been asked before. Is it possible to retrive data from Denodo and show it in SharePoint on prem and online? I can see that data goes the other way. Thank you in advance for any insight.

Answers: 1

SharePoint

Month integer to Month name
answered 03-09-2020 04:59:32 -0400

I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this

Answers: 2

date formatdate monthinteger monthtext

Can denodo close all VDP and webservice threads immediately upon completion?
answered 03-09-2020 00:26:34 -0400

Since our last release, we are seeing spikes where we can see upwards of 1200 threads in the VDP service per box. In the lower environments this can take down environments, so I wanted to see if there was a way to configure the threads pool to automati...

Answers: 1