Q&A

Run Scheduler Job Based on Value from a Query
answered 27-05-2020 08:21:52 -0400

Hello, Is it possible to allow a Denodo Scheduler job to start only when the value returned by a query indicates it is ok for the job to start? The scenario is as follows: We want to cache a Denodo view. However, before we can start the cache job, we...

Answers: 1

Conditional Job Run Scheduler

import.sh run vql, which vql contained parameter, how to make it?
answered 26-05-2020 17:41:43 -0400

We have linux machine with denodo client installed, we use import.sh to run some vql file, I have a question, if my vql file wants to have a parameter such as where filters contain some parameter, can import.sh run that vql with parameter contained in ...

Answers: 3

vql vql parameter import.sh

Hello, I am trying to extract data from an excel file which is in a shairpont. do i have to create an excel data source and use http client (how) or do i go through xml data source?
answered 26-05-2020 10:24:27 -0400

I am trying to recover data from an excel file which is in a shairpoint. do i have to create an excel data source and use http client or do i go through xml data source?

Answers: 6

Certificate of Training
answered 26-05-2020 09:17:13 -0400

Hi, I completed on-demand Denodo DV Architect training today (03/04/2018). Under Achievement tab it is showing completed but I do not see any option of printing certificate or share on linkedIn. Please advise how can I get certificate of successful com...

Answers: 3

SELECT TOP
answered 26-05-2020 06:36:36 -0400

Hi! I am having an issue with this query: SELECT TOP 5 * FROM TABLE It shows the message: Error: Exception parsing query near 5 Thanks

Answers: 1

DESC DATASOURCE JDBC (all jdbc datasources) for base view
answered 26-05-2020 06:35:30 -0400

Hi, I need to create base view from query and my query it´s DESC DATASOURCE JDBC (all jdbc datasources). How do I do this? I create base view with this information in text mode: DESC DATASOURCE JDBC vdb1.ds_source1 DESC DATASOURCE JDBC vdb2.ds_sourc...

Answers: 1

Error while connecting denodo node via vdp or dbeaver
answered 26-05-2020 04:37:26 -0400

Hi, We couldn't connect to Denodo server and were coninously gettign below error. 37971887 [ODBC(138)-] ERROR 2020-05-22T00:05:03.193 com.denodo.vdb.vdbinterface.server.odbc.ODBCBackend [] - Error: connection error: Could not initialize class sun.tex...

Answers: 1

When use import.sh to run vql, where is the vql output file?
answered 24-05-2020 23:24:14 -0400

We have linux machine with denodo client installed, we use import.sh to run some vql file like below: $DENODO_HOME/bin/import.sh -f ${vqlFile} -h "${databaseURI}?${uid}@${passwords}&queryTimeout=9" > ${tempFile} 2>&1 The vqlFile we run ha...

Answers: 5

output command line import.sh

Can a user edit the rest web service deployed? If yes, can I get the details of user who edited the web service as additional columns in the same view?
answered 22-05-2020 03:57:40 -0400

Hi Team, I got a usecase today from my client. We need to create a materialized table in denodo with some 6 columns in it and the data is cached. After that we need to deploy this table as a web service. A user who is accessing the data from web servic...

Answers: 1

REST API

Cache - Error modifying view: View names not available
answered 22-05-2020 03:33:28 -0400

Hi, I'm using donedo express. I configured my donedo server with following settings: cache status ON maintenance OFF Defaut time to Live 2160 Specify an existing data source CHECK. I specified one of my existing donedo data source setup. When I try...

Answers: 1

Cache