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.

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

Case Statement
answered 18-12-2018 06:39:52 -0500

case when id=1 then y else z end what if i have 3 attribute like "Null" I have a 3 values a b c while i am writing CASE statement i can do up to 2 values what if i have 3 option . case when id=1 then a else b end How i am suppose to get 3rd value .

Answers: 2

What is VCS Environment used for with respect to Git/GitHub
answered 18-12-2018 06:16:35 -0500

We use GitHub for versions control. However, I don't see the relevance or use case of Denodo Environment. The training, KB and manuals were very high level and useless for getting an answer. So for now, I think it's useless with regards to GitHub...

Answers: 3

Replace in denodo
answered 18-12-2018 02:20:36 -0500

HI My source something like 'x1'6/mL'  and in DB i should have 'x1''6/mL' , How we are suppose to do this on the Denodo.

Answers: 1

Store procedure
answered 18-12-2018 00:27:42 -0500

Hi Denodo Team, I am trying to create a store procedure in denodo. but i have no idea how to do. Could you please help me out. is it possible to write a parameterize SP in denodo without using JAVA.

Answers: 3