Q&A

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

Issue with connecting Denodo to Excel file: Unable to establish connection and no details?
answered 29-06-2018 12:54:29 -0400

When trying to connect Denodo to an Excel file on the network, it gives us an error message that ends partway through the filename and gives no context. It just gives the message 'Unable to establish connection: //<servername>/<folder>/P .....

Answers: 1

Denodo Solution manager and Denodo 7.0 Control center
answered 29-06-2018 12:04:38 -0400

Hi Team , I have installed Denodo Solution Manager and Dendo 7.0 Paltform on my System . But I obesrved that , Launching Denodo Solution manager and Dendo 7.0 Control Cnecter takes more than 5 min Starting any server on Denodo Solution Manager...

Answers: 3

installation