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

Nested Join - Query Plan
answered 10-05-2016 17:24:45 -0400

I have constructed a view that goes against 6 applications to pull data for a list of part numbers - since the applications each have millions of records, but I need a small subset, a nested join is working well for my use case. I have the "OR" nested...

Answers: 2

nested join vdp

Generate Stats SP
answered 10-05-2016 14:48:24 -0400

Hi there, I am using both the "generate_stats" and the "generate_stats_for_fields" within the VQL shell. My datasource is not givng us back the details in the default time alloted to the SP (Which I believe is 80 seconds). I tried adding the context (...

Answers: 1

Generate stats

Denodo Express 6.0 cannot connect to vdp after install on windows 7 (64bit)
answered 10-05-2016 14:33:33 -0400

Hi- I recently installed on windows 7, Denodo 6.0 express 64 bit version. after install when trying to connect to vdp keeps getting connection error: Connection timed out: connect also i notice in vdp.log following WARN. No errors. 3653 [Thread-5]...

Answers: 2

vdp

Scheduler job to automate the metadata testing process
answered 10-05-2016 11:44:17 -0400

Hi, I am trying to create a scheduler job to automate the metadata testing between two views which are in different databases. Now that, I created 4 different scheduler job for 4 different environment(dev,SIT,UAT and PROD). Each job has one parameteriz...

Answers: 1

scheduler data sources

Issue using global search index in Denodo 6
answered 10-05-2016 09:10:16 -0400

I am trying to set up global search for the Information Self Self Service Tool in Denodo 6, following the steps in the Denodo Scheduler Administrator Guide, the Information Self Service Tool Guide, and the tutorial here: https://community.denodo.com/tu...

Answers: 1

Denodo installation issue: javaw.exe unexpected
answered 10-05-2016 05:08:20 -0400

I am seeing the below popup message when i am trying to install Denodo on my machine: "\Java\jdk1.7.0_71\jre\bin\javaw.exe" was unexpected at this time. Any pointers on how to fix the same?

Answers: 3

new installation

Denodo Monitor - Stopping
answered 10-05-2016 04:46:17 -0400

Hi there, Quick question about the "denodo monitor". We have a need to log all queries from all users within VDP. I have followed the online steps and have enabled them on the server in question, but I see some strange behavior. We currently have d...

Answers: 1

denodo monitor

Denodo Dashboard - Sync
answered 09-05-2016 13:42:11 -0400

Hello, We are currently using Denodo Dashboard to sync all our production nodes. We have Denodo 5.5 in production and we are testing denodo 6 now (6 is awesome, BTW). The one thing I found strange was that the sync was only updates to existing objec...

Answers: 1

denodo dashboard

Denodo Log Custom Wrapper patterns
answered 09-05-2016 08:22:56 -0400

I am using Denodo Log Custom Wrapper to read and extract log as per below ● Date pattern: yyyyMMddHHmmssSSS ● Date extractor pattern: (?:.*?)([0-9]\{17\}) (?:.*?) ● Log timezone: PST ● Content extractor pattern: (?:.*?) (.*?)(ERROR) ([0-9]\{17\})(.*?) ...

Answers: 1

Unable to see SQL Server tables in VDP
answered 09-05-2016 05:02:24 -0400

Hi, I was able to create a JDBC connection to SQL Server. However, I'm unable to see the tables when I go to the 'Create base view' tab. The test ID was given full admin rights to the schema. And I'm able to query the tables successfully within SSMS. ...

Answers: 4

VDP SQL Server