Q&A

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

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

Startup scripts and password prompts?
answered 21-02-2020 07:34:17 -0500

When I manually execute vdpserver script, line: su -c "$DENODO_HOME/bin/vqlserver_startup.sh" $VDP_USER || return 0 ask me for the $VDP_USER's password. How will this work when the script is automatically run from /etc/init.d? (i.e. will the passwor...

Answers: 1
Related to: Linux startup scripts for Virtual DataPort, Scheduler and Web Tools