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.

ODBC error "view pg_database not found"
answered 26-07-2019 13:27:05 -0400

Hello, I've been successful in using both the 32 and 64 bit Denodo ODBC drivers to connect to my VDP 7.0 Express installation using a wide range of clients (PowerBI, Winsql, RStudio, Python, ...) but when I attempt to import the Denodo views in a data...

Answers: 1
Related to: DSN configuration for ODBC connections to VDP

Hi, I would like to know whether we can pass a local directory path from the data source to the business rule for the Delimited file
answered 26-07-2019 13:21:58 -0400

The scenario is, i have a production environment, and have delimited files in two folders(one is production and the other one is development folder. We are not suppose to touch the production folder. In case if we need to do a unit test in Production e...

Answers: 1

Dynamic Datasources path
answered 26-07-2019 08:38:07 -0400

How to pass adatasource path as parameter for a view.

Answers: 1

Dynamic Datasources

Dynamic Datasources
answered 26-07-2019 08:35:14 -0400

how to run a view by passing datasource path as parameter

Answers: 1

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