Q&A

How to debug a custom handler?
answered 13-01-2021 06:21:56 -0500

I am developing a custom handler to be used for some of our scheduled jobs. Is there a step-by-step tutorial for debuging custom handler code? What I have found so far are for custom extentions of VDP functinalities (functions or stored procedure). Fo...

Answers: 3

Denodo4E

Unable to test OData Url in Postman
answered 13-01-2021 05:04:43 -0500

Hi Team, I've installed Denodo express 8 in my local system which is Windows10 operating system to practice myself. I've created local database tutorial connecting to my Oracle DB. Tested the connection it was successful. When i place the below Odata u...

Answers: 1

"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered 13-01-2021 02:26:45 -0500

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Answers: 1

Top N SAP DENODO SAP BW/4HANA denodo with tableau

REST service data source for large amount of data
answered 12-01-2021 09:56:10 -0500

I have a REST service data source containing a few million product items. How are VSQL query parameters such as ItemId converted to the query parameter on that source REST service? Does Denodo have to pull all 3 million items and then filter the resul...

Answers: 2

REST Data Source

The version of Denodo on which window (analytic) function of SQL can be used
answered 12-01-2021 07:09:17 -0500

&lt;Reference&gt; https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&amp;title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F &lt;Denodo VDP Version&gt; 6.0 Administration tool:...

Answers: 1

DENODO #Analytic function

Unable to establish connection: IO Error: Unknown host specified
answered 11-01-2021 07:41:29 -0500

Hi Experts, Getting the following error while perfroming the test connection in denodo 8 Unable to establish connection: IO Error: Unknown host specified But the same set of connectivity information is working in denodo 7. Please let me know what k...

Answers: 1

unknown host

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. &lt;Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

POST Rest Webservice Failling
answered 08-01-2021 04:45:01 -0500

Hi, I am using the sample stored procedureCalculateAvgRevenue . I created a rest webservice. http://localhost:9090/server/tutorial/p_getrev/views/p_getrev POST with X-HTTP-Method-Override GET below request works JSON Request { “$filter”:”taxid_list...

Answers: 1

REST API REST REST Webservice REST Web Service Data Source

Unable to establish connection: The JDBC driver was not found. Check that the driver exists in the class path of the data source.
answered 07-01-2021 13:20:20 -0500

Hi Team, I am getting the below Error while connecting the oracle database. Unable to establish connection: The JDBC driver was not found. Check that the driver exists in the class path of the data source. And le us konw what should we provide in D...

Answers: 2

odata filter on array type
answered 07-01-2021 11:42:08 -0500

Hi, I am trying to use filter for array type column like below http://localhost:9090/server/tutorial/denodo-odata4-service/denodo-odata.svc/?$filter=srvlcdin_list={ ROW('') } Its giving error message as { "error": { "code": null, "message": "A col...

Answers: 2

ODATA OData