Q&A

Denodo Scheduler: Is it possible to query the denodo scheduler and get a list of jobs, schedules, etc?
answered 30-09-2020 01:07:58 -0400

Is it possible to query the denodo scheduler data? IE: Can we get a list of projects, jobs, and their triggers?

Answers: 1

Denodo 7.0 Scheduler Query Scheduler

Iterate Api
answered 29-09-2020 21:09:37 -0400

Hello, I have 12 number of pages with my API with limit of 1000 and offset of 1000. Now If I obtain a single page of data it consists of 1000 rows of data and I cannot increase the limit to even 2000 becuase of source that provides only 1k data at a ...

Answers: 1

Pagination #API #Rest_API

Flatten view
answered 29-09-2020 16:27:53 -0400

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...

Answers: 1

JSON Data Source FLATTEN

Pagination related question
answered 29-09-2020 15:02:12 -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: 1

Perform a join and only keep the first row
answered 29-09-2020 08:09:21 -0400

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

Answers: 1

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