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

Subtracting two timestamps in Denodo
answered 12-09-2016 04:20:06 -0400

Hi Support Is it possible to subtract two timestamps in Denodo to get the Day/Hour/Minute/Second difference between the two fields? I don't see a function for it and was having troubles breaking it out with 'get' commands. Thanks!

Answers: 3

timestamp

Bulk insert into Temporary or Materialized table
answered 09-09-2016 09:46:34 -0400

We are building custom procedure which would based on parameter create temporary or materialized table after applying filter, business logic on few tables. As we are using "environment.executeUpdate()" method to populate temporary\materialized table, i...

Answers: 1

Stored Procedures

Looking for cleaning cache of specific views/folders and not whole database Using Scheduler.
answered 09-09-2016 06:51:38 -0400

CALL CLEAN_CACHE_DATABASE is cleaning whole database cache. is there any way/function to clean cache of specific views/folders and not whole database using Scheduler?

Answers: 2

data cleansing cache

How to clean cache for specific views/folder
answered 09-09-2016 06:02:34 -0400

If I want to clean cache of specific views and not whole database, is it possible? If yes, how? Can I clean cache of all views in specific folder? If yes, how?

Answers: 5

data cleansing cache

VDP administartion login issue
answered 09-09-2016 04:37:39 -0400

i try to login VDP administartion tool. it's throws “Unrecognized SSL message, plaintext connection” error. How do i solve this issue? Could you please suggest.

Answers: 1

Sequence and timing of startup scripts
answered 08-09-2016 10:47:51 -0400

What is the proper/preferred sequence for starting the services? Is the dependency between the services, such that one service will not start until another service's startup has completed?

Answers: 1
Related to: Linux startup scripts for the Denodo Platform

Receiving untrusted domain error
answered 08-09-2016 10:36:49 -0400

Creating a new JDBC data source connection using jTDS. I get the following error message: "Unable to establish connection: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." I used jTDS in another app...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

Cognos Analytics 11.0.3 Supports Denodo
answered 07-09-2016 10:58:23 -0400

How to create a denodo data server connection on lastest cognos 11.0.3 release having SSL enabled?

Answers: 2

Cognos

Date
answered 07-09-2016 10:47:51 -0400

when i load the date field in denodo it shows like 'wed dec 17 00:00:00 IST 1980' but i have given only 'yyyy-MM-dd' in database. How to display date with format 'yyyy-MM-dd' in date datatype only as when i am using formatdate() function it changes the...

Answers: 1

date functions datatypes dateformat

Connecting to VDP from Cognos through JDBC
answered 07-09-2016 10:38:52 -0400

Hi there, Is there a JDBC connector to access VDP from Cognos (Ver 10 or 11) available? If so, where can I download it from?

Answers: 2

Cognos JDBC connection