Q&A

How to search for a range of dates based on a text value - Interpolation variable
answered 04-10-2021 11:47:56 -0400

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

Answers: 6

Interpolation Variables AWS S3

Write on a external table from denodo
answered 04-10-2021 04:38:30 -0400

Hello Team, Would you please Help on this. i wont to write/update data into an external table which is connected via API. and the data is availbale on a table in denodo. for exapleme: Company (Denodo views) >(write/update)> Company (external ...

Answers: 1

Export API

Pivot rows into columns in an array
answered 01-10-2021 02:09:00 -0400

Hello, what I would like to achieve could be straightforward but I'm very new to Denodo. I have a view like this: model_id equipment 1 Array where the Array is like this: description v...

Answers: 3

Denodo 7.0 ARRAY Pivot

how to create independent categories and tags for each server in denodo data catalog?
answered 01-10-2021 00:34:03 -0400

I have created tags and categories in server configuration A and created some tags and categories in server configuration B and currently when i login in server A or B i am seeing both tag and categories of A and B combined. Is there any ways by which ...

Answers: 1

tag management Data Catalog data catalog categories

license file is a name denodo.lic, where can I download the new license file: denodo.lic ?
answered 30-09-2021 06:05:32 -0400

license file is a name denodo.lic, where can I download the new license file: denodo.lic ?

Answers: 1

DENODO EVALUATION LICENSE

Getting refused connection ,not able to connect to scheduler server.
answered 30-09-2021 05:59:08 -0400

Installed 8.0 express in my local machine. Able to connect to vdp via admin, datacatalog and diagnostic tool. Trying to connect to schedular server via schedular admin. But getting authentication error in the brower and seeing below message in schedula...

Answers: 1

Data Catalog Sync taking longer time after external db setup
answered 30-09-2021 05:38:04 -0400

Hi Team, We recently setup an oracle 12c external db on denodo 7 datacatalog. Post the external db setup, Synchronization with VDP server is taking around an 1 hr to complete the the process. Could you please suggest

Answers: 1

datacatalog

trying to configuring denodo monitoring in my machine
answered 30-09-2021 04:57:32 -0400

Hi Team, I am trying to configuring denodo monitor in my machine by using given link. https://community.denodo.com/docs/html/browse/7.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor While exec...

Answers: 1

Denodo Monitor

File system URI as an interpolation variable for DFSListfile wrapper?
answered 30-09-2021 02:10:13 -0400

Hi Team, I am working on denodo 8.0 I can read the file names from Azure blob storage using com.denodo.connect.dfs.wrapper.DFSListFilesWrapper and specifying File system URI value. I want to make this connection a variable so that i can declare it ou...

Answers: 1

Custom function
answered 30-09-2021 01:21:47 -0400

Hi Team, I would like yo use the function, Leftpad and rightpad. Could you please help to how i can use in VPD. I tried but ended up with the error 'Finished with error: Function 'leftpad' with arity 2 not found'.

Answers: 2