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.

Parameterised Query
answered 26-02-2020 03:40:42 -0500

Hello, I came across one issue. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am passing through GET request when i am callin...

Answers: 3

Paramaterised Query In Clause

Cannot START "Denodo Training QuickStart Virtual Machine.ova" in Oracle VM VirtualBox
answered 25-02-2020 12:17:49 -0500

Hi, I followed the steps from "installation and Configuration Guide" (Denodo Training QuickStart Virtual Machine) But in section "Launching DQVM", When I click START green arrow, I got this message: VT-x is not available (VERR_VMX_NO_VMX). Code d'err...

Answers: 2

VirtualBox Denodo Training QuickStart Virtual Machine OVA Virtual Machine

Getting IO Error when i add new Data source - Oracle 11g in the Denodo Virtual Data port tool
answered 25-02-2020 07:49:44 -0500

When i am trying to connect to a Data source - Oracle 11g i am getting below error in the Denodo Virtual Data port tool Unable to establish connection: IO Error: The Network Adapter could not establish the connection I am giving the Info as Data base...

Answers: 3

connection: IOError Virtual DataPort

How can I get the number of threads used by a job or a view?
answered 25-02-2020 07:09:31 -0500

Hi Support Team, we are currently suffering performance issues running several jobs in parallel. After that, we have executed job one by one, and one of them it's failing, with next issue: Error executing query. Total time 476.963 seconds. Incomplete...

Answers: 1

twitter
answered 25-02-2020 07:03:00 -0500

Hi Team, On Denodo Express 7.0 can I perform these ? https://community.denodo.com/kb/view/document/Twitter,%20sentiment%20analysis%20and%20Denodo?category=Custom+Elements https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Te...

Answers: 1

twitter

Import Role access to non-admin users
answered 25-02-2020 02:09:57 -0500

Hi, We are Denodo 7.0.20190903. We have a requirement to provide "import role from LDAP" capability to a non-admin user. Please elaborate how this can be enabled. Thanks.

Answers: 1

IIS instead of Jetty
answered 25-02-2020 01:04:05 -0500

Hi: Is it possible to use IIS instead of Apache as web server? Regards, Jose

Answers: 2

[SQL0401] Comparison operator = operands not compatible.
answered 24-02-2020 07:58:57 -0500

Error : [SQL0401] Comparison operator = operands not compatible. DataSource is DB2. and data type of DATE_TRANSACTION IS date(deprecated) None of the below query works. Queries: SELECT FROM "Discovery_FiservODS"."EFT_TRANS_HISTORY" WHERE "DATE_TRAN...

Answers: 1

VQL

Preventing Denodo from creating a base view in two places
answered 24-02-2020 07:09:57 -0500

In Denodo platform 7.0, is there a setting or way to create a base view such that it is not listed in two places of the server explorer? As per https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources...

Answers: 3

Base view records deletion
answered 24-02-2020 04:58:03 -0500

We have two base views base view 1 : temp_del Name , age base view 2 : temp_del_2 Name , age I want to delete some records in base view 2 (MSSQL) using the below query. delete from temp_del_2 where name not in (select name from temp_del) It res...

Answers: 1

Delegate deletion