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.

Base View from query
answered 31-01-2019 05:42:13 -0500

Hi Team, Denodo 5.5 How to create a Base View from Query on stored procedure 'element_metadata()' Please tell. I also intend to use interpolation variables. Thanks.

Answers: 2

Query Stored Procedure

the issue with one data source
answered 31-01-2019 02:46:27 -0500

I have 10 differnt tables in various schemas on same datasource but these tables are isolated how i am suppose to get 10 columns from 10 tables in one output .

Answers: 1

Update large number of Base Views Column Descriptions from another base view
answered 30-01-2019 08:41:33 -0500

Version 7.0, I have 7 systems and other 100 tables that are in Base Views. I want to update column descriptions from a Data Dictionary that is in another base view and I also have the Dictionary in a Excel file. Please tell me the steps, or point me to...

Answers: 1

data dictionary Base View descrptions descriptions

support VSAM files on an ZOS in IAM format
answered 30-01-2019 01:25:53 -0500

Hi do you support VSAM files on an ZOS in IAM format? Thanks

Answers: 1

IDs from java.util.TimeZone.getAvailableIDs
answered 28-01-2019 11:50:14 -0500

Can someone post the available IDs from java.util.TimeZone.getAvailableIDs?

Answers: 1
Related to: Localization of RESTful web services

timezone

VQL support for CROSS APPLY
answered 25-01-2019 06:42:55 -0500

I've looked for mention of VQL support for the cross apply join type, didn't find any. This is a powerful function for handling many query cases where it would be very challenging or impossible to do without it. Is it supported in VQL? If not, is it on...

Answers: 1
Related to: Best Practices for Migrating SQL queries to Denodo VQL

Integrating JUnit with Denodo Testing Tool
answered 25-01-2019 06:28:45 -0500

Hi Team, While i am trying to integrate Denodo Testing Tool with JUnit, i could not find TestRunner class at path "com.denodo.connect.testing.TestRunner" It would really great if you can elaborate as to how we can integrate Denodo Testing Tool with J...

Answers: 1

DenodoTestingTool

NEST() aggregation function ERROR when (Snowflake) source configuration has "Delegate aggregate functions list" checkbox is "unchecked"
answered 24-01-2019 14:33:34 -0500

Dear Denodo Support Team, I am encountering below error while delegating the aggregate functions setting is unchecked. Error: Finished with error: Error executing query. Total time 0.117 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] ...

Answers: 1

Denodo 6.0 Delegate nesting data aggregation delegation

Connect to data source
answered 24-01-2019 13:00:05 -0500

Hi, i would like to connect denodo to my local sql server 2014. I tried to set up for new data source but it fail to connect. Please help.

Answers: 1

database Data Source

BulkLoad Issue on CacheDB
answered 24-01-2019 08:05:57 -0500

Hi Team I have environment where we are having 300millions records it took us 10hrs to load on the cache DB(3years data) with proper query, I want to schedule another job with 1 day older records to be cached which i am expeting only updated records,...

Answers: 1