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.

Localization for web application
answered 01-06-2017 07:23:26 -0400

Hello, guys. Is it possible to enable the "Internationalize query results" option not only for VDP, but for web application which queries the denodo (there are timestamp fields in the database)? The main purpose is to use server locale where database...

Answers: 1
Related to: Internationalization configuration and dates

i18n

OBIEE report QueryTimeout
answered 31-05-2017 15:44:50 -0400

as per this doc, configured OBIEE to connect with Denodo. but couple of my reports are failing with time out error. I verified my ODBC.ini file it has QueryTimeout=0 which means no time limit. but still it is failing, can you pls advice on this issue ?

Answers: 1
Related to: How to access to VDP from OBIEE via ODBC in Linux

QueryTimeout

datediff year
answered 31-05-2017 08:46:39 -0400

What is the translation of datediff(Year,date1,date2)?

Answers: 1
Related to: Microsoft SQL Server SQL to Denodo VQL Quick Reference

Creating a Denodo derived view with correlated subquery
answered 31-05-2017 07:34:02 -0400

We are using Denodo 6.0 and trying to create a Denodo derived view which has a corrleated subquery. SELECT T1.TRNS_ID, T2.BLD_TS FROM bv_CMSN_TRNS T1 INNER JOIN bv_CMSN_STAT T2 ON T1.EDI_TRNS_ID = T2.EDI_TRNS_ID WHERE T2.BLD_TS = (SELECT MAX(BLD_TS) F...

Answers: 1

trace-on to debug
answered 29-05-2017 08:47:57 -0400

We rarely face below issue and Its kind of Internal Server Error. ‘Error retrieving data from ‘Path’. HTTP error code: 500.’ I want to debug this issue and find the cause of this . Why request-response does not work sometimes. Please help me to resol...

Answers: 1

Debug

Use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server)
answered 29-05-2017 08:27:24 -0400

How do I use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server). Is the option set on the data source or the base view of the data source? And how is it done?

Answers: 1

update JDBC Data-Source

Express password help or reset
answered 29-05-2017 07:37:46 -0400

Just intalled and trying to use Express, but it doesn't like my portal login. And there isn't a "forgot password" link. Any ideas on how to get it reset? Thanks, Bob

Answers: 1

Denodo Java 8 JDBC-ODBC bridge road map
answered 29-05-2017 03:48:20 -0400

We are attempting to upgrade our Denodo to the latest version (v60 update 20170515). This version supports Java 8 which helps us with some new data source connectors, however due to the jdbc-odbc bridge not supported in Java 8, we will be unable to use...

Answers: 3

ODBC JDBC DataSource jdbc java8

How to specify json structure when we publish a flat view as rest web service
answered 25-05-2017 15:06:02 -0400

I have flattern structure like below in one of the views: Person Table ID| Name We want to publish this as a restbased webservice with json output and out put should be like below: {"Persons":[{" ID":"1","name":"abc1"},{"ID":"2","name":"abc2"}]} Note:...

Answers: 6

Connectivity to S3 with data in parquet format
answered 25-05-2017 13:21:37 -0400

Hi, Would like to know if Denodo can connect to the S3 object store and retrieve content stored in the parquet format via a regular SQL query. Thanks. John

Answers: 1

S3