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.

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

Store Proc
answered 19-12-2018 23:07:07 -0500

Hi Team, I am trying to create a custom store proc and i think below sp is useful but one thing is not clear, /* * 'values' was generated before */ the created output Value is in which datatype. because i am facing issue in conversion of data ty...

Answers: 1

Can denodo published views be used for SAP HANA SLT replication purpose? If so, how can we achieve it?
answered 19-12-2018 15:57:59 -0500

Can some one please help and answe above question?

Answers: 1

Denodo 6.0

Denodo 5.5 update 20151214 will it work with java 1.8 version?
answered 19-12-2018 15:54:58 -0500

Denodo 5.5 update 20151214 will it work with java 1.8 version? i know it work with 1.7 version of java, what need if we want to make it work with java 1.8 version

Answers: 1

java