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 November 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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

VDP Connection error. You can continue working in draft mode
answered 17-07-2017 07:36:21 -0400

Version 6, Last update installed : 20170220 Issue: After logging into Scheduler on local machine, I have added a new server where I actually want to schedule a job for frequent cache load process. After connecting to that server ( using admin credenti...

Answers: 1

VDP administration connection error

View without search methods when applying CAST() or SUM().
answered 17-07-2017 07:07:57 -0400

Hello, there is an error when I'm trying to apply common functions like CAST( text field to date), SUM (decimal fields) and even simple math operations from the base view, which uses XML datasource and contains some obligatory fields. For example, vG...

Answers: 1

Denodo Monitor Service Not Maintaining Running Status
answered 14-07-2017 17:15:59 -0400

Hello, I just finished following this tutorial on two machines. The first machine worked flawlessly and is running well (my local dev machine). However, after performing this on the DEV server (running Windows Server 2012), I am experiencing issues k...

Answers: 2
Related to: Denodo Monitor as a Windows service

Denodo Denodo Monitor Auditing

Using the COALESCE function with Dates
answered 14-07-2017 09:28:34 -0400

Will appreciate if someone can help me with the following using the COALESCE function Query purpose: To return a particular Date value. If no Date value is returned, use January 1 0001 as the default Select coalesce(bv_test.find_my_dt, to_date('MMMM ...

Answers: 1

coalesce

Function is not executable
answered 14-07-2017 05:05:03 -0400

HI, I try to make a simple function it returns me this error "Finished with error: Function righttest is not executable". Below is the java and denodo script. Java: public class righttestVdpFunction { public String execute(String regex) { ...

Answers: 1

Date format used in the fixed WHERE Clause of Derived queries
answered 13-07-2017 09:22:00 -0400

I want to add a WHERE condition to a derived query and the field in the clause is a Date field. What is the formet I need to use in the condition value? In the Derived View > Edit > Where Conditions > add a condition field name = 'InceptionDa...

Answers: 1

dateformat

Support for creating a data source using a session based SOAP backend
answered 13-07-2017 09:20:45 -0400

Hello! I am in process of discovering the capabilities of Denodo and as part of my experiments I want to access a backend application that publishes SOAP services. I have successfully created a simple data source based on that application, I am not...

Answers: 1

Denodo Express SOAP Web Service

Derived view access issue from Alteryx
answered 13-07-2017 09:06:23 -0400

Hi, User wanted to connect to a derived view from Alteryx, So I have provided connect privilege for the respective database and read privilege to the derived view. Now the user is able to access the derived view from SQL editor in Alteryx but not able...

Answers: 1

access ODBC Alteryx derived view

Execution time increased after turning on the Cache
answered 13-07-2017 04:25:58 -0400

I am having around 20 services created whose base views are cached and indexed. The performance(execution time) of all the services was improved when I switched to cache database except one service. This one service execution time is increased to more ...

Answers: 1

performance DENODO Denodo Scheduler 6.0 SQL Server

To implement Custom Functions in Denodo.
answered 12-07-2017 04:24:25 -0400

Purpose: To implement Custom Functions in Denodo. Configuration details: Java version "1.8.0_111" Eclipse 4.5 Denodo4E 1.3.2 Denodo 5.5 What’s done so far: • Installed Eclipse and followed the Denodo Documentation for Configuring Denodo4E on Eclipse...

Answers: 1