Latest Activity

Pagination related question

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...

Perform a join and only keep the first row

Perform a join and only keep the first row when the join condition it met

How to remove leading zero's in date time stamp

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

Convert rows into columns after flattening in denodo

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...

db2 LUW drivers

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...

RegexExp to extract value between parentheses

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, '/(([^)]+)...

Create view from json file

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 ...

OData 4 Custom Wrapper

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, ...

VQL for updating the Base View

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?

Can we build/deletion DV objects in VDP through access the RestFul API?

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