Q&A

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

ON CONFLICT Clause
answered 18-09-2019 06:48:48 -0400

Does denodo support on conflict clause for updating ?

Answers: 1

on conflict SQL

Finished with error: java.lang.OutOfMemoryError: Java heap space
answered 18-09-2019 05:31:24 -0400

Hi Team, We are creating a aggrated value views with grouping 6 columns. We are using the Denodo recommended configuration for AWS. We are increased the JVM java.env.DENODO_OPTS_START=-mx4096m -XX\:NewRatio=4 When we are running in oracle we got 4000 ...

Answers: 1

jav error

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