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.

passing one of regiser or array fields as parameter in webservice url
answered 18-09-2019 09:22:17 -0400

hi, how to convert the below query to a webservice url? select * from tableA where (x).y.z=1 here x is a register of array y with field z Thanks, chethan

Answers: 1

REST Webservice

Using SSIS to source Data from Denodo
answered 18-09-2019 08:51:59 -0400

I am sourcing data from Denodo using SSIS, I am getting the error below and I dont have an idea what i could be doing wrong, Please assist. [ADO NET Source [2]] Error: System.Data.OleDb.OleDbException (0x80040E14): ERROR: Syntax error: Exception parsi...

Answers: 1

@primavera AWS HIVE JDBI Connection URI @data-server Bulk Data Load @wsdl SSIS 'Java heap space' DENODO SSIS

Trying to connect to Denodo Server using node js
answered 18-09-2019 08:23:43 -0400

Hi, I am trying to connect to denodo server using node js. But other than jdbc/odbc, is there any other way to access denodo server? I am facing issues while installing jdbc/odbc libraries in node js

Answers: 1

server denodo nodejs

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