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 executing CREATE_REMOTE_TABLE stored procedure
answered 28-11-2018 16:55:23 -0500

I am getting the error below while executing the CALL CREATE_REMOTE_TABLE () stored procedure. Finished with error: error invoking stored procedure: Stored procedure 'create_remote_table' not found Any ideas or anyone encounter this earlier?

Answers: 1

Denodo stored procedure remote table Stored Procedure

What happens to views created for "Data Movement"
answered 28-11-2018 11:25:34 -0500

Hallo! May I safely assume that the copies of a table created in the Data Movement process are deleted when the query completes? Thank you

Answers: 1

Denodo cache
answered 28-11-2018 11:23:01 -0500

Hello, is Denodo capable of dynamicly manage the cache ? For instance, change cache methode based on server use. thanks.

Answers: 1

cache denodo dynamically

Cluster Hive DB
answered 28-11-2018 05:15:02 -0500

Hi if my Hive DB in cluster enviroment, how i am suppose to connect HIVE DB ? thorugh JDBC ?

Answers: 1

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