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.

answered 22-05-2017 06:50:03 -0400

I wanted to know how this can be done from the vql shell not your interface ?

Answers: 1

How to exclude weekends and Holidays in Denodo
answered 19-05-2017 08:43:45 -0400

Hi, I have a requirement where I need to create a difference between the start datetime and end datetime. But I need to exclude weekends and public holidays. Is there any direct function or any other alternative for it. Please let me know your inputs ...

Answers: 1

Calculating working day difference between two dates.
answered 19-05-2017 08:40:18 -0400

Hi Everyone, I have a requirement to calculate difference in date (Start vs End) while taking off the weekends and holidays. I have one view for the Start and End date details and another view for the Holiday Calendar. How do I calculate the difference...

Answers: 1

Function Custom Functions

Denodo MongoDB Base Base View Creation
answered 19-05-2017 08:05:14 -0400

HI Team, I'm trying to create base view from a mongodb datasource using Connection String(host:port/database) and Collection fields as wrapper parameter values but I'm facing the error "There was an error while creating this base view: Error while exec...

Answers: 1


answered 19-05-2017 07:57:46 -0400

For the NUMERIC data type how is scale and precision set, is there a default value or is it set by the user ? Also there max or min values for the criterias ? For the VARCHAR data type how is max_length set, is there a default value or is it set by th...

Answers: 1

How to change the Field type from Text to Date
answered 19-05-2017 06:13:56 -0400

Hi, I have a field having fieldtype as Date in base table in the format of "Wed May 17 00:00:00 IST 2017". But the timestamp it is showing is not correct. So when I tried to change it to get the correct timestamp, I tried using formatdate('MMM-dd-yyyy ...

Answers: 1

Cold-Backup activation
answered 19-05-2017 05:14:27 -0400

I understand that we can use a license for a cold-backup server for free. In that case, is the cold-backup license activated with IP adress like production server licenses? Kind regards,

Answers: 1


Need to use DataSource as excel and have the capability to edit it. Is it possible in Denodo?
answered 19-05-2017 05:07:35 -0400

I have requirement where i need to configure excel as data source and edit it to add/update/delete some rows from it as needed. is it possible in Denodo?

Answers: 1


Supported structures and queries
answered 18-05-2017 09:07:09 -0400

Question 1: I am not being able to use "NOT NULL", "NULL" or "NOT" in the create statement for a materialized table. Is this beacuse denodo does not support this ? If this can be done can you send me an example to go by ? Question 2: I am trying to do...

Answers: 1

How to store password authentication and re-utilize again and again
answered 18-05-2017 08:32:39 -0400

Hi Team, I am connectining VDP with multiple data source in Linux. My data source are csv file , xml file and excel sheet While connecting I am using below SFTP method to connect sftp:// sftp...

Answers: 1