Q&A

There are 3 columns in the Denodo view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know
answered 14-04-2020 19:38:05 -0400

There are 3 columns in the Denodo derived view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know

Answers: 1

Denodo view

FedRAMP Compliance
answered 14-04-2020 16:28:21 -0400

Is Denodo FedRAMP compliant? If No, are there plans to do so in future? Are there US Government Agencies (Federal or State) using Denodo? I ask these because I plan to work with few government solution providers to push this product. Also, who are De...

Answers: 1

FedRAMP

DB2 - firstdayofmonth with an Analytical function
answered 14-04-2020 15:25:18 -0400

Database: DB2 I created a view with a date compare in the where clause field1 >= addmonth(firstdayofmonth(current_date()), -2) Then used an analytical function in the same view row_number() OVER ( PARTITION BY field2, field3 ORDER BY field4 DES...

Answers: 1

DB2

DB2 - WITH UR
answered 14-04-2020 15:13:08 -0400

Database: DB2 We are having a performance issue with a query and our DBA suggested to use "With UR" clause at the end of the query. At this time, the view in Denodo is built using the UI and I am not able to add this in where clause and I don't see an...

Answers: 2

DB2

How to install Denodo Model Bridge ? Does it require separate license ? We use Denodo VDP V7.0 Update 20190903.
answered 14-04-2020 14:54:26 -0400

How to install Denodo Model Bridge ? Does it require separate license ? We use Denodo VDP V7.0 Update 20190903.

Answers: 1

JDBC REDIS connector
answered 14-04-2020 14:27:41 -0400

Hi, Is there a JDBC REDIS connector available ? (https://redis.io/) Anyone tested JDBC REDIS for Deneodo Cache ? Thanks, José

Answers: 1

REDIS

Fail to Browse web pages using itpilot
answered 14-04-2020 13:45:30 -0400

Hi, I try to open browser at itpilot but I got this error ERROR 2020-04-13T13:55:15.464 com.denodo.itp.admin.model.specgenerator.browser.socket.BrowserCreatorSocketImpl [] - createLocalBrowser: Error while creating browser com.denodo.itp.admin.model.sp...

Answers: 1

ipilot

VDP Client Upgrade on Windows 10 Laptop
answered 14-04-2020 12:58:32 -0400

Recently upgraded VDP server to 7.0.20200310. Denodo Admin Tool ( on my Windows 10 laptop ) is at 7.0.20190903. It now shows a warning message about mismatch between VDP server and Admin tool. What is the best way to upgrade client on my PC to bring ...

Answers: 1

VDP client

Not able to connect to SQL Server using an Active Directory account
answered 14-04-2020 04:35:40 -0400

Hello, I am using Denodo 6.0 In the VDP tool, I am trying to connect to a SQL Server database using a Active Directory account (domain \ account name). However, when I test the connection, the tool is telling me: 'Unable to establish Connection. Login ...

Answers: 2

SQL Server Active Directory

Connect to Oracle database with JDBC
answered 14-04-2020 00:10:19 -0400

I am new to the VDP and having an issue connecting an Oracle database. I have no issues connecting via ODBC in my other environment using the following credentials: TNS Service Name: ABC123.COMPANY.COM with my user ID and password defined (driver is 1...

Answers: 1

Oracle 12c JDBC Data Sources