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.

Date format to avoid internationalization configuration (i18n)
answered 01-11-2018 05:30:40 -0400

Hi, I have date feild coming from source as 2018-06-26 18:30:00 and to avoid i18n i have converted to text using formatdate('yyyy-MM-dd HH:mm:ss', datecolumn)).. Now the end consumer querying this using Cognos wanted to strip timestamp using to_date('...

Answers: 3

Denodo JDBC driver backwards compatible?
answered 31-10-2018 16:10:54 -0400

Is the Denodo JDBC driver provided with the Denodo 7 installation backwards compatible to access a Denodo 6 VDB with it? I found this in the documentation: From Denodo Platform 6.0 and newer versions when a new Denodo Platform update is installed, eve...

Answers: 1


Denodo Update/Insert UI
answered 31-10-2018 08:47:34 -0400

Hi, I am trying to create an interface in Denodo which can insert/update/delete rows from a database. we need to have a web UI to do these tasks.The default UI that exposes for APIs is fine.But can this UI be used for update/insert? Please suggest

Answers: 1

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