Q&A

i lost my ip address
answered 20-07-2020 05:35:31 -0400

where do i find the ip when i lost it?

Answers: 1

free-trial azure

formatting date to ddMMMyyyy which is equivalent to date9
answered 20-07-2020 00:47:02 -0400

Good day I have a datetime format represented as 07DEC2005:00:00:00.000000 please note this is a date not character. I now want to convert to 'ddMMMyyyy' but still to be in a date format not as text or character. i have tried this sql code formatdate...

Answers: 1

JSON Data Source Array Issue
answered 17-07-2020 11:25:32 -0400

Hi, I am trying to create a Base View for a JSON based Data Source : [{"a":1, "b":2, "c":3}, {"a":11, "b":22, "c":33}, {"a":111, "b":222, "c":333}, {"a":1111, "b":2222, "c":3333}, {"a":11111, "b":22222, "c":33333}] If I create the view using the defau...

Answers: 2

data array JSON

Data Type Conversion in Delimited File Data Source
answered 17-07-2020 10:36:11 -0400

Hi, I am trying to create a Selection View in order to convert text value columns in a delimited file based data source to other data types, based on : https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base...

Answers: 1

Type Conversion Delimited File text field

formatting date to ddMMMyyyy which is equivalent to date9
answered 17-07-2020 07:56:14 -0400

Good day I have a datetime format represented as 07DEC2005:00:00:00.000000 please note this is a date not character. I now want to convert to 'ddMMMyyyy' but still to be in a date format not as text or character. i have tried this sql code formatdate...

Answers: 1

SAS DENODO Dates

How to check if the secondary license manager is working properly
answered 17-07-2020 05:31:17 -0400

I have set-up a secondary license manager, in active/passive, according to the documentation. Everything looks good, I can use the pingLicenseManager page to check that it is available. But I am really wondering how I can check if LM will serve the li...

Answers: 3

Expression written on a column of a flatten view
answered 16-07-2020 10:57:46 -0400

Unable to get the expreession written on column of a flatten view from element_metadata table. I get the output for the column - "expression" as --> Flattened Field: "EX_LIST_array" Note: Base view has an array data set. We flatten the base view i...

Answers: 1

Denodo 7.0 Metadata views

JDBC Java 7 download
answered 16-07-2020 08:33:24 -0400

good morning, we need to use java version 7 of the Denodo jdbc. Where can we download it from? Thank you

Answers: 3

Denodo 6.0 JDBC

Connecting a CSV data source
answered 15-07-2020 15:15:18 -0400

There is a folder/directory named as ParentDirectory and under this directory there are many subdirectories containing csv files.So I want these subdirectories to be created as separte schema and the files present under these directories as views. Is t...

Answers: 1

Restrict access to Denodo derived view by role management
answered 15-07-2020 04:43:59 -0400

I have been trying to put row restriction to a derived view using role management restriction but it is not working. It seems I need to apply same condition for each individual user tagged to that role Can I please confirm if we can put row and colum...

Answers: 1

#derived #Roles