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.

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 delegation data aggregation

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

Incremental mode last_modified_date > '@LASTCACHEREFRESH'
answered 24-01-2019 06:39:31 -0500

What is the date format of the variable LASTCACHEREFRESH My data has a column last_updated with a data type as "text" and value like "2019-01-22 11:00" but using the condition last_updated > @LASTCACHEREFRESH and the cache does not get loaded. I ha...

Answers: 1

LASTCACHEREFRESH

Modifying the Denodo Testing Tool HTML Report
answered 24-01-2019 02:18:30 -0500

Hi Team, Is there any way to edit and customize the denodo testing tool html reporter to our needs. Please advise. Thanks

Answers: 1

DenodoTestingTool