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

Getting the wrong query for external web service
answered 03-07-2018 12:47:46 -0400

I am a denodo newbee. I am trying to use OpenWeatherMap.org's web service interface to pull temperature data from a certain time and location and put it into a Denodo table. I can get Denodo to create the SQL to make the call, but it is using the wron...

Answers: 1

Connecting to an external web service

Getting alert "The VDP Server and the Administration Tool have different updates" whenever I try to login to Denodo Server from the local client
answered 03-07-2018 12:12:31 -0400

I am using Denodo Virtual DataPort Version 6.0. Whenever I login to Denodo Server from my local machine. I get following alert -"The VDP Server and the Administration Tool have different updates: VDP Server: 6.0.201800216 Administration Tool: " Could ...

Answers: 1

VDP alert Administration Tool

Connect to on-premise SQL Server and Oracle data sources from Denodo installed on an Azure VM
answered 03-07-2018 10:40:37 -0400

Is it possible to connect using a JDBC connection to an on-premise SQL Server from a Denodo Virtual DataPort installed on an Azure VM? I've found the concept of "Hybrid Data Hub". It looks like what I want to do, but there is no guidance on how to set...

Answers: 4

Error with data movements using Excel files
answered 03-07-2018 08:15:37 -0400

Hello, I have a Derived View which contains multiple joins to other Derived and Base Views. The Base Views are sourced from individual Excel files. The Derived Views are derivations and joins on those Excel files. I wanted to turn on the Data Movement...

Answers: 1

Data Movement

Denodo Views
answered 03-07-2018 08:12:42 -0400

Hi Denodo community, I have the following: Data Source: JSON * Name: HTTP CLIENT * Configure: Post * URL: Rest Call The source currently has nested elements, some fields either appear as a register or arrays. I do not want to...

Answers: 4

post Json Base view JSON

Denodo Jobs with dependencies
answered 03-07-2018 06:33:43 -0400

Hi Team, Any way to create a job with dependencies without a CRON trigger. There are 5 jobs which I want to run in sequence, but to set a dependency it seems CRON trigger is also to be set. Please help. Denodo 5.5 Thanks.

Answers: 4

Scheduler

Tutorial Schema.sql not compatible with MySQL 8.0?
answered 02-07-2018 14:04:49 -0400

I downloaded MySQL 8.0, and the Denodo tutorial schema.sql. I am receiving syntx errors on the GRANT statements. I am assuming this is because syntax has changed for MySQL version 8.0? Is there an updated schema.sql script that works with 8.0?

Answers: 2

Java Program for importing from a single VQL file?
answered 02-07-2018 13:06:58 -0400

Hi team, can anybody help with the best way to consume/import an exported VQL file using a Java program. I know one method - by using JDBC, and then reading the VQL file using BufferedReader, and then executing each statement on the VDP Server. Howev...

Answers: 1

java code

Denodo Platform Control Center only Allows me to run Virtual Platform Control Center - Stop / Running Virtual DataPort Server missing in control center
answered 02-07-2018 11:48:26 -0400

In the Denodo Platform Control Center - All I can do is launch the Virtual DataPort Administration Tool. I do not have the ability to stop or start the Virtual Dataport Server - it is not in the control center at all (missing) I just have the ability t...

Answers: 1

Denodo Scheduler Cache update jobs are failing due to [GROUPBY] [ERROR]
answered 02-07-2018 10:18:18 -0400

Below is the error message logged in the VDP. Is this due to lack of swap space?? what does Too many open files mean??? 14913679 [Access(1369)-22-05.00-ent_davita.dv_spr_rsltsorgnsmantbtc_log_cwow_cache] ERROR 2018-06-28T20:32:02.634 com.denodo.vdb.en...

Answers: 1