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.

Query Timeout Setting
answered 12-06-2017 07:50:42 -0400

Hi, How do I know what the (estimated) correct value is for Query Timeout. Administration > Server Configuration > Stored Procedures > Query Timeout I am trying to run the Statistics for the Derived Views. The default out-of-the-box setttin...

Answers: 1

QueryTimeout

Throwing exception com.denodo.util.exceptions.InternalErrorException: Error executing query
answered 09-06-2017 07:11:10 -0400

Hello, I am trying to run VDPCache jobs in the Scheduler. For a particular table, I gave the parameters for year column 2001, 2002, 2003......2017 so it can cache one year after the other in a sequence. But, I am seeing an error while the scheduler is...

Answers: 1

Denodo Scheduler 6.0 SQL Server

Date difference in hour
answered 09-06-2017 05:45:29 -0400

hi, I was wondering how to get hours difference between 2 dates in denodo? It seems like we just have 'getdaysbetween' function. Say, I have a start date of 6/8/2017 8:00:00 and end date of 6/8/2017 9:00:00. Now, I want to get 1 hour that elapsed betwe...

Answers: 1

DENODO

Creating a field in derived view using something like partition by.
answered 08-06-2017 09:02:58 -0400

I was wondering if I could get some help in terms of calculating a difference between the date of various statuses. I have a view with column named "id", "create_dt" and "status". I would have various statuses like submit, approve, deliver etc. Now, I ...

Answers: 2

DENODO

PSQL ODBC for Connecting Denodo 5.5 with Tableau 10.3
answered 08-06-2017 04:51:30 -0400

Hi Team, I need to connect Denodo 5.5 with Tableau 10.3(64bit) using ODBC DSN(64 bit). As mentioned in Denodo KB we are using Postgre SQL ODBC Driver for creating the DSN but we are facing issue while searching Schema and Denodo VDP views in Tableau. T...

Answers: 1

ODBC Tableau

Select from DB2 instance tables error.
answered 06-06-2017 09:00:52 -0400

Hello, I'm able to connect and import tables and views from DB2 but when I'm trying to select something from imported DB2 tables - I faced with an issue like: TESTTABLE [BASE] [ERROR] TESTTABLE [JDBC WRAPPER] [ERROR] TESTTABLE#0 [JDBC ROUTE] [CONNEC...

Answers: 1

DB2 10 JDBC

Denodo monitoring & Diagnostic tool not showing anything for New Diagnostic
answered 06-06-2017 06:57:52 -0400

Hi, I am trying to create a new diagnostic for a time frame, the directory 'New Diagnostic' is pointing to has both Denodo monitor log and VDP logs(VDP log directory) diagnostic is created successfully but it's not showing anything-blank for all TABS....

Answers: 1

denodo monitoring and diagnostic tool

Cached data getting deleted as soon as it is done caching in SQL database
answered 06-06-2017 06:41:25 -0400

Hello, I am trying to cache the data using scheduler. There are around 30 views to be cached. 23 of them are having less data (around 10000 all together) and 7 of them are having heavy data (around 80000000 rows all together). So I created two VDPCach...

Answers: 1

Scheduler DENODO denodo scheduler SQL Server

Stored Procedure- SP
answered 06-06-2017 05:54:10 -0400

I assume to do procedural programming in denodo we need to use Java. Is there any option to use Ansi SQL / PLSQL kind of Procedural langauage in denodo ?

Answers: 1

Stored Procedures

Scheduler : Mail configuration
answered 06-06-2017 05:49:01 -0400

We have downloaded the custom email plugin to show the file content in email body [PlugInName: denodo-emailexportedfiles-customhandler-6.0]. Imported the JAR/PlugIn using "PlugIns" option under "configuration" in Scheduler Administration Tool. Used, ...

Answers: 1

Mail/Port Scheduler Mail Configuration