Q&A

Exception parsing near query 'CREATE'
answered 05-10-2020 08:34:32 -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: 3

Syntax error

Different Denodo versions
answered 05-10-2020 08:31:44 -0400

Hi, Is it possible to have different versions of Denodo (e.g. version 7 & version 8) running on the same machine? They don't have to be running simultaneously. With kind regards, Phil

Answers: 2

Denodo Installation

Want API as paginated
answered 02-10-2020 08:30:49 -0400

Hello, Below is the Scenario, Please suggest I have extrenal API that gives me limit of 1000 records at a time. The data that I receive contains link for next page(a half link ex:) Full link is like : https:/exmaple.com/sgvu/myapi/query?Select n...

Answers: 1

Pagination #API #Rest_API

Error while building the denodo image with the a dockerfile provided in the website
answered 01-10-2020 08:31:24 -0400

I used the first Dockerfile provided at https://community.denodo.com/kb/view/document/How%20to%20create%20your%20own%20Docker%20images%20for%20Denodo%20Platform%20Containers?category=Operation to build the image, but I am get the following error : Ste...

Answers: 1

Perform a join and only keep the first row when the join condition is met
answered 01-10-2020 08:13:03 -0400

Thanks, for the fast response :) My original question: Perform a join and only keep the first row when the join condition is met Answer: I would add the clause LIMIT in the query which performs join to obtain only one row of the result set. For insta...

Answers: 1

Able to Connect to a SharePoint list but all Multi-select fields are missing
answered 01-10-2020 08:05:36 -0400

I am able to connect with OAuth2 to our Sharepoint site and pull down various lists, without issues. However, I have noticed that any fields that are "multi-select" are missing from the schema. Is there a setting I need to change to get this to work?

Answers: 2
Related to: Microsoft SharePoint as data source

Wrapper Missing SharePoint

How to remove leading zero's in date time stamp - 08/03/2020 04:05:15 PM
answered 30-09-2020 04:32:47 -0400

Hi Team\ I have format date 08/03/2020 04:05:15 PM want to remove the leading zero only on the date given above . How to do that.. Please help, its very urgent to implement on the job design. 08/03/2020 04:05:15 PM o/p 8/3/2020 04:05:15 PM

Answers: 1

Date time stamp

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