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.

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

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

MPP and authorization
answered 23-01-2019 08:57:58 -0500

Hallo Denodo Team, First of all, thank you for the answeres to my many questions. This question may be vague, because I didn't really understand the context. Is there any possible issue that you are aware of with authorization/security when entrustin...

Answers: 1

authorization security MPP