Q&A

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

Getting interface view column names from reference table
answered 24-01-2022 06:36:04 -0500

Hi, is there a way query a table and list it's column names and then the original column names and the interface view it maps to via SQL / VQL? For example: CustomerReport (derived table name) custid - maps to CustomerID in Customers interface view ...

Answers: 1

Script to convert column names to CamelCase
answered 24-01-2022 06:15:24 -0500

Hi, Is there any script for converting the column names to Camelcase? Thanks!

Answers: 1

Pass data values from Power BI to Denodo Views
answered 21-01-2022 06:48:36 -0500

I have a Dashboard in Power Bi where user can display reports per Month depending the date they select, is it posible to pass this value from Power BI to Denodo Final View (This view should filter information based on the date provided by user in Power...

Answers: 1

Ellipsis converting to a Special Character while downloading data from Denodo
answered 21-01-2022 06:45:08 -0500

We are using Denodo VDP 7.0. Our data has a … (Ellipsis) symbol in a row. The problem exists when the data is downloaded from Denodo or extracted from Denodo. Below is the problem. When we try to extract data from a Denodo view, the data gets chang...

Answers: 1

Denodo view

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