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

Classifier, trained on Twitter data
answered 06-06-2017 05:44:28 -0400

I am not able to get the classifier(link-http://processingdeveloper.altervista.org/classifier.txt) which is used in https://community.denodo.com/kb/view/document/Twitter,%20sentiment%20analysis%20and%20Denodo?category=Custom+Elements as a pretrained cl...

Answers: 1

twitter java

"Some views not found in selected data source" when trying to create a VDPCache job
answered 05-06-2017 07:36:49 -0400

In Denodo 6.0, I'm trying to create a VDPCache job. The virtual dataport source is correctly configured as I can see its different views in the list when selecting a view (in the 'extraction section'). The cache db is also correctly configured because ...

Answers: 4