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.

Using Subversion with denodo
answered 04-08-2017 00:50:49 -0400

Hello, We are using subversion with denodo. I have a trunk and branch defined. Everytime I merge trunk to branch many items in the branch go into the red status ( out of sync) I need to check out individual items again to turn them green. Is there any...

Answers: 1

Date Expressions
answered 03-08-2017 09:16:02 -0400

Hi, Can anyone please provide me the expressions for Current quarter begining date, End of current quarter date and Next Quarter begining date? Thanks

Answers: 2

Incremental caching option in Denodo Express
answered 03-08-2017 07:31:34 -0400

Hi, I've been trying out the caching modes available in the express version but I can't seem to find the incremental option under full cache mode. Is this a limitation on the express version?

Answers: 1

Error opening "SELECT oid from pg_type where typname = 'geometry'"
answered 03-08-2017 05:26:36 -0400

I have made ODBC connection to Denodo from Alteryx. Connection is successful. But, when I ran the workflow to query a Denodo table/view in Alteryx, it throws below error. Start: Designer x64: Started running D:\Alteryx\New Workflow1.yxmd at 6/23/2017...

Answers: 4

ODBC Alteryx oid alteryx

Is there a parameter to identify the user currently connected to Denodo?
answered 01-08-2017 08:04:07 -0400

We have a sensitive data set which includes identifiers for Owner and Manager. For the purpose of this example, assume HR info (it's easy to understand). Manager ID~Employee ID~Some stuff.... 444~222~DataColumns for "222" 444~333~DataColumns for "333...

Answers: 2

parameter

ORA-08177: can't serialize access for this transaction
answered 01-08-2017 06:41:44 -0400

When we open a job we'll get this below error. Unexpected error. Please, try again or contact with the system administrator. But when we check the scheduler log we find below error. com.denodo.util.exceptions.InternalErrorException: ORA-08177: can't...

Answers: 1

Request for metaquery
answered 01-08-2017 04:51:58 -0400

Could you pls provide the query to pull list of Denodo Jobs, Datasources, Databases etc. Product : Denodo 6 OS : Linux

Answers: 2

Functon rank is not executable
answered 31-07-2017 08:22:27 -0400

I am using derived function in which RANK function is used. When I execute SELECT statement I am getting "Functon rank is not executable" error. Please help. I suspect that this error is related to note which is mentioned in documentation for RANK fu...

Answers: 1

windows function

ODBC connection with Entity Framework
answered 31-07-2017 05:11:27 -0400

Hi, Could you please help us with an example of ODBC connection with Entity Framework. We are totally stuck here. Your earlier response would be appreciated. Regards, Deepak Jindal

Answers: 1
Related to: DSN configuration for ODBC connections to VDP

ODBC connection with Entity Framework

Access Live SOAP WSDL Web Service through Excel
answered 28-07-2017 09:51:02 -0400

Hi, I want to access data from a SOAP Web Service (WSDL) through Excel. I want the process to be standalone/independent from Denodo. By this I mean, even when Denodo Platform is not running behind the scenes, once the excel is loaded with the data so...

Answers: 2

Excel automate SOAP Web Service WSDL