Latest Activity

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.

code

VQL to identify obligatory parameters/search methods via VQL

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

code

unable to ping vdp

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

code

How can I use SSO using Power BI or Python with Denodo

When setting up python scripts, or PowerBI dashboard how do I envoke SSO ? We are using SSO via Oauth on Active Directory. In Power BI : Using Denodo connector Using DSN settings : Server=<our ip>; port=<our port>; database=<our db> ...

code

VQL - Identifying non fully-delegated queries

Is there a way to determine which queries Denodo will not delegate in full to source via VQL or otherwise ?

VQL
code

Support for AWS code commit via git credential helper

Hi, I am currently looking at the possibility of using AWS code commit with Denodo. However, I cannot see how we can configure a credential helper for code commit in Denodo. There are restrictions that use of SSH keys, username/passwords and we can on...