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.

Start and End Cell Behavior in DenExp 7.0
answered 14-12-2018 07:28:48 -0500

Hi Team, Denodo 7.0 Express MS Excel 2010 Format .xlsx Id Name Age City 1 ABC London 2 PQR 20 Sydney 3 LMN 30 Munich 4 XYZ 40 Paris If I chose Start Cell as B1 and End Cell as D4. I get below result: Name Age ABCPQR 20LMN 30 XYZ 40 Why is city colu...

Answers: 1

Excel

SQL Server recursive query
answered 14-12-2018 05:42:20 -0500

According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...

Answers: 1

recursive query SQL Server

CATALOG_VIEWS() giving wrong results in Localhost
answered 14-12-2018 03:42:40 -0500

Hi All, I am trying to use CATALOG_VIEWS() to get the list of modified views on a perticular day. Upon the servers, its working fine and giving me the correct results, but in localhost the same query with CATALOG_VIEWS() is giving all the existing vie...

Answers: 1

CATALOG_VIEWS() Local

Denodo4E Error - VDBConfiguration.properties Missing
answered 13-12-2018 18:10:58 -0500

Hi, I am trying to build a stored procedure and am following the tutorial for Denodo4E, but when I go to debug the VDP-ITP-Server I get an error stating: "The system cannot find the file specified Denodo Platform\conf\vdp\VDBConfiguration.properties (T...

Answers: 1

Denodo 6.0 Denodo4E

How to limit the log file retention or disk space usage for the Denodo Monitor logs?
answered 13-12-2018 07:47:28 -0500

Hello I am aware that the monitor is configured with: conf/ConfigurationParameters.properties however, normally the VDP logs are configures in a log4j config file, but for the monitor I could not find this log4j config file. So my question is: how ca...

Answers: 1

to_date(to_char) version 6
answered 13-12-2018 05:20:29 -0500

Hi My oracle function is to_date(to_char(b.X,'DD-MON-YY hh24:mi:ss'),'DD-MON-YY HH24:mi:ss') How i am suppose to implement this in denodo? Any help

Answers: 1

Custome Store procedure
answered 13-12-2018 04:52:21 -0500

Hi Team I am trying to create a custome store procedure in denodo. So could you please provide some sample store procedure written in java. And one more thing can we use parametrize store procedure in denodo using java??.

Answers: 1

Suggested Update to the Script Template
answered 13-12-2018 02:02:48 -0500

Hi, This works really well. One suggestion is to change the line: SET DENODO_HOME=”DENODO INSTALLATION PATH” in the script template to: SET DENODO_HOME=<DENODO_HOME> or SET DENODO_HOME=<DENODO_INSTALL_PATH> As the first time I edited this line ...

Answers: 1
Related to: Denodo Monitor as a Windows service

Missing library for sqlldr
answered 12-12-2018 02:13:12 -0500

Hi, I am trying to use sqlldr to load the cache on an oracle database. sqlldr runs fine on the denodo system account. I just had to add export LD_LIBRARY_PATH=/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH to the profile. Nevertheless, it does...

Answers: 1

Bulk Data Load

server explorer issue
answered 11-12-2018 07:45:03 -0500

Hi After i logged into VDP i am unble to see server Explorer window , is there anyware which i can find the details .

Answers: 3