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 September 2019.

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.

Weird dependency name in COLUMN_DEPENDENCIES() stored procedure
answered 01-11-2018 18:14:44 -0400

Hi all, I have a problem when executing COLUMN DEPENDENCIES() procedure. I had a derived view with just one column coming from a web service base view and I have modified the model and the output to add another derived view, and now when calling the p...

Answers: 1

Stored Procedures dependency_name

Push data to API through Denodo
answered 01-11-2018 16:18:02 -0400

Hi Team, I have two questions. Is there any other way of converting relational data (output of a denodo view) into JSON other than publishing it as web service? I have to do following operations on a REST API (POST,PUT AND DELETE). Data for th...

Answers: 1

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