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.

Revision Deployment
answered 26-07-2019 07:12:37 -0400

I am trying to deploy a revision by following the denodo documentation, but I don't have any load balancer and all the machines are with in the internal network. and I am not getting the load balancing variables in "Deployment Scripts" tab for the envi...

Answers: 1

SolutionManager revisions deployment

When will Denodo support analytic functions (i.e. RANK, NTILE, PARTITION BY....)?
answered 26-07-2019 06:47:42 -0400

When will Denodo support analytic functions (i.e. RANK, NTILE, PARTITION BY....)?

Answers: 14

Multiple Requests with HTTP Connection
answered 26-07-2019 05:40:39 -0400

Hello, I am working on a project to pull in data from an external JSON source. One endpoint will give me a list of ids that I can store in a base view. I would like to use those IDs (lets say there are 50) to pass into a second endpoint http url ...

Answers: 1

User & Roles creation
answered 26-07-2019 05:06:11 -0400

The information in the link below https://community.denodo.com/docs/html/browse/7.0/solution_manager/administration/authentication_and_authorization/authorization/authorization Do we need to create these users in all the VDP server in the cluster? or ...

Answers: 1

solution manager Role and User Management

Format_date is not working for me to display 'yyyymm' patern
answered 26-07-2019 02:08:46 -0400

Hi Team, As per the customer requirement, I have to display only 'yyyymm' of a date field and I gave the expression as below in denodo: formatdate('yyyymm', dim_day.day_dt) But it gaves only the year, month displays as 00. For eg: 201800, 201900. I...

Answers: 2

Date Conversion Function TO_DATE function

ODBC connection for Denodo 5.5 on Windows Server 2016
answered 25-07-2019 09:11:26 -0400

Hi Team, Does Denodo 5.5 supports an ODBC connection on Windows Server 2016 ? Getting below error: ERROR: Syntax error: Exception parsing query near 'show' What could be the problem? Driver issue ? Driver Used: postgresql ANSI ODBC driver 64 bit Pl...

Answers: 3

Windows Server 2016

How to implement LDAP Authentication to my web services like REST and SOAP
answered 25-07-2019 08:39:35 -0400

I have few data services for which I need to implement LDAP authentication, in the advanced settings of those web servicees I dont see HTTP Basic with LDAP authentication Option. Apart from that I have created a data source for the LDAP Server but not ...

Answers: 1

LDAP

Combining rows
answered 25-07-2019 07:54:45 -0400

We have pulled in data from JIRA using the api as a datasource. After flattening out all of the data, I am seeing duplicate rows with the same ID field, but one column has different values. I'm attempting to combine those values so I only see one entry...

Answers: 1

concatenate

Is there a way to zoom in and out when working in VDP client?
answered 25-07-2019 07:02:10 -0400

We are utilizing 7.0.20181011. When working within VDP, is there any way to zoom in/out to improve readability?

Answers: 1

VDP

Filtering by max date
answered 25-07-2019 06:20:21 -0400

I am trying to filter a transformation by only pulling in the rows that have the latest effective date. I've tried using the max function, but have been unable to get the results I'm looking for. Running on version 6.0.

Answers: 1

Function