Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

date and time issue
answered 17-01-2019 06:53:57 -0500

Hi i am appliyng current_date() and now() functions on Column_A but those are not working to get current_date , Any guess what could be the issue ?

Answers: 1

usage of Denodo Express
answered 17-01-2019 06:24:57 -0500

Is it ok to install Denodo Express on different servers for testing purposes, or does it need to be uninstalled from one before installing on the other? Thanks, john

Answers: 1

issue with single formula
answered 16-01-2019 10:34:03 -0500

How to use two different functions or formulas in a single column i want to use CASE and COALESCE

Answers: 1

FORMULA NOT WORKING
answered 16-01-2019 08:40:36 -0500

I have a COLUMN_A which i want apply bellow formula but it's not working on existing view and getting weird behaviour FORMULA --- case WHEN (COLUMN_A = '' AND COLUMN_A is null) THEN '2000-12-11' ELSE COLUMN_A END After applied above FORMULA i am sti...

Answers: 1

PDF version of User Manuals
answered 16-01-2019 05:39:07 -0500

Hi How to download the PDF version of the user manuals ? I want to read the docs offline when not on connected to internet. Please provide the links. A single PDF will be much appreciated regards Shafi

Answers: 2

documents

Web Panel
answered 16-01-2019 04:05:19 -0500

I have a linux installation and trying to use web panel. It does not let me connect to web panel. is the kerbros neccessary for web panel. ( we dont use kerbrose).

Answers: 1

non-ANSI data types
answered 14-01-2019 11:00:08 -0500

Hallo Denodo Team, Some Databases (Teradata for one) add non-ANSI extensions to the set of available data types. Is there a way to predict with certainty how such types would be translated into Denodo types at “base view creation time”? Thank you in...

Answers: 1

datatypes

Centralized Caching Server
answered 14-01-2019 09:09:55 -0500

Hi Denodo Team, I have to achieve scalability with Denodo instances. If i introduce a load balancer and configure multiple denodo instances behind it. Is there a possibility that all the instances write to a single cache server via JDBC? Can i use a...

Answers: 2

caching

Used By Views, through query
answered 14-01-2019 07:35:31 -0500

Hi Team, Denodo 5.5 Denodo 6 Base Views - BV1, BV2 Derived Views: DV1 = BV1 JOIN BV2 DV2 = BV1 UNION BV2 DV3 = Selection on DV2 So, DV1 is not used further. DV2 is used in DV3. DV3 is not used further. Question: How to get list of views which are ...

Answers: 1

Used by

Different roles within the same Distribution List
answered 14-01-2019 07:29:30 -0500

We have configured an LDAP authentication in our Denodo system. We have different databases created meant for different users but under the same Distribution List(DL). So if i want to assign privilege for a user to a particular database from the DL, wi...

Answers: 1

Access and Role Role and User Management