Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

How to set different ports for Rest Web service
answered 31-10-2018 08:24:21 -0400

Hi Team, I have a derived view where in I want to publish this as a Rest service and I am aware how to do it. But here my ask is how to set 2 different port numbers one for Internal and one for external people who access this Rest Service within Denod...

Answers: 1

Pagination API
answered 30-10-2018 05:51:29 -0400

Hi Team, I am using Denodo 6.0 and i have to connect to a REST API with pagination. Can you please explain how to loop through pages and retrieve all pages information in Denodo? Thanks, Sowmya

Answers: 1

What is the right URL when configuring an SFTP (or FTPS) data route?
answered 29-10-2018 21:25:25 -0400

Hi! I'm trying to access a delimited file on a different server using SFTP, but I can't seem to get the URL right. What is the right URL when accessing files on other servers via: SFTP FTPS SSH Thank you~!

Answers: 8

data sources sftp

Denodo Varchar issue in Cache DB
answered 29-10-2018 12:11:14 -0400

Hi Team, We had a one issues, we talked to Denodo support team to fix the issues.Finally its fixed. but we need some clarification here. We have view "emp" in oracle DB, one of the column(empname) size defind as Varchar(14), we brought that view into d...

Answers: 1

Median Calculation
answered 29-10-2018 08:11:36 -0400

Hello, I have a data set with a duration field and I want to calcualte the median duration for this data set, however - this function does not exists in Denodo. Is there another way I can do it? Thanks, Itay.

Answers: 1

Need correct format of URL for SFTP
answered 29-10-2018 04:14:44 -0400

If sftp location is sftp.acme.com, what is the correct URL? sftp://sftp.acme.com? I always get error message: Unable to establish connection:sftp://sftp.acme.com What is the correct URL? If URL above is correct, what other considerations to enable c...

Answers: 1

sftp data source

seeing different UI for pagination in Denodo express 7
answered 26-10-2018 16:42:38 -0400

Hi, I have downloaded Donedo express edition 7.0 and i have found that there is a discrepency in UI for pagination section under Http paths, i do not see three options like token continuation, pagin indices etc on this version and also all the paramet...

Answers: 1

parameterizing schema name
answered 26-10-2018 16:40:08 -0400

Hi, I have a situation where base view is created from the query and the schema name used in the query is different in Dev and QA environment. Can i parametrize the schema name or create the variable that allows the migration between environment easie...

Answers: 1

How to connect the tableau 10.3 to denodo
answered 25-10-2018 18:03:12 -0400

Hi Team, I am using 10.3 tableau and denodo platform 7, for this how can we connect to tableau to denodo can any one please explain the procedure for estblishing connection between this two Thanks,

Answers: 1

DENODO Tableau

Unable to access the SQL SERVER
answered 25-10-2018 17:45:20 -0400

below one is the DATABASE URL jdbc:jtds:sqlserver://GANESH-PC:1433;databasename=Test unable to connect the sql server

Answers: 1