Q&A

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

How to name the CSV Output file from Scheduler using a field from the view, without selecting that specific view in the selection query which will load the fields in the CSV File
answered 07-11-2022 02:09:39 -0500

Hi Team, I have a view in Denodo which I need to expose the data output in CSV file. I have a field created called "filename" in the view, which has a case statement logic: If current_day() is Sunday: then Liberty ||'-' ||adday(current_day,-3) else Li...

Answers: 1

How to install odbc for mac with m1 running it? Does denodo support macos?
answered 04-11-2022 20:01:03 -0400

I have tried downloading odbc friver for linux from the drivers provided. Unable to figure out the next steps. Any help would be much appreciated.

Answers: 1

Denodo 8 ODBC

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