Q&A

Data Source creation in Denodo 7.0
answered 25-11-2020 05:35:09 -0500

Hi Team, I am getting error while saving the data source created for MYSQL using Denodo 7.0. I am able to connect with data source successfully. But when I am saving the data Source a window popup with ysntax error message saying "Syntax error: Unknow...

Answers: 2

MYSQL Data Source

Join condition on delimited files
answered 24-11-2020 04:04:15 -0500

Hi Team, I want to join 2 views.First view is created from Json file and second view is created from delimited files(Text Files) I need to join both of them on basis of one coloumn. This column can be easily written by specifying view name and then ...

Answers: 1

Denodo Metrics
answered 23-11-2020 09:40:19 -0500

Is there a way to get metrics on the following: # of roles not just list roles I am looking for counts.

Answers: 1

record count

Denodo VDP Client software version compatibility (version 6.0 20180216) inquiry for VDP server 7.0
answered 23-11-2020 04:12:13 -0500

I would like to know the client software version compatibility of Denodo VDP server version 6.0 20180216. I would like to upgrade my local Denodo VDP client of version 6.0 20180216 up to 7.0 in order to obtain advanced feature in data catalog (meta da...

Answers: 1

VDP 7.0 VDP VDP client

parse error
answered 23-11-2020 01:38:19 -0500

Parse fail in denodo bridge. This is my file: -<rdf:RDF xmlns:si="https://www.w3schools.com/rdf/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"> -<rdf:Description rdf:about="https://www.w3schools.com"> <si:title>W3Schools&...

Answers: 1

Denodo Model Bridge

Recursive/Hierarchical Query
answered 20-11-2020 04:49:45 -0500

We are looking to perform a hierarchical/recursive query similar to a CONNECT BY query in Oracle or a CTE in SQL Server. Here is a working query in SQL Server that we are attempting to reproduce in Denodo. Denodo understands the "with" clause, but no...

Answers: 7

After AMI update to denodo solution manager there is a foilder /denodo but no solution manager software under that folder, Any ideas?
answered 20-11-2020 04:15:59 -0500

After AMI update to denodo solution manager there is a foilder /denodo but no solution manager software under that folder, Any ideas? In /etc/fstab file there is entry for /dev/sdh and no errors in AWS console for attached volume to the new instance I...

Answers: 1

Denodo 7.0 DENODO

Cannot login into Design Studio
answered 19-11-2020 07:35:37 -0500

Installed express version C:\Denodo\DenodoPlatform8.0. Servers runs. Made some changes for database itpilot (with command "alter database") After restart server cannot login with user "admin\admin" Have error Forbidden. How change browse and change set...

Answers: 1

#Design Studio

Cannot login into Design Studio
answered 19-11-2020 07:32:19 -0500

Installed express version C:\Denodo\DenodoPlatform8.0. Servers runs. Made some changes for database itpilot (with command "alter database") After restart server cannot login with user "admin\admin" Have error Forbidden. How change browse and change set...

Answers: 1

Joinin view from different data source
answered 18-11-2020 07:37:05 -0500

I have created 2 views from 2 different folder of same parent folder. Suppose parent folder name is Parent and it has 2 subfolder like subfolder1 & subfolder 2 I have created derived view by joining both views.Now challenge is when I am trying to ...

Answers: 1

Derived views