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 April 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

Connectivity and DataAccess - How?
answered 26-09-2016 12:12:59 -0400

I installed Denodo. I want to know how to start using it. My requirement is to connect to Oracle ,MSAccess databaseand then try to query data from denodo.

Answers: 1

migration issue in denodo 6
answered 26-09-2016 09:24:38 -0400

Hi team , when i am tring to migrate code from denodo 5.5 to denodo 6.0. TO_DATE("yyyy-MM-dd",'2016-11-23') valid in denodo 5.5 but invalid in denodo 6.0 Error in select view conditions: Field not found 'yyyy-MM-dd' in view with schema how we can do...

Answers: 1

denodo 6.0

user creation with LDAP Authentication
answered 26-09-2016 07:19:02 -0400

Hi Team, I am trying to create a user with LDAP authentication in VQL script. CREATE USER john authentication 'virtual database administrator' authentication::= LDAP ( DATASOURCE <> USERNAME <> ) I am getting error as Syntax error: Excep...

Answers: 1

VDP admin denodo 5.5 Role and User Management

Naming Conflicts in query
answered 26-09-2016 05:35:35 -0400

I'm new to denodo and have created a new view based on several database tables. All is good except the tables support the same field names, for example Table1.SiteID and Table2.SiteID etc. I keep getting an error about naming conflicts i realize i chan...

Answers: 3

express installation error
answered 23-09-2016 13:32:50 -0400

installing express on RHEL 6 server as root. I get thsi error. Any ideas? [ Starting to unpack ] [ Processing package: Common (1/19) ] [ Processing package: Virtual DataPort (2/19) ] [ Processing package: Administration Tool (3/19) ] [ Processing pack...

Answers: 2

Unmarshalling error
answered 22-09-2016 05:16:51 -0400

Hi, I see unexpected error "error unmarshalling return;nested exception is java.io.EOFException" I read knowledge base common errors but seems for me that solution is not applicable. This error is resolved after restarting the vdp server but still ha...

Answers: 1
Related to: "error unmarshalling return" error

Cannot login to VDP after installation
answered 20-09-2016 08:47:20 -0400

Tied intalling v 6 of expresss however upon completion of installation I have tried logging in to VPD using default credentials below but i was unsuccessful. Wondering if ihave missed any step.. has anyone encountered this in past? Username: admin Pas...

Answers: 1

canot login to VDP

Join problem
answered 19-09-2016 11:48:25 -0400

when i run a below join in VQL it runs successfully. But when i try the same join and create a drived view it fails and gives compilation errors. the pseudo is something like this. select * from A inner join b on (((a.column is null OR a.column = '0'...

Answers: 1

#JoinIssue

How can we apply INITCAP in Denodo? Do not see any function like that.
answered 15-09-2016 08:27:53 -0400

Hi Team, i wish to know how can we apply INITCAP functionality in Denodo. Say for example, If name of person should start with capital letter. 'John', 'Maria' etc I have checked documents but not able to see any functions related to it. if not foun...

Answers: 2

denodo 6.0

Formatdate() different behaviour to fetch MMM i.e month
answered 14-09-2016 09:31:44 -0400

We wish to have month in following format i.e first letter capital. Jan Feb Mar Apr When we are running below function, it return month in capital i.e JAN, FEB, MAR etc if derived view is used based on Oracle data source. formatdate(' (MMM)', CURRENT...

Answers: 1

denodo 6.0