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.

Can we browse the relationships between tables using Power BI by Direct querying Denodo
answered 15-10-2018 04:54:06 -0400

Let's we have 1 fact and 10 Dimensions in presentation layer of Denodo and now I am trying to query those 11 tables using Power BI. My Question is Can we create relationships between those tables in Denodo itslef instead of conneting to all those view...

Answers: 1


ODBC connection (Denodo Express)
answered 12-10-2018 04:08:11 -0400

I am unable to connect using ODBC driver to the Oracle database. it says, TNS could not resolve the connect identifier. I am using direct connection type using the connection TNSNames.ora that works fine with Toad and SQL navigator. Can you please he...

Answers: 1

ORA-12154: TNS:could not resolve the connect identifier specified ODBC Oracle EBS

multiple files Data Source with different columns
answered 11-10-2018 02:50:24 -0400

Dear Community, I have a case where multiple files represent a data source. On each file, the columns that I'm interested for my base view are present, but the files do not have the same column order. Because of this and selecting to ignore errors, w...

Answers: 1

Delimited file data source Delimited Files

Merging CSV Files With Delta Files Dumped Into A SFTP Server Daily.
answered 10-10-2018 11:57:16 -0400

Hey, I am using VDP v7.0 with the latest upated tools and server. I have a use case where we have an SFTP server acting as a data source for us, which has CSVs dumped into it by another system which creates reports for us. For our initial load, we wil...

Answers: 1

Delimited file data source CSV update

Denodo Express On Local Laptop - Timeout while connecting thru VDP
answered 10-10-2018 00:22:33 -0400

Hi Team, I am quite now to Denodo world, I installed Denodo Express (on my laptop) and used it for a week but strangely since last 1-2 days I am getting an error while connecting to Denodo via VDP (below erros). It was working perfectly fine but sinc...

Answers: 2

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


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

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