Latest Activity

code

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

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...

code

How to install odbc for mac with m1 running it? Does denodo support macos?

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.

code

check Denodo is installed already

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 , ...

code

Where to pass the body of an API in DENODOTEST file

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

code

Webcontainer status

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...

code

"The parameters of the function 'to_timestamp' cannot be delegated to this database." in MS SQL Server 2017

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...

code

NTLM Authentication Issue using Odata2

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...

code

Unable to connect to server (VDBResultSetIterator)

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...

code

Rest-Service over Reverse-Proxy: How to change protocol from http->https in Swagger definition?

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 ...

code

Updating a data source via REST API

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.