Q&A

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

Installing Denodo
answered 13-04-2020 13:25:34 -0400

Hi, I'm running an Ubuntu Distro for Linux and wondering if I will be able to install Express edition to see and understand the data virtualization features offered. Thanks. <<Please ignore, I already found the answers in Q&A that Ubuntu is...

Answers: 1

Ubuntu

Port of MySQL
answered 13-04-2020 08:05:06 -0400

Hello, I have already mysql-server image on doker, using the port 3306. Is it possible to change the port of MySQL installed by denodo ? Or , if i want to use your database acme for tutorial, how can i get the script ? Thnak you.

Answers: 3

Denodo_MySQL

default limit set on the derived view
answered 13-04-2020 00:40:13 -0400

Hi , Can we set default row limit on the derived view? if yes how can we increse to max limt?

Answers: 1