Q&A

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

DNS entry like catalog.se.demo.net
answered 24-02-2020 04:52:06 -0500

Hi Team, catalog is listening to port 9090 which is not that user-friendly. Is it possible to create a DNS entry like catalog.se.demo.net where you can access the data catalog Please let me know how to do that.

Answers: 1

data catalog

Is it possible to create a southbound connection as well from Denodo to Sap Business Objects Universe?
answered 21-02-2020 11:33:52 -0500

Is it possible to add SAP BO Universe as a datasource in Denodo, so southbound connectivity from Denodo to SAP BO Universe?

Answers: 1
Related to: How to access VDP from SAP BusinessObjects

Reading unformatted values from a XLS file
answered 21-02-2020 07:47:36 -0500

Hi, connecting to a XLS file, I am able to read all the content I wish. But the fact is that DENODO seems to read the formatted values from the cells (visible reading the XLS through Excel), not the actual values stored in it. Example : if a cell conta...

Answers: 3

XLS CELL FORMATTED