Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Context clause wiped out by VDP....
answered 27-02-2020 07:29:05 -0500

I created a new derived view from a base view and provided the context for 'queryTimeout' setting e.g. SELECT ... FROM ... CONTEXT ('queryTimeout' = '9000000') However, VDP keeps replacing it with SELECT ... FROM ... CONTEXT ('formatted' = 'yes') ...

Answers: 1

Denodo7 hibernate jar not found
answered 27-02-2020 07:25:11 -0500

As per Denodo documentation Hibernate jar is available under /dist folder in the installation directory. But we couldn't found the folder /dist in our Denodo7 installation directory. Requesting your support on this issue

Answers: 1

Hibernate Denodo Jar

LISTAGG QUERY SAMPLE
answered 27-02-2020 07:23:54 -0500

Hi, please provide a query sample example to show the function listagg. Currently i am not able to produce syntactically correct query even though i follow the syntax. Also please do not provide the listagg function link in ur community as i already...

Answers: 1

listagg

Scheduling job to load data for all the month-end dates in the caching database.
answered 26-02-2020 07:47:06 -0500

Hi, We have created multiple final views with mandatory parameter 'as_of_dt' for each view. Now, we want to schedule job to load all month end data in cache.( all month end dates for future and past- not any single month end date ) I was planning to ...

Answers: 1

Denodo 7.0 Denodo Scheduler 7.0

VDP SSL connection with Talend
answered 26-02-2020 07:39:43 -0500

Hi Team, We are trying to extract the data from denodo views using Talend. While we are creating the a connection in Talend , we are getting the below error. Our VDP server is SSL enabled. We are able to connect from my machine and machine is enable wi...

Answers: 1

Talend

MongoDB vs JSON
answered 26-02-2020 07:37:35 -0500

Hello, Here is the context for my question. It is an architecture question. We have centralized our data sources in Denodo. Now, this data must be consumed by a system that has a back-end on MongoDB. I would like a billateral communication. The linea...

Answers: 1

Connector JSON API mongodb

Parameterised Query
answered 26-02-2020 03:40:42 -0500

Hello, I came across one issue. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am passing through GET request when i am callin...

Answers: 3

Paramaterised Query In Clause

Cannot START "Denodo Training QuickStart Virtual Machine.ova" in Oracle VM VirtualBox
answered 25-02-2020 12:17:49 -0500

Hi, I followed the steps from "installation and Configuration Guide" (Denodo Training QuickStart Virtual Machine) But in section "Launching DQVM", When I click START green arrow, I got this message: VT-x is not available (VERR_VMX_NO_VMX). Code d'err...

Answers: 2

VirtualBox Denodo Training QuickStart Virtual Machine OVA Virtual Machine

Getting IO Error when i add new Data source - Oracle 11g in the Denodo Virtual Data port tool
answered 25-02-2020 07:49:44 -0500

When i am trying to connect to a Data source - Oracle 11g i am getting below error in the Denodo Virtual Data port tool Unable to establish connection: IO Error: The Network Adapter could not establish the connection I am giving the Info as Data base...

Answers: 3

connection: IOError Virtual DataPort

How can I get the number of threads used by a job or a view?
answered 25-02-2020 07:09:31 -0500

Hi Support Team, we are currently suffering performance issues running several jobs in parallel. After that, we have executed job one by one, and one of them it's failing, with next issue: Error executing query. Total time 476.963 seconds. Incomplete...

Answers: 1