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.

passing arrays to VDP function
answered 09-10-2018 11:35:46 -0400

Hi, I have wrote a custome function (VDP function through annotation methodology ) and I would like to pass an array of double values to the function. But when I import the extension to administration tool and try to use it in the query it says, Fini...

Answers: 3

VDP DENODO Custom Functions

How to get files referenced in https://community.denodo.com/kb/view/document/How%20to%20access%20VDP%20from%20SAP%20BusinessObjects?category=Northbound+Connections
answered 09-10-2018 11:26:31 -0400

So we are attempting to create a JDBC connection in SAP's BOBJ to Denodo and are following the instructions in https://community.denodo.com/kb/view/document/How%20to%20access%20VDP%20from%20SAP%20BusinessObjects?category=Northbound+Connections We noti...

Answers: 3

JDBC

Fsoytemiz
answered 09-10-2018 00:57:35 -0400

How can I get first non null value of one specific field? first_value function doesn't work because it takes first value of the variable no matter what it is the observation. THANKS

Answers: 3

REGEXP help
answered 08-10-2018 22:48:08 -0400

split string into 2 parts based on "-" REGEXP takes three inputs (denodo) instead of 4 (oracle)? so how to write this?? 7-17 7-8 70-105 8-12 8.6-10.2 80-90 85-125 NA (null)

Answers: 1

Passing arrays to custom functions as parrameters
answered 08-10-2018 21:02:20 -0400

Hi, I was trying to acheive a function with signature as, public Double actualPremiumOrAcqExpOrNonDirExpCalcYearly(Double[] val1, Integer val2, Double val3) But I am not getting any luck to acheive this. Is it possible to pass a combination of parame...

Answers: 3

VDP java code DENODO Custom Functions

Connect to Office 365 Sharepoint List
answered 08-10-2018 12:51:12 -0400

I need to connect to a List in an Office 365 Sharepoint server. I was wondering if someone in the community have done it and can share the experience. One of the things we are trying to do is to connect to it with the existing windows accounts. I tried...

Answers: 1

Security Sharepoint oauth

Connecting MS ACCESS
answered 08-10-2018 12:35:46 -0400

Dear reader, I am trying to connect to a MS ACCESS DB. I followed the instructions in this post: https://community.denodo.com/answers/question/details?questionId=9060g0000000A0OAAU&title=Ms-Access+database+connection I am getting the following err...

Answers: 5

ODBC MS Access

Error in connecting to db2 database
answered 08-10-2018 04:34:35 -0400

Hi, I cant establish a connection to db2 database. I'm trying to place db2 driver at <DENODO_HOME>/lib-external/jdbc-drivers/ I'm not able to find the db2 driver file. Can someone help me out please?

Answers: 1

Execution erron on a join view between two tables from two different databases
answered 05-10-2018 03:40:42 -0400

I try to make a join between two tables on Denodo Express. I have two databases MS SQL , I can create the join view but when I try to execute the view I have the following error message : Finished with error: Error executing query. Total time 1.429 sec...

Answers: 1

Can I install a Denodo Express and a Denodo Standard on a same machine
answered 05-10-2018 02:37:34 -0400

Hi, I would like to know if it is possible to install on a same machine Denodo Express and Denodo Standard (licensed) editions? I guess that if only one edition is running this is not an issue, can someone confirm? Thanks and regards, Sérgio

Answers: 1

Denodo Denodo Express install License