Q&A

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

Pull messages from sender JMS Queues into Denodo
answered 13-09-2019 07:23:24 -0400

Hi Experts, We are on Denodo 7.0 version and the requirement is to connect with TIBCO Middleware to pull the data from TIBCO JMS queues. (E2E Flow: Source Application-->TIBCO-->Denodo-->Target Application) Is this possible with Denodo to pull...

Answers: 1

Push DB data to a Service.
answered 12-09-2019 08:14:21 -0400

I created two data sources: JDBC: direct connection to a database JSON: to send data on an external service How to connect the two data sources above? I want to make sure that the data retrieved from the database is used as parameters of my HT...

Answers: 3