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

How do you subtract two dates to get the duration in days
answered 26-06-2018 13:31:37 -0400

in Oracle we would use select (end_date - start_date) from dual Update - it looks like the getdaysbetween(date1, date2) function may work for me

Answers: 2

Date

Installation
answered 26-06-2018 12:06:48 -0400

I have installed 6.0, 64 bit for windows. I am at the screen where I have to select the packs I want to install. No matter what I select, I get a prompt that says 'Please seclect at least one product to install"

Answers: 1

Does Denodo support Cassandra 3.x?
answered 26-06-2018 08:54:55 -0400

Hi, We are evaluating a few data virtualization solutions and has a strong use case for supporting Cassandra. Does Denodo support Cassandra 3.x? The problem is since Databricks does not support JDBC for Cassandra anymore, is there any other way of ge...

Answers: 1

Cassandra

track failed query
answered 25-06-2018 17:31:49 -0400

A user is hitting Denodo from tableau, He is facing issue with some tableau dashboards. While working with him we found that we can see 'active session with the query hitting from tableau to denodo', but we are unable to track failed query which was hi...

Answers: 3

query

Denodo & SQL Question - Temporary Tables & Updates
answered 25-06-2018 11:58:33 -0400

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reas...

Answers: 1

Query Temp Tables SQL

Cache query having parameters ROWSTATUS ; EXPIRATIONDATE
answered 25-06-2018 11:20:07 -0400

Hi Team, When I am running the query on denodo view with one parameter which is cached I am seeing the query is created as below, SELECT t0.EMP_NUM, t0.EMPID, t0.OFFICE_NUM, FROM C_NON_EMP4415830103126 t0 WHERE t0.OFFICE_NUM = ? AND t0.ROWSTATUS = ? A...

Answers: 1

Connecting to Hyperion Essbase
answered 25-06-2018 10:25:15 -0400

Getting the follwoing error while connecting to essbase Error accessing Essbase server: Cannot connect to Provider Server.javax.net.ssl.SSLException: Received fatal alert: close_notify

Answers: 1

Expose Data Catalog to external Web Applications
answered 25-06-2018 07:47:29 -0400

I wanted to know if it is feasible to connect to data catalog from custom web applications using web services/APIs to perform catalog and content search and show results on the the custom web application? Any reference to tutorial will be helpful.

Answers: 1

Prompted for password for the Denopd service username
asked 24-06-2018 23:47:46 -0400

Our cloud team have just created a Denodo Azure 6.0 instance (purchased from the Azure Marketplace) and presented it to our team for configuration. We can connect via SSH to the new VM with the credentials created at the time of purchase. When we att...

Answers: 0

azure new installation

Refreshing a service
answered 22-06-2018 12:41:02 -0400

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Answers: 1

Base view SOAP Interface