Q&A

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

check Denodo is installed already
answered 04-11-2022 19:57:37 -0400

Hi Team, How to check whether Denodo is installed already in a linux box using CLI ? Once it is confirmed it is installed or not , then we will identify the process ID of services .Already know to get the PID of denodo services. Thanks in advance , ...

Answers: 4

Denodo Installation

Where to pass the body of an API in DENODOTEST file
answered 04-11-2022 05:48:26 -0400

I want my body to be like that: grant_type, client_id, client_secret Below is a test case I'm trying to run https://drive.google.com/file/d/1peiszrO6cRY4bCYZmCcOINQpSbYU5pJM/view

Answers: 1

Denodo TEsting Tool #automation_testing

Webcontainer status
answered 04-11-2022 02:45:45 -0400

For linux start/stop scripts we typically check if a process is already running before starting it, as well as rotate it's logs. How do we do that with these webcontainers like designstudio_startup, datacatalog etc. ? We need a designstudio_status , th...

Answers: 1

WEBCONTAINER_ELEMENT_STATUS() "modified"

"The parameters of the function 'to_timestamp' cannot be delegated to this database." in MS SQL Server 2017
answered 04-11-2022 01:51:20 -0400

Hi. In my view, I use the TO_TIMESTAMP function to parse a string to a timestamp. In the VQL, it looks like this: to_timestamp('dMMyy', common.i_bv_erp_kund.creation_date) But now, queries involving this view won't get pushed down to the source becaus...

Answers: 1

to_timestamp sqlserver mssql performance

NTLM Authentication Issue using Odata2
answered 03-11-2022 23:34:21 -0400

We created a new data source using OData wrapper to access a web API and we have an authentication issue using NTLM. The Denodo server is in a PROD environment and the API in a DEV environment and every ports are Blocked between the 2 environments. Sin...

Answers: 1

odata2 NTLM Authentication

Unable to connect to server (VDBResultSetIterator)
answered 03-11-2022 10:54:51 -0400

Hallo, We are using Denodo JDBC driver version 8.0.20220126. Once every day we get the same error in the logs: "Unable to connect to the server" originating from: com.denodo.vdb.vdbinterface.client.util.iterator.VDBResultSetIterator Does anyone have...

Answers: 2

Rest-Service over Reverse-Proxy: How to change protocol from http->https in Swagger definition?
answered 02-11-2022 11:47:00 -0400

Hi! we are exposing denodo rest-services over a reverse-proxy (haproxy) which terminates the https-connection and forwards the REST-requests towards the Denodo REST-services (tomcat) via http. Unfortunately, the swagger base_url still uses http (and ...

Answers: 2

rest swagger

Updating a data source via REST API
answered 02-11-2022 08:43:50 -0400

Is it possible to update the details of a data source via an API call on Denodo 8? Specifically I'd like to modify the Database URI of a JDBC Microsoft SQL Server connection without using the design studio or other graphical tool.

Answers: 1

#API #Rest_API Virtual DataPort

VQL to identify obligatory parameters/search methods via VQL
answered 02-11-2022 04:58:39 -0400

How do you determine the mandatory parameters/search methods given a view using VQL?

Answers: 1

VQL Parameter

unable to ping vdp
answered 01-11-2022 20:57:02 -0400

Hi I just want to ping denodo vdp service for that I am using: HTTP_STATUS=$(curl /app/denodo8/bin/ping.sh -v -t 30000 -q "SELECT 1" -l admin -p "encrypted:NEGrPUentvOWWaH0xPNcbaT5nxg81lSswBq6Wl7mD5msWjn3ruW9XEOLFc78Xm88BLJ5M6he1APx+ka+Ps1GBPelqrSRg8/...

Answers: 1

#ping vdp