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.

RegexExp to extract value between parentheses
answered 28-09-2020 02:55:22 -0400

I am trying to use the following formula to return the value that is between parentheses in a field. For some reason it is just returning the exact same value. I am pretty sure this REGEX is valid. regexp(bv_epic_tpi_inventory_report.hcco, '/(([^)]+)...

Answers: 1

Formula Regex

How to remove leading zero's in date time stamp
asked 26-09-2020 16:42:40 -0400

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help

Answers: 0

Date time function

Exception parsing near query 'CREATE'
answered 26-09-2020 01:58:27 -0400

While I am creating the remote table for the ms sql server 2016, I copies the vql query of my dataset and paste in the VQL Query space in remote table option, but it is showing error . I am using Denodo 7.0 express version. Kindly get me through it as ...

Answers: 2

Syntax error

Convert rows into columns after flattening in denodo
asked 25-09-2020 09:48:43 -0400

I have created a base view out of an API which returns me some array rcolumns. I then flattened these columns using flattening function in denodo. But I get multiple rows for a single account. My requirement is to convert these rows in corresponding co...

Answers: 0

Create view from json file
answered 25-09-2020 06:32:34 -0400

Hi Team, I need to create a view from multiple json files and luckly I have created view from them.Now challenge is like I have a view of coloumn which has itslef a colllection of elements means there are few columns in view which are itself an array ...

Answers: 1

OData 4 Custom Wrapper
answered 25-09-2020 04:36:30 -0400

Hello! I am tring to create a new datasource with the custom odata4 wrapper. It is showing in the Jars, but does not give me the option to refresh the input paramters. It seems like that button does not exist for me. When I try to save the datasource, ...

Answers: 1

Pagination related question
asked 25-09-2020 03:14:37 -0400

I am calling an external API to Denodo which is a JSOn. That API has set default 1000 records which I received as it is in denodo. I was unable to fectch more record in denodo with that API so I thought of Pagination in JSOn DS> configure > Pag...

Answers: 0

VQL for updating the Base View
answered 24-09-2020 06:38:12 -0400

Hi, I know we can detect the changes in the underlying data source using GET_SOURCE_CHANGES and GET_VIEWS stored procedures. However, once we detect the changes, is there any way to refresh the base view (VQL commands?) once we detect the changes?

Answers: 3

Base view

Can we build/deletion DV objects in VDP through access the RestFul API?
answered 24-09-2020 06:34:23 -0400

Hi team, Do we have ways to created DV base views, derived views, delete existing views in VDP side through access REST API?

Answers: 3

VDP build views RestFul API

Not able to login to Denodo Admin Portal with VPN enable, although I am able to login to Denodo Admin Portal without VPN enabled. (This question is in continuation of my previous same question)
answered 24-09-2020 04:35:24 -0400

I am providing my log file below(I have tried with admin as well but no benifit) 1748 [main] INFO 2020-09-21T12:38:33.639 server.start [] - Starting Denodo Platform 7.0 - Operating system: Windows 10 (amd64) - Java(TM) SE Runtime Environment (build 1.8...

Answers: 1