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.

Delimited File sources with DateRange
answered 04-09-2020 03:14:18 -0400

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 8

Interpolation Variables Delimited Files

Denodo testing tool, compare views with different names
answered 03-09-2020 08:56:29 -0400

Hi, With Denodo Testing Tool, I would like to compare number of lines of my source tables in db2 vs views in Denodo, problem is that names are differents. %CONTEXT tablenames[] = a, b, c interfacenames[] = aa, bb, cc schemavdp = eicorea schemadb2 = a ...

Answers: 1

SharePoint Connectivity
answered 03-09-2020 07:12:37 -0400

I am sorry if this has been asked before. Is it possible to retrive data from Denodo and show it in SharePoint on prem and online? I can see that data goes the other way. Thank you in advance for any insight.

Answers: 1

SharePoint

Month integer to Month name
answered 03-09-2020 04:59:32 -0400

I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this

Answers: 2

date formatdate monthinteger monthtext

Can denodo close all VDP and webservice threads immediately upon completion?
answered 03-09-2020 00:26:34 -0400

Since our last release, we are seeing spikes where we can see upwards of 1200 threads in the VDP service per box. In the lower environments this can take down environments, so I wanted to see if there was a way to configure the threads pool to automati...

Answers: 1

Cannot load Roles : Error accessing the metadata while loading/storing object
answered 02-09-2020 07:08:33 -0400

Hi, I'm enabling LDAPS authentication in VDP Client for default Admin DataBase. Connecting using my domain acoount works only when the condition "Assign 'all users role " for every connected user is enabled (Under Admin database configuration) When ...

Answers: 1

Denodo Semantic Layer
answered 02-09-2020 07:08:07 -0400

I have a need to replace a Business Object Universe potentially with a Denodo Semantic layer. Is that possible? For example, if I were to create a set of derived views and enforce Associations between them, does this replace a Business Object Universe?...

Answers: 3

Median failing in denodo 7
answered 02-09-2020 06:26:18 -0400

Hello , i am executing median in denodo 7 and its failing and given error "java.lang.reflect.InvocationTargetException" can you please help me to know the reason

Answers: 1

Median

Where is the incremental cache jar located in the Denodo program files?
answered 02-09-2020 06:08:32 -0400

The instructions to setup an incremental cache reference the .jar denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar. Where is this jar located? I cannot find it anywhere in our program files for our installation of Denodo 7...

Answers: 4

Cache

Incremental_load_process
answered 02-09-2020 05:21:36 -0400

How can I active incremental_load_process in denodo scheduler for cached dvs. Do I need to have its jar file to install a stored procedure? if yes, where can I download that file (denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependenci...

Answers: 1