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 April 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

Issue checking out using VDP from TFS
answered 24-05-2017 06:02:55 -0400

Version: 6.0 Latest Update: denodo-v60-update-20161219 Error Message: "An error was found: error checking /databases/myDatabase out: Error: includeCreateDatabase option was selected but the repository does not contain the file '--path to local reposit...

Answers: 1

TFS VDP Source Control VCS

Connecting to WorkDay
answered 23-05-2017 16:36:05 -0400

We loaded the correct WSDL file, but what Authenication setting should we be using to connect to Workday? We tried them all and using the right credentials, but we are getting "connection error: Connection refused: connect" error. Any assistance on thi...

Answers: 1

Workday

Installing trial of Express and having license issues
answered 23-05-2017 16:26:17 -0400

I installed the trial, but did not install the license. When i open the app, the control center syas that there isn't a license, so i follow the link to install the license and then restart. didn't work. I tried the LICENSE file in the JRE folder, but ...

Answers: 1

How do I pull all records from the past two days?
answered 23-05-2017 06:39:57 -0400

What is the best way to pull all records from the past two days? Here is what I currently have and it does not work: select * from table_1 where creation_date between CURRENT_DATE and Subtract(CURRENT_DATE(), 2)

Answers: 1

JDBC query QueryOptimization

Reinitialize Custom Function at the VDP Server level
answered 23-05-2017 04:58:16 -0400

We have a function that uses an third party service. After a period of time, the function's object that uses the third party services becomes corrupted. At that point we need to reinitalize the function for the vdpserver to recreate the object that use...

Answers: 1

Custom Functions

Active Directory in Azure for user/group management
answered 22-05-2017 10:32:54 -0400

Hi, Does Denodo Platform support integrating users & roles with Active Directory that is hosted in Azure rather than on premises? My understanding is with Azure AD it's a RESTful web service rather than LDAP method to query the data. I recognize...

Answers: 1

Error while updating the denodo-v60-update-201705152100 on Linux
answered 22-05-2017 09:16:43 -0400

Hi Team, We are trying to update "denodo-vdp-v60-update-20170515" . We have done successfully on Windows by doing floowing setps : 1) Click on Update 2) Click on install and update 3) Selected d/denodo-v60-update-201705152100.jar But in linux we f...

Answers: 1

update

NULL/NOT NULL
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