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 to call batch file in VQL
answered 15-02-2017 08:50:53 -0500

Hi Team , I have created batch script to pick latest file from my folder & FTP a file in cloud server .Can anyone please help me in calling that .bat file in VQL statement Thanks in advance

Answers: 1

Initial Login and password?
answered 15-02-2017 06:32:46 -0500

When first going to the Virtual DataPort Admin tool, what's the initial Login/password?

Answers: 1

Scheduler question
answered 14-02-2017 23:20:15 -0500

I want to get the output of SQL query in scheduler and return the output and email it to the group. appreciate any suggestions!?

Answers: 1

#Scheduler

Base views - Importing tables with same names
answered 14-02-2017 23:16:38 -0500

We have the following structure Databases : Year2014, Year2015, Year2016.... Tables in each YearDDDD database : abc, mno, xyz... We are able to create base views with the first YearDDDD database that we try. However we are not able to import subseque...

Answers: 2

base view

How to encrypt data with SSL between VDP and Java Client
answered 14-02-2017 22:08:49 -0500

How do you force encryption from the VDP to Java Client so data doesn't come over the network in plain text?

Answers: 1
Related to: SSL Self-Signed Cert Installation

VDP JDBC

ITPilot - Process flow does not return results
answered 14-02-2017 11:33:17 -0500

We have a simple process flow with a start, sequence,extractor and end. The sequence works ok and navigates to the required page, The extractor was configured correctly and returned the correct results when the "Specification test" was run. However w...

Answers: 1

Access PDF, Excel files with VDP installed in Linux
answered 14-02-2017 07:46:44 -0500

Hi: If VDP is installed in a Linux platform, can we still utilize the Aracne and ITPilot modules to access Excel, PDF, and unstructured data? The installation talks about ITpilot and Aracne need for Windows, but please help us understand if there is w...

Answers: 1

Linux Aracne ITPILOT

SELECT DISTINCT Doesn't work in subquery
answered 14-02-2017 06:51:00 -0500

Hello, Whenever I try running a subquery with SELECT DISTINCT I get the following error message: Query Execution failed Reason: SQL ERROR -50006 [HY000]: Error executing view: Functions min, rank are not executable I'm not sure why this is hap...

Answers: 1

subquery Distinct

Memory consumption
answered 14-02-2017 04:24:35 -0500

Team, We have installed Dendodo 6.0 in (Red Hat Enterprise Linux Server) OS with 8 GB memory and 2 CPU on virtual machine (only denodo is installed in this VM) I have only five to seven base view created on this VM and noticed 90% memory are consumed...

Answers: 1

java DENODO JVM settings In-Memory Grid

Custom Auto-increment column
answered 13-02-2017 17:36:06 -0500

Hi guys I am trying to figure out how to add custom auto-increment column into the source view. I am using view from MS SQL Server, where it is hard to setup the Primary key. I know I can setup the ROW_NUMBER() function in the source SQL, but I wonder...

Answers: 2