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 September 2019.

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.

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

How do I concatenate two columns and use them in the join?
answered 20-12-2018 17:05:10 -0500

Hi Team, I would like to know, how would I perform the below join condiiton in VDP, how do I concatenate two columns to use them in the join operation. table_a a LEFT JOIN table_b b on a.column_a = concat(b.column_b1,b.column_b2) Regards, Shafeeq

Answers: 1

join

Denodo in Automated Release cycle
answered 20-12-2018 09:59:03 -0500

We are evaluating Denodo for one of our prestigous client. There are few queries which we have, if you can let me know the response. Wrt Testing, we want to compare Denodo Testing Tool vs SoapUI / Postman. Can you let us know the pros and cons of ...

Answers: 1

Denodo Denodo Testing Tool Denodo Testing Tool REST Webservice

Is it possible to create denodo as custom database in SAP HANA SLT?
answered 20-12-2018 09:50:50 -0500

Though I am researching from HANA end, thought to share my question here to get answer quickly.

Answers: 1

Denodo 6.0

How to convert Date into Integer format in denodo?
answered 20-12-2018 06:40:31 -0500

Hi, I need to convert current date into integer format. Ex: If you consider current date as "Wed Dec 19 00:00:00 EST 2018". Then I wanted to result as "19122018". Anyone help me out with the query? Thanks

Answers: 3