Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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