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.

How to setup a Distributed Cache in Denodo?
answered 29-03-2017 17:15:04 -0400

Cache setup in a distributed environment? Does it allow colocated distributed cache join Operations ? Does it allow non-colocated distributed cache Join Operations ? Can we combine implementation Views/Distributed Views spread across multiple Data Cent...

Answers: 1

Connection with an OutSystems database
answered 29-03-2017 08:56:41 -0400

Hi team! We've succesfully made a connection between a OutSystems database and Denodo. OutSystems creates databases and tablenames automatically and works with a metadata layer. There is a metadata table which contains the metadata and the active tabl...

Answers: 3

OutSystems Connection

Code Migration activity from one environment(DEV) to another environment(QA) using import/export.
answered 29-03-2017 06:43:40 -0400

Team, Log is generated for specific vql which we imported, but if i want to find out 10 day's back which vql was imported and what was the error? do you maintain any import history? Thanks DP

Answers: 1

#export-importerrors

custom wrapper for cobol copybook?
answered 28-03-2017 11:53:46 -0400

Do you have any documentation for writing a custom data wrapper connection to Cobol Copybook ? -- Loki

Answers: 1

Converting flat structure table to 3 level hierarchy json object
answered 28-03-2017 11:52:19 -0400

Hi Team, We have a requirement to convert denormalized table structure as a source and we want to provide 3 level hierarchy json object what would be the best approach using Denodo?

Answers: 5

changing the name of multiple views at once
answered 28-03-2017 11:45:44 -0400

I have created 20 base views. how can i change their name by prefixing them with "bv_" without editing each base view individually ? Thank You. erol aivas

Answers: 3

view name

How to query with query arguments
answered 28-03-2017 08:51:23 -0400

I am trying to follow the idea with the splunk, which consists of 2 views, in Denodo, one is actually creating the job with the sid, and the other is querying the results. I am failing with the combination of both, since a query of the form (refering t...

Answers: 1

splunk arguments

Issue with limit on the query using JDBC driver vs denodo
answered 27-03-2017 09:06:13 -0400

There is an issue with putting limits on the query through the JDBC version. using select * from <table> limit 200 does not work. It is like the JDBC doesn't parse the limit constraint to the VQL.

Answers: 1

JDBC Query limit

Choosing the fields returned in stored procedure call CATALOG_VDP_METADATA_VIEWS
answered 27-03-2017 08:51:18 -0400

Is there a way to limit the fields returned in the Stored Procedure call CALL CATALOG_VDP_METADATA_VIEWS . For example, I only need the following fields from this call: DATABASE_NAME: name of the database that the view of the field belongs to. VIEW_NA...

Answers: 1

meta data Stored Procedures

List of possible or default log categories
answered 27-03-2017 07:41:03 -0400

How do I determine the list of the possible log categories that can be passed to the logcontroller stored procedure? for example: call logcontroller('com.denodo.vdp.requests','error'); I know of: com.denodo.vdp.requests Regards, Mike

Answers: 1

logging