Q&A

QUERY [JDBC ROUTE] [ERROR] Received exception with message [JDBC ERROR] Index : N, size: N
answered 20-07-2020 06:24:02 -0400

have anyone hit this error before ?

Answers: 1

SSO from Tableau Server to Denodo
answered 20-07-2020 05:45:02 -0400

It has been stated before and known that Tableau to Denodo SSO works with Tableau Desktop, via Kerberos, but not with Tableau Server. Unfortunately many of our users access Denodo through tableau server (url) and have to sign in a second time to get to...

Answers: 2

Tableau SSO

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