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

I asked a question earlier about creating physical tables in denodo and was told that materialized tables is the answer ! I want to know how you would implement the code below as a materialized table in denodo as currently it isn't working !
answered 12-05-2017 07:33:28 -0400

CREATE TABLE TESTTABLE1 ("C0" VARCHAR(4), "C1" NUMERIC(3, 0), "C2" NUMERIC(3, 0), "C3" NUMERIC(3, 0), "C4" NUMERIC(12, 3), "C5" BOOLEAN, "C6" BLOB, "C7" TIMESTAMP) select * from TESTTABLE1 [Error] Script lines: 8-8 -------------------------- Error...

Answers: 1

How can I create a physical Table on Denodo ? Is it even possible ?
answered 11-05-2017 14:55:21 -0400

denodo version 6.0. I need to do it using your vql syntax and not your user interface. If you let me know how it can be implemented so we can suport denodo users on our software.

Answers: 1

DML operation affect data present in source ?
answered 11-05-2017 08:27:28 -0400

When we can run DML operation in Base view or derived view. Does it matter what kind of source we should have while running DML?. Will DML operation affect data present in source system?

Answers: 1

Business View
answered 11-05-2017 07:49:07 -0400

Hi Team, Can Denodo by directly used by business user so that they can see data leneage , sample data and denodo models. Thanks Deepak

Answers: 1

reading data from a MS SSAS Cube
answered 11-05-2017 00:17:19 -0400

Good Afternoon. Denodo 6. Reading data from a SSAS Cube can be accomplished by: use xmla which implies IIS (mandatory ?) use a MDX query to generate the view (this one requires nothing special like IIS, etc) please let us know which statement ...

Answers: 2

Denodo and In-Memory Data Grid's
answered 10-05-2017 18:26:35 -0400

Hi, I'm interested to find out if there's anybody using Denodo with an In-Memory Data Grid (e.g. VMware Gemfire or GridGain)? How would this typically be configured from an architectural point of view? Many thanks.

Answers: 3

In-Memory Grid

Restrict query to different data sources
answered 10-05-2017 11:00:42 -0400

Hi Support Team. I am trying to restrict the query to fire different data sources for increase the performance. given below is the bussiness requirement details There is 3 different sources(ex. SOURCE1, SOURCE2 and SOURCE3), we created 3 different vi...

Answers: 1

How to pass on Values from an XML Request to its corresponding Response
answered 10-05-2017 00:26:37 -0400

Hi, When i create a new project with the below steps New --> Data Source --> XML and then I am succesfully able to configure the project and create a base view too. But when I try to deploy this as a web service, i do not face any problems while...

Answers: 1

XML request to response

In Memory - Caching
answered 09-05-2017 16:07:23 -0400

Hello Team, Which In Memory caching can Denodo work with , i am aware of Denodo can be used with Oracle Times Ten / SAP Hana but how about open source Data GRID like Apache Ignite or GridGain or Gigaspaces? Will it only support Relation Data Grid or ...

Answers: 6

Data Grid imdg In-Memory Grid

IGNORE NULLS
answered 09-05-2017 14:31:26 -0400

Denodo 6.0, latest update as of 4/10/2017: Are we able to specify how NULLs are treated in aggregate and windowing functions? I wasn't able to find any information about specifying the handling of NULLs in aggregrate and windowing functions. In parti...

Answers: 2

windowing_function Aggregate