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 April 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

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

Unable to Import Denodo View in SSAS
answered 02-08-2017 12:26:19 -0400

Hi, I am trying to import Denodo derived view in SSAS. But while importing the Denodo view i am facing the below mentioned error. If any one knows the solution please suggest what i have to do in this case. Error Message : "ERROR [ ] ERROR: Syntax e...

Answers: 2

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

Export Denodo Scheduler jobs for the backup
answered 28-07-2017 09:27:38 -0400

Hi, I'm trying to use the export script to export all the denodo jobs and wanted to schedule the script on weekly basis. But before that when i'm trying to use the export script it throws multiple errors: In Test environment: C:\Denodo Platform\Denodo...

Answers: 1

DENODO Denodo Scheduler 6.0

Salesforce custom Wrapper, getSchemaParametrs error.
answered 28-07-2017 06:34:44 -0400

We are trying to connect Denodo to Salesforce using custom wrpper. we are using denodo-salesforce-rest-wrapper-6.0 (class name:- com.denodo.connect.salesforce.rest.wrapper.AbstractSalesforceRestWrapper). whenever we try to create a base view we get a...

Answers: 1

salesforce custom wrapper