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.

Execute test files
answered 27-01-2017 03:48:10 -0500

I have created test through but when i tried to run it with cmd prmpt as mentioned in document. It throws error as "unable to execute 'denodo-test.bat': no java executable founf and/or no JAVA_HOME variable set" But i have verified my Environment varia...

Answers: 1

Denodo Testing Tool

Trying to use generic JDBC, to connect for example crate.io (which is one JDBC product that works vs elastic-search)
answered 27-01-2017 03:41:50 -0500

The connection succeeds, but trying to create any base view yields a weird exception failed to parse ")". I have no idea how to find a more detailed exception. I am also totally aware to the fact that the generic adapter/connector is not tested. Yet, I...

Answers: 3

Generic

Set proxy for OAuth 2.0 Credential Wizard
answered 26-01-2017 23:30:44 -0500

Is there a way where we can set proxy settings for OAuth 2.0 Credential Wizard. I am unable to "Obtain the OAuth2.0 credentials" from Token endpoint URL in Wizard. It says "Connection refused".

Answers: 1

oauth

Derive container Folder of a data sources or a base view using vql
answered 26-01-2017 12:50:44 -0500

Is it possible to derive container Folder of a data sources or a base views using catalog vqls?

Answers: 3

VQL

AFX_ODBC_CALL(::SQLColumns(...)) + Denodo ODBC Driver = Exception
answered 26-01-2017 06:55:10 -0500

We use CRecordset::Open with the parameter CRecordset::snapshot to enumerate the columns in the view/table. This calls the AFX_ODBC_CALL(::SQLColumns(...)). However this throws an exception and -1 is returned as a return code. Is this a bug or is this ...

Answers: 6

timestamp issues
answered 25-01-2017 10:15:08 -0500

Denodo seems to miss some functions to deal with timestamps. Assume I map a data source to base view containing timestamp, and now I need to do joins based on date column from one data source and timestamp column from another. I would also expect that...

Answers: 1

ts

How to import a flat file from Linux server to VDP which is installed on Windows
answered 25-01-2017 05:18:39 -0500

Hi Team, I have Installed Denodo on my Windows Machine and and on Linux Server as well. I could able to connect from VDP to Linux server succefully. I like to know that how to import data sources like ( XML , EXCEL, Postgresql which are on Linux ser...

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

Source Control

VQL Querying Folder/Database/Table information through JDBC
answered 25-01-2017 04:59:43 -0500

is it possible that I VQL query from external application using JDBC to find Folder name which contains a given view/data source name? Also is it possible to VQL query from external application using JDBC to find the database name of a given data sour...

Answers: 1

VQL JDBC

Denodo performance when Cache Mode is Partial
answered 24-01-2017 23:48:50 -0500

Hi Team, I am quite impress with denodo performance when Cache is in Partial mode ( Match exact queries only ) . Bellow is my understanding : 1) On first run it fetch data from Data Sources 2) On next run if same kind of queries are executed and if ...

Answers: 1

performance

Joining to Cache
answered 24-01-2017 23:23:28 -0500

I found when joining to a cached view performance is slow probably due to network latency, I decided to move the cache into my EDW to see if performance would improve. It did marginally but Denodo didn't recognize that the Cache and the data I was join...

Answers: 1

cache