Q&A

Properties of ODBC driver
answered 06-10-2020 08:28:10 -0400

We are developing a project where we have to connect to our Denodo server from a Python script. We basically load the ODBC driver dynamically, connect to the server and then send the query. Very standard process. Here is the snippent of code where we d...

Answers: 1

C# ODBC Python

XSLT Mapper tool
answered 06-10-2020 08:26:02 -0400

Hello, I want to use XSLT mapper for my api that is returing data. Do that require a valid contract to use XSLT mapper I cant even see a proper installation guide on the help page. One of the question was answered and it said to go on support site ...

Answers: 1

XML XSLT XSLT MApper

Select Distinct records based on a particular value in another column
answered 06-10-2020 08:23:23 -0400

I have a result of employees with "employee id" that has duplicates. I have another column called "leader level" i want to keep unique records of the employee id that has the lowest value of leader level (i.e. if the same employee id is in row 1 and 2 ...

Answers: 1

Distinct order by

How can I execute VQL in a text file on Job Sucheduler?
answered 05-10-2020 08:41:08 -0400

I want to execute DML that changes from time to time for a view. Is it possible to place the created a text file(VQL) on the Server and execute it on the scheduler?

Answers: 1

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