Q&A

How to remove leading zero's in date time stamp
answered 29-09-2020 05:57:13 -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: 1

Date time function

Convert rows into columns after flattening in denodo
answered 29-09-2020 02:05:34 -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: 1

db2 LUW drivers
answered 29-09-2020 00:11:33 -0400

I need to configure a jdbc connecton to a db2 instance. I have been told that the version of db2 is V 10.5 Fix pack 7 . this look painful as teh denodo site sends me to https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.swg.im.dbclien...

Answers: 3

db2 drivers

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

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

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

Function to select from an array
answered 23-09-2020 14:29:20 -0400

Hello, I have an array with the following structure: {"description":null,"sourcesystem":"Midas"} and then another array with this structure: {"productmaintype":{"productmaintype":"Currency Investment Account"},"productsubtype":{"productsubtype":"Resid...

Answers: 1