Q&A

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

<Reference> https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F <Denodo VDP Version> 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. <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

unable to perform crud operations in denodo 7.0
answered 07-01-2021 10:33:26 -0500

Query1: i tried creating insert update statments using create from query tab but not able to can anyone help me how to create insert update delete statements in denodo Query 2: I have macros in teradata and trying to migrate them to denodo, can someo...

Answers: 2

Convert CSV into rows without the use of SPLIT function
answered 07-01-2021 02:08:55 -0500

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.

Answers: 1

Delegate FLATTEN Split

Plans for "insert into select"?
answered 06-01-2021 15:06:08 -0500

Just curious if you have plans to evaluate and implement the "insert into select" syntax that is standard on all RDBMS platforms these days? Often the insert into values() syntax is not enough since you need to select from another table. The above sy...

Answers: 5

vdp select

Getting error while creating diagnostic report in Diagnostic & Monitoring Tool
answered 06-01-2021 04:40:52 -0500

Hi Team, When you create a diagnostic report in Diagnostic & Monitoring webtool, a Diagnostic Database is created in VDP admin tool by default. I have to delete this Diagnostic database due to some reason. Now again I want to create diagnostic repo...

Answers: 2

denodo monitoring and diagnostic tool Denodo Diagnostic & Monitoring Tool