Q&A

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

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

How can I use SSO using Power BI or Python with Denodo
answered 01-11-2022 09:26:34 -0400

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

Answers: 1

#powerBI connection #Denodo-PowerBI oauth2 SSO

VQL - Identifying non fully-delegated queries
answered 01-11-2022 08:59:43 -0400

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

Answers: 1

VQL

Support for AWS code commit via git credential helper
answered 31-10-2022 06:05:57 -0400

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

Answers: 2

git VCS codecommit credential helper AWS

Denodo doesnt kill the database connection when the query times out
answered 28-10-2022 08:26:55 -0400

Using the latest Denodo 8.0 with the Aug patch. Question - Per the time limit set for ODBC in VDP server config file, when a query runs beyond 15 mins it gets killed in VDP client but it doesnt kill the respective connection in the source database (Re...

Answers: 3

Connecting Tabealu on Denodo

RDS metadata and IAM based authentication
answered 28-10-2022 07:58:24 -0400

Hi, I am currently working on configuring RDS to be used for storing denodo metadata. As a security requirement, we need to secure the RDS via one of the two methods Use IAM based authentication for RDS instances Rotate the db user passwords on ...

Answers: 5

rds password less iam password rotation aws

Finding active no.of connections
answered 28-10-2022 05:13:04 -0400

Hi Team At a specific time, there is connection timed out from Denodo when application is connecting with it.I would like to find out the no.of active connections between Denodo and third party application e.g Power BI ( not Data source ) at given po...

Answers: 1

Connection with ODBC

Power BI reports - Creates multiple queries
answered 27-10-2022 16:56:48 -0400

Using the latest Denodo 8.0 with the patch released this Aug. Question is, we seem to be having multiple queries that are exactly same in Denodo Query monitor when we run a report from Power BI. Why does it create same queries in Denodo? Is there a re...

Answers: 2

Power BI ODBC connection with Entity Framework