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.

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

Missing description on base view
answered 19-12-2018 15:53:41 -0500

Hi, I have created a base view on top of MySQL. I initially did not have any descriptions on the fields from the source table, but I added them along with some redefinition of types. I am now trying to do a 'Source Refresh'. It works fine with the typ...

Answers: 1

Column Count
answered 19-12-2018 14:33:36 -0500

It would be great if the fields listed on the summary tab were numbered, as an easy way to check column count. Is there a way to quickly see column count in Denodo? Something similar to SQL Developer?

Answers: 1

Power Query doing a different join than set in Denodo
answered 19-12-2018 09:11:32 -0500

Hi - I have a view containing 2 tables being right-joined in Denodo but in Excel, it is automatically doing an inner-join. Besides importing the data, is there any other way around this? I am currently connected to Excel through an ODBC. *edit - I w...

Answers: 2

ODBC Power Query

How long to implement?
answered 19-12-2018 08:01:15 -0500

How long should we plan to invest in implementing Denodo 7.0 on a cloud environment? What are some of the key steps you mapped out to make sure the right configuration decisions were made?

Answers: 1

Case sensitive
answered 19-12-2018 04:28:16 -0500

Hi I have a table with 100 columns on output tab which is in Upper case , i want to change Upper case to Lower Case? how we are suppose to do this on the denodo ?

Answers: 1

Cach data using Java
answered 18-12-2018 07:48:12 -0500

--typo on header can not edit :( i want to cache data using java .i have following question 1.Denodo have any API? 2.Please share sample code? i have modifed the denodo jdbc client sample and tried it is not working. please help me on this

Answers: 2

java Cache