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.

Force left outer join
answered 24-08-2017 09:31:40 -0400

Hi again team! We have a query that has a left outer join inside it and it also has some filters in the where statement. For some reason, denodo is changing the left outer join to an inner join. Is there any way to avoid this behavior? We really want ...

Answers: 8

how to create view name with upper cases
answered 24-08-2017 09:14:32 -0400

Hi All, I have one view I would like to create that view name as below: original view name is : producer_summry but while I am publishing into REST services its suppose to be as below Producer_Summary. how do will change the names with upper cases....

Answers: 2

Validating the Denodo Backups
answered 24-08-2017 03:38:11 -0400

Hi, We are taking denodo backup on daily basis. Will it be possible to vaidate the backup vql to make sure that we have a healthy backup. We want to carry this process on mothly basis. I don't find any way in admin guide to do same . for example: resto...

Answers: 3

Denodo Backup DENODO

Performance optimization with Salesforce Instance
answered 23-08-2017 09:20:42 -0400

We've established connectivity with Salesforce using oAutho2.0 & custom wrappers in Denodo. Retrieved few objects using "com.denodo.connect.salesforce.rest.wrapper.SalesforceRestSelectWrapper". However, duration to extract data from SF with 1 or 2 ...

Answers: 1

#salesforce #performance #optimization

Cannot access to Denodo Excel Add-in link
answered 23-08-2017 09:19:25 -0400

Hi guys! How can I get access to the following link? https://support.denodo.com/ShowDenodoConnect.do I found that in a post that suggest connecting denodo server from Excel add-in and I want to test it as I'm trying to get a way to export several ...

Answers: 1

Denodo Excel Add-In

Best way to do mass exports
answered 23-08-2017 09:02:43 -0400

Hi guys! I'm trying to find out the best way to do a mass export from denodo (like 20MM records). I'm just starting my research so any help would be useful. Thanks in advance! Best, Fabian

Answers: 3

mass exports best practices

Error obtaining VQL in base views. Missing read privilege on the wrapper
answered 23-08-2017 08:37:10 -0400

Hi, I have read and write privilege on a virtual database. For the base views when I click the VQL tab to see the VQL associated with the view I am getting an error as below: Error obtaining vql: The user does not have READ privileges on the wrappe...

Answers: 1

VQL base view Wrapper

Caching Service Views
answered 23-08-2017 08:29:10 -0400

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

Answers: 1

cache DENODO Denodo Scheduler 6.0 SQL Server

Accessing Open Data API
answered 23-08-2017 07:32:08 -0400

Hello there, I was just curious, how can you access an Open Data API with Denodo to retrieve Data in real time to be provided as a web service, self-service, or views that can be combined with other disparate data sources? Thanks in advance.

Answers: 3

API users View Web Service

Converting value in a field
answered 22-08-2017 11:32:20 -0400

Hello there, I am currently trying to add a projection to a dervied view that checks the values of two fields and if they are equal then the values for one of the fields shoud be turned into an empty string. I was wondering if any one can give me a ha...

Answers: 2

Select field CASE