Q&A

Delete views in other environment that have been deleted in the reference environment via Denodo 7 solution manager
answered 18-09-2019 04:18:18 -0400

Hello, I have deleted a couple of views in my Denodo reference environment. Now I want to create a revision for this and promote to other environments. I cannot select them for DROP in a revision in the solution manager (because I deleted them, they...

Answers: 1

DEN70EDUD1201LAB01 - Create a JSON data source and base views
answered 17-09-2019 22:05:32 -0400

Hi Team, I am currently learning to import the JSON data source and i facing below issues. Please help on this. OS: Linuxmint Using virtual machine: My virtual machine is running and when i try to ping the ip address of virtual machine it is succ...

Answers: 1

training

Meterialized View Update
answered 17-09-2019 08:32:40 -0400

Is it possible to update a materialised table by joining it other base view?

Answers: 1

materialized table update

Denodo cross database insert
answered 17-09-2019 08:30:45 -0400

Hi, Is it possible to insert records in denodo from a base view of database vdb1 into another base view of database vdb2. Insert records into vdb1 from select * from vdb2; if the records exists we need to update those records.

Answers: 1

insert update

Execute pre- and post deployment VQL via the solution manager
answered 17-09-2019 07:57:06 -0400

Hello, I would like to execute some VQL on the machine(s) in the target environment pre- and post- deployment for one of my environment via the Denodo 7 solution manager. Is this possible, if yes how?

Answers: 1

Unable to see User Management & Role Management
answered 17-09-2019 07:38:31 -0400

Hi Team I've recently installed Denodo 7.0 on my Windows system. But I'm unable to see (Role Management & User Management) those options are disabled in VDP. But I've logged in through default admin account. Could you pls help. Thanks Kittu

Answers: 1

How to unwrap CDATA section in SOAP response to expose XML document
answered 17-09-2019 06:55:09 -0400

Hello I have a web service data source in Denodo 7 and one of its operations returns a single column text result which contains an xml document embedded in an XML CDATA section. I would like to be able to flatten / parse the xml doc in denodo but at t...

Answers: 1

CDATA

Output file in Secured location
answered 17-09-2019 05:47:27 -0400

In the Output folder in CSV exporter in Denodo Scheduler, we are able to create a file and put it in Denodo default location. However in my use case I have a secured location which needs username and password to put the file there. In Denodo Schedule...

Answers: 1

Best practices for combining VCS/versioning with development teams and Denodo 7 solution manager
answered 17-09-2019 02:20:26 -0400

Hello, where can I find or what are best practices in Denodo 7 for the following cases: development team(s) of denodo where multiple developers work on the same virtual database: they want to be in sync with each other (VCS?) they want to be i...

Answers: 1

Solution Manager External mysql Database configuration
answered 13-09-2019 07:27:58 -0400

Hi Team, I am trying to configure the external database for solution manager. My db is aws aurora. I am getting the below error Database validation error: Unable to establish connection. Access denied for user 'theusr'@'22.55.66.123' (using password: Y...

Answers: 1

solution manager install