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 updated version of the Denodo Express 6.0 with new features and issues fixed starting in September 2016.

If you want to try it or if you want to update your current Denodo Express version you can download the brand new Denodo Express 6.0 at the Express home page in the Denodo Community

Denodo performance when Cache Mode is Partial
asked 21-01-2017 09:13:41 -0600

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

Answers: 0

performance

Unable to connect to VDP
answered 20-01-2017 06:42:51 -0600

I recently installed Denodo Express and when I tried to connect as per the instructions, I see error : "connection error: Connection refused: connect" when I enter the username and password. any help? Thank you

Answers: 1

Connecting from Cognos 10.2.2 to Denodo VDP 5.5
asked 20-01-2017 06:40:18 -0600

Context: I have a Cognos report that connectis to VDP Oracle datasource (using connection pooling) which in turn execute queries against views that are underpinned by Oracle database procedures that then populate Oracle session tables. The Sessiosn ta...

Answers: 0

Using NOLOCK hint in VQL Select statement
answered 20-01-2017 04:51:47 -0600

Is it possible to use NOLOCK hint in select statement on SQL Source

Answers: 1

VQL Sql performance SQL Server

VQL Querying Folder/Database/Table information through JDBC
asked 19-01-2017 15:46:34 -0600

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

Answers: 0

VQL JDBC

Derive container Folder of a data sources or a base view using vql
answered 19-01-2017 15:38:32 -0600

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

Answers: 2

VQL

How to import a flat file from Linux server to VDP which is installed on Windows
asked 19-01-2017 03:35:21 -0600

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

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

Source Control

Drop virtual Database
answered 18-01-2017 06:41:09 -0600

Team, We have Denodo 6.0 installed in UNIX environment and we are trying to drop one virtualdatabase 'ABC' with all views and all dependecies We log in from Admin database and try to drop 'ABC' databse using database managment from administation drop d...

Answers: 1

denodo 6.0

Denodo 6 : Unable to fetch records from Hive
answered 18-01-2017 04:18:57 -0600

I picked up all the relevant Hadoop & Hive JAR files for making connection with Denodo 6 and was successfully able to connect. Did created the views from existing hive tables, but when I try to VQL simple query to fetch records, it throw error. Below i...

Answers: 1
Related to: Denodo and Hadoop

Hive Issue

Denodo and Workday's API
answered 17-01-2017 12:13:46 -0600

Has anyone had success integrating workday? Does it require me to write my own service layer?

Answers: 1

Workday