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 November 2018.

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.

Error while creating Diagnostic
answered 12-10-2017 05:44:31 -0400

I've gone through the section 7.1 CREATING DIAGNOSTICS of 'Virtual Dataport and Monitoring Tools' but i am getting error as "unexpected error creating diagnostic 'Diag1' " in VDP. I have used correct directory and also all the mentioned file has been c...

Answers: 3

denodo 6.0 performance denodo monitoring and diagnostic tool

Web Service Error Logging - Too verbose
answered 12-10-2017 03:22:45 -0400

Hello, When calling a REST web service that earlier calls a REST web service data source - we notice that too much information is logged to the screen when an error is produced - the full URL of the data source and all parameters is logged to the scre...

Answers: 1

Is it possible to create volatile table(temp table) in teradata via Denodo?
answered 12-10-2017 02:59:25 -0400

I was trying to create a baseview in denodo by using the below query. i am getting an exception com.denodo.util.exceptions.InternalErrorException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.35] [Error 1077] [SQLState HY000] executeQuery() cannot be us...

Answers: 2

teradata DENODO

NameSpaces for SOAP Services
answered 11-10-2017 09:17:21 -0400

I have developed a SOAP servcie using a derived view from Database. When I invoke service, I see XML generated with default Denodo Namespaces. Can you please let me know, how I can chanage the Namespace. I see the option available for 'REST' but not fo...

Answers: 1

soa SOAP Web Service

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 11-10-2017 09:09:14 -0400

Is it possible to create an excel data source based on a directory of files versus an individual file? If so, how would you configure this?

Answers: 1

Excel Data Source Mulitple Files

Putting a NULL value as a constant
answered 11-10-2017 07:43:29 -0400

I need to create a field (called UPDATE_IND) in a derived view (V1) and the value of that field is NULL. Meaning that the derived view is going to be used in a UNION query with another derived view (V2) that has the field (UPDATE_IND) pre-filled from t...

Answers: 1

null constant

Base view on REST API - How to query and Pass parameter
answered 11-10-2017 07:17:57 -0400

Hi Team, As per you suggestion in my last question, I was able to connect to REST API -JSON sucessfully. I also, created base view. My REST API does the custom decryption for which it accepts encrypted string as input in body. I am looking for a hel...

Answers: 3

REST API

GET_VIEWS() function
answered 10-10-2017 08:57:46 -0400

I am using DENODO VDP version 6.0 20170515. When I create a view based on the following query: SELECT * FROM GET_VIEWS() I am getting an error: com.denodo.vdb.vdbinterface.common.clientResult.VQLException: Listener refused the connection with the foll...

Answers: 2

GET_VIEWS

unnamed private wrapper in Denodo Query execution plan
answered 10-10-2017 06:05:34 -0400

Hi Team, Thanks for your support. I have a dervied view which was comming like this. "A" join to "B" and "B" joins to "C" and "A" joins "D" when I go for excution plan I am seeing “no name” as like below excution plans Name<unnamed private wrapper&...

Answers: 1

Denodo Compatibility - Not fully compatible with PostgreSQL
answered 09-10-2017 09:36:33 -0400

The institution that I work for has adopted Denodo, and both the team responsible and your documentation have listed that Denodo is based on, and compatible with, the PostgreSQL driver. My department develops on the Microsoft stack, and as such we ha...

Answers: 1