Home / Q&A / All Questions

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.

Stor proc
answered 26-12-2018 07:03:00 -0500

Hi I have written the below code to create a customized store proc in denodo. package com.acme.extension; import java.io.FileWriter; import java.sql.Date; import java.sql.ResultSet; import java.sql.Types; import com.denodo.vdb.engine.storedprocedur...

Answers: 1

What is the purpose of interface views?
answered 24-12-2018 06:55:01 -0500

When I review the documentation on interface views it is very procedural and does very little to explain the purpose of interface views. What I can assume from the documentation is that an interface view is meant to be used when denodo is a data source...

Answers: 1

Denedo on Azure
answered 24-12-2018 05:00:48 -0500

I get the following error while installing denedo on azure. Is it that denedo is not available on Azure in India Region? "code": "MarketplacePurchaseEligibilityFailed", "message": "Marketplace purchase eligibilty check returned errors. See inner error...

Answers: 1

#Azure

Installing Denodo4E
answered 24-12-2018 03:31:52 -0500

Hi Team While installing Denodo4e in eclips(version 1.8.0_191), I am getting below error/warnig. Could you please explain why is this error coming. " Warning: you are installing software that contains unsigned contents. The authenticity or validity o...

Answers: 1

Prompted for password for the Denopd service username
answered 24-12-2018 02:05:15 -0500

Our cloud team have just created a Denodo Azure 6.0 instance (purchased from the Azure Marketplace) and presented it to our team for configuration. We can connect via SSH to the new VM with the credentials created at the time of purchase. When we att...

Answers: 1

azure new installation

Steps to enable mainframe COBOL application access to Denodo Views?
answered 21-12-2018 17:24:20 -0500

We are trying to enable mainframe z-os COBOL applications access to Denodo views (v7.0.20181011) . Could you please provide at least a high level overview of steps necessary to enable this? Does Denodo support DRDA? Thanks for any information you can p...

Answers: 6

GET_CATALOG_EFFECTIVE_PERMISSIONS ()
answered 21-12-2018 13:38:34 -0500

Is there another way to see the data in this procedure GET_CATALOG_EFFECTIVE_PERMISSIONS? I use select * from GET_CATALOG_EFFECTIVE_PERMISSIONS and get error 'Finished with error: View 'get_catalog_effective_permissions' not found'. This statement is r...

Answers: 3

Unable to connect to Oracle 11g User Schema as Data Source
answered 21-12-2018 07:46:14 -0500

I have downloded Denodo 7.0 and am trying to connect to the Oracle 11g express edition DB on Windows 64-bit platform. I have created new schemas in Oracle DB as per the default scripts "DEN70EDUD1001LAB01-Oracle" & "DEN70EDUD1004LAB04-Oracle" provi...

Answers: 1

Oracle DB connection Issue Oracle 11g

Abbreviation in denodo
answered 20-12-2018 23:22:57 -0500

Hi I am getting column from my DB with TimeZone : Eastern Time Zone i want to make this as EST like i have 24 Different timezones on my table . if my time zone changes EST to EDT i want to atomatically populate EDT on my column. how i am suppose to ...

Answers: 1

Oracle Syntax is not working in the Denodo
answered 20-12-2018 17:46:26 -0500

I have below syntax for the Oracle but this one is not working in the Denodo, Any comments on that please. CASE WHEN TO_NUMBER("bv_PROVIDER_PROFILE"."TIN") IS NULL THEN CAST ( 0 AS INTEGER) ELSE CAST("bv_PROVIDER_PROFILE"."TIN" AS INTEGER) END

Answers: 1