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.

REST service is not processing 'X-HTTP-Method-Override' header
answered 07-02-2019 18:01:23 -0500

axios({ method: "POST", url: "http://localhost:9090/server/customerdb/person/views/person", headers: { "X-HTTP-Method-Override": "GET", "Content-Type": "application/json;charset=UTF-8", "Accept": "application/json" }, data: { "$filter": "firstname eq '...

Answers: 1

REST

What happens to existing database during "CREATE OR REPLACE DATABASE"?
answered 07-02-2019 17:35:03 -0500

Hi, what happens to an exisiting database X if the VQL statement "CREATE OR REPLACE DATABASE X" is executed? Has this effect on existing objects in this database? Thank you.

Answers: 1

Error in create BV from SQL query
answered 07-02-2019 04:30:48 -0500

Hi I am executing query in DB2 which working fine and getting the results , while i was executing same query from Denodo to creating base view i am getting following error Error executing sentence: com.denodo.util.exceptions.InternalErrorException...

Answers: 1

Query to Return Summary and Last Record as One Row
answered 07-02-2019 03:59:28 -0500

I'm struggling to write a query which returns a single row with summarized data and the last instance of an event. Scenario: Let's say I have a customer table and a sales transaction table. I need to write a query which returns the Total Sales by Cust...

Answers: 1

oracle-SQl developer connection
answered 07-02-2019 00:21:05 -0500

Is it possible to connect to denodo from Oracle-sql developer? If yes. how ?

Answers: 1

#Oracle

Cached view using statistics in the query execution
answered 06-02-2019 05:50:23 -0500

Hi, we are using denodo 6 with cache db as Oracle. we want to explore collecting statistics for the cached views brought in from the other data sources. Is there a way to check if we execute a query on the cached view that those statistics are being u...

Answers: 1

Does SAP HANA can conned Denodo through API's rather than JDBC souce?
answered 05-02-2019 12:17:40 -0500

Hi, Can we connect SAP HANA through SDI API's provided? If so, which source we need to use while creating Data Source. Thanks,

Answers: 1

DENODO

How Code injection is handled in Denodo?
answered 05-02-2019 05:39:21 -0500

I have created a base view using SQL Server table. There is a column called "Tag" in the SQL table. The DATA REST API is created using the same base view. This tag column in nothing but a search parameter which will be passed from the web client. How...

Answers: 1

denodo security code injection sql injection

SQL performance
answered 05-02-2019 04:17:58 -0500

Does Denodo query runs faster than oracle? I have a simple one base table ( source oracle), it runs slower than oracle!!! any clues ?

Answers: 1

#salesforce #performance #optimization

StorageInternalException
answered 04-02-2019 06:22:44 -0500

Getting these error so oftenly and then denodo server get hang and not responding "Caused by: com.denodo.vdb.catalog.storage.StorageInternalException: Error accessing the metadata while loading/storing objects at com.denodo.vdb.catalog.storage.DBDerby...

Answers: 1

derby Error