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.

Salesforce Wrapper version 20180903
answered 27-11-2018 17:10:17 -0500

Hi Team, We are currently using Denodo 6.0 and we were using salesforce custom wrapper version 20160506 and it seems we do not have show archived records option in this version. CAn you please let us know location for jar file

Answers: 1

salesforce wrapper

Strange syntax error when attempting to add a column to a derived view
answered 27-11-2018 15:14:03 -0500

I have an existing derived view that I"d like to add a column to but I'm getting an unexpected error. The sourve view has 3 columns: source_id (int datatype) timestamp (int datatype) value (int datatype) The timestamp field is an Epoch timestamp that...

Answers: 1

VQL addsecond

How to connected to a SQL server authenticated with SSPI
answered 27-11-2018 06:38:00 -0500

Hi, I need to connect to MS Sql Server 2014. Using username and password is working fine for my local database. But I need to connect it to a database which is SSPI authenticated. Denodo VDP is giving me option to create connection using string and so...

Answers: 1

MSSQL Native SSPI library not loaded

Diagnostics information retrieval via REST API
answered 27-11-2018 04:19:01 -0500

Is it possible to create a REST API to extract the diagnostic inforation that Denodo stores. For example, is there a REST API available to capture the VQL that a user submits. In addition, can that information be POSTED to a REST API when it gets cap...

Answers: 1

Denodo View Usage
answered 23-11-2018 07:55:24 -0500

I need some information regarding how to track the usage of a denodo view containing multiple tables.

Answers: 3

BLOB Field - [BINARY DATA] - Help Displaying field
answered 23-11-2018 04:00:38 -0500

Hello, I have a view I created that is pulling its data from tables in a postgreSQL. One of the fields has the output type of "BLOB" and in the field...instead of the values, "[BINARY DATA]" is shown. When I would come across this issue in the past in ...

Answers: 5

BLOB BINARY

number of rows for all views
answered 22-11-2018 06:50:19 -0500

Hi Team, Denodo 5.5 Is this possible to achieve ? For a given view get number of rows for it and all it component views. This means as- Final View - FV1 - 1000 rows Derived View - DV1 - 5000 rows Derived View - DV2 - 7000 rows Base View - BV1 - 800...

Answers: 3

rows

TRIM function on base View Column
answered 22-11-2018 04:47:34 -0500

Would it be possible to do have Trim function on column in a base view. I know we can do it at datasource level by checking " Ignore all trailing spaces". But here I want to TRIM single column on a base view.

Answers: 1

Denodo version 7.0 Solution Manager - Cluster
answered 21-11-2018 15:09:32 -0500

Hi, In our solution manager we have created a prod cluster(have 4 nodes). we not sure how this works (the manual on denodo site doesn't help much) and please clarify this for us How do we know or see that the system is successfully in a cluster? ...

Answers: 1

Rename an existing Data Source
answered 21-11-2018 06:51:27 -0500

I have Version 6.0 Update 20180628 installed at my company (both Client and Server) I would like to rename an existing Data Source. Can I do this on my version (6.0.20180628) ? If so, how do I do this?

Answers: 1

Data Source