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 November 2018.

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.

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

Unable to Start VDP Admin Tool
answered 11-12-2018 07:19:04 -0500

After installing Express and opening the Control Center, the VDP Server wouldn't start. After taking quotes out of the JAVA HOME path statement I was able to get it started but was unable to start the VDP Admin Tool. So I went to the VDP.LOG to see wha...

Answers: 2

VDP VDP client

ODBC compatibility matrix
answered 11-12-2018 07:08:47 -0500

Hallo, I have been asked to provide a compatibility matrix for ODBC when used by QlikSense, PowerBI, SS Analysis Services, SAS VA. I haven't found any such information, not even in non-matrix form. Would it be possible to know if some of these product...

Answers: 1

Unable to establish connection: connection error: Permission denied: connect
answered 11-12-2018 01:13:46 -0500

Product version : Denodo Platform 7.0 using windows 10 64 bit. While tryint o connect to a new JDBC connection getting the following error "Unable to establish connection: connection error: Permission denied: connect"

Answers: 2

After Installing Denodo Express 6.0 I am unable to connect to VDP via the Administration Tool
answered 10-12-2018 16:29:17 -0500

Help!!! Note: I've already looked at several other posts relating to this and I still can't connect after trying everything suggested. I am running as administrator ("Run As Administrator"). I've added TCP ports (9000:9999) access to the firewa...

Answers: 7

VDP administration connection error

Connecting to Denodo through Python
answered 10-12-2018 11:00:11 -0500

I am trying to connect to the Denodo views and struggling creating a connection below is my code.. --- is commented code , reated DSN also but still doesnt connect import psycopg2 conn = psycopg2.connect(host="denodo-dev.com:2000",database="ldw", ...

Answers: 1

Connecting to an external web service