Home / Q&A / All Questions

Q&A

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

Query for multiple views and record count
answered 21-01-2022 06:11:21 -0500

Hi team, I need the record count for multiple views. How can i do it in a single query?? Select count(1) From View1; Select count(1) From View2; Select count(1) From View3; Select count(1) From View4; Thanks!

Answers: 1

How to manage Remote Tables in Denodo Test and Production environments
answered 20-01-2022 07:47:04 -0500

Beeing able to use Remote Tables is a very nice opportunity i many situations. When used with our Datawarehouse solution we whant to achieve a following situation - In the DenodoTest we use Production data when developing new solutions. When using Remo...

Answers: 1

How to connect to Denodo from EBIS and MS Dynamics 365?
answered 20-01-2022 07:22:47 -0500

How do we connect to Denodo from EBIS and MS Dynamics 365? Also, is there a way to ingest data from Denodo to these 3rd party tools via doing somehting in Denodo?

Answers: 1

Intermittent LoginFailure -1
answered 19-01-2022 07:57:19 -0500

Hoping you could assist with a LoginFailure -1 issue. our Tomcat service makes requests to Denodo: Application information: Tomcat REST service utilizing Spring MVC framework and Spring Boot Request format: A GET request is sent to Denodo REST se...

Answers: 1

Role Based Access Control - Masking
answered 19-01-2022 06:21:46 -0500

I do have few questions around masking fields using Role -> Add restrictions -> Mask sensitive fields. Is there a way to manage governace in denodo as in to define these sensitive fields (PII/SPI) at view level and let those fields automatica...

Answers: 1

Denodo ODBC connection with Kerberos becomes invalid after an attempt to execute bad SQL query
answered 19-01-2022 06:07:22 -0500

Hello Denodo Team, my customer uses my ad-hoc query tool to connect to Denodo Virtual Data Port using ODBC driver with Kerberos authentication. All works fine, until the user tries to execute SQL query with error in it. The query fails as expected and...

Answers: 1

kerberos Denodo 8 ODBC

Denodo monitor reports
answered 19-01-2022 06:01:01 -0500

Hi Team, i have updated the server information and test connection is successful. but in "Reports Configuration" if i click on execute VQL script getting below error. i have created the denodo_monitor bd in VDP. Error produced during Server update (...

Answers: 3

Executing Stored VQL via Scheduler
answered 18-01-2022 22:23:02 -0500

Hello, We want to develop a query builder for our business users where they can create queries interactively on denodo base views as per their requirements. They can also choose a frequency (e.g. Hourly, daily) for which query should execute automatica...

Answers: 2

Dynamic Sche

connect ABSORB using API key and URL , using DENODO 8
answered 18-01-2022 05:31:45 -0500

Hi Team, Can we connect ABSORB using url and API key? if yes please provide a detail document for the same. Please let us know the pre requirement before commencing ABSORB connectivity to Denodo.

Answers: 1

Connecting to Denodo from DataGrip
answered 18-01-2022 05:02:46 -0500

Hi, I am trying to connect to Denodo from DataGrip, but I I don't know what datasource to choose. Denodo is not listed in the sources. Anyone know where to go from here? Thanks in advance.

Answers: 2

#Datagrip #Connecting