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.

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

hive-spark
answered 21-02-2020 07:33:43 -0500

I use spark execution engine on hive , when I create queries on hive it creates spark job at return succsesfully , but at denodo when i connect hive by jdbc (jar files) or spark sql , it never success ERROR : Received exception with message 'org.apache...

Answers: 1

hive-denodo hive-spark

Commands to start/stop Scheduler Index Server
answered 21-02-2020 06:38:27 -0500

What is the command to start Scheduler Index Server? I'd like to create a startup script to do this but I don't know what are its startup/shutdown commands.

Answers: 1
Related to: Linux startup scripts for the Denodo Platform

Case statement using columns from two different tables in a business
answered 21-02-2020 03:59:17 -0500

Denodo Virtual DataPort Version 7.0 Hi. I've written a case statement in a computed field in a business view which includes references to columns from two different tables. The case statement is returning results for one table or the other but not bot...

Answers: 1

CASE

Denodo 7.0 Virtual Dataport - Trying to set read-privileges for roles
answered 20-02-2020 08:20:41 -0500

In Denodo 7.0 Virtual Dataport, I want to control what certain roles can read - in this case, I would like a role to be only able to view derived views and not be able to view base views through a JDBC connection (specifically DBVisualizer). I have i...

Answers: 1