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.

Denodo to Salesforce via API
answered 21-10-2019 07:23:03 -0400

HI Team, I am trying to get counts of below two objects in Salesforce via API call from Denodo. The counts are varying between Denodo API call and Workbench. Even running below API query in Salesforce(workbench)REST Explorer gives the same count as SO...

Answers: 1

DENODO sales force connection

Denodo Server after Installation error
answered 21-10-2019 02:25:08 -0400

I installed the denodo server and started service after setting up SSL. THe srevice say's running. But i amnot able access the datacatalog and VDP server. Then check logs of VDP. Below error found in VDP.log 5484 [Thread-3] TRACE 2019-10-19T00:43:53.7...

Answers: 1

Installation

How to Update and Insert Data into Table using source Table in different Environments.
answered 21-10-2019 01:22:28 -0400

Hi Team, Good morning!!!! Good Day!!! I Have a question that I having 3 tables(Table A,Table B and Table C) which or in different Environments so Here I want to Update table B using Table A and I want to Insert into Table C using Table A, simple we ca...

Answers: 3

Alert Configure after Detect Changes in Data Source (Oracle DB)
answered 18-10-2019 08:06:33 -0400

Hi team, I already knew that we can detect changes in data sources as shown in the following help page. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources After detecting the changes...

Answers: 4

alert datasource SOURCE_CHANGES()

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Answers: 5

Query Full Cache WHERE CONDITIONS Cache

Select data from view using input variables
answered 18-10-2019 07:31:12 -0400

Hi, Is there a way to use something similar to pl/sql bind variables when selecting from a Denodo view that doesn't have parameters defined? I need to get the data based on an input variable that comes from the application. For example: select * from ...

Answers: 1

Which version of the Denodo Monitor matches the version of VDP Server 7.0 update 20190903?
answered 17-10-2019 07:05:58 -0400

The problem seems minor since monitoring appears to work fine despite the version discrepancy. Still... I stopped monitoring, I installed VDP Server upgrade, I extracted the supposedly new denodo-monitor package I started monitoring $ den...

Answers: 1

denodo monitor Denodo Monitor

Denodo Installation
answered 17-10-2019 07:02:27 -0400

After the installation of Denodo platform server, while starting the VDP server we are getting error Could you pleas help us Unexpected error. 2019-10-15 19:10:36,119 main ERROR An exception occurred processing Appender FILEOUT java.lang.NumberFormat...

Answers: 1

DENODO

Character MisMatch Error while using Coalesce function in Denodo
answered 17-10-2019 05:46:17 -0400

Team , We are using Coalesce function in Denodo which is equivalent of NVL in Oracle. Source Datatype for that particular column is NVARCHAR.We are able to see the data in Base views for these columns. However , While using Coaleasce function in deriv...

Answers: 1

executeVqlCommand(String databaseName, String command) doesn't take account of the databaseName.
answered 16-10-2019 13:48:51 -0400

I'm building a StoredProcedure to change the schemaName of all (Jdbc) baseView of a specified DataSource. I'm using the Denodo java extention. The StoreProcedure is in admin denodo database and i would be able to change the schema name of a baseview ...

Answers: 2