Home / Q&A / All Questions

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.

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

base view VQL 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

Denodo Testing Tool to show result set in log file
answered 21-08-2017 17:47:42 -0400

Hi, Could you please let me know how to configure .csv result file under logs for Denodo Testing tool to show the actual result set. This will be helpful for testers in addition to just knowing whether the test passed or failed. Thank you! Regar...

Answers: 2

Denodo Testing Tool

Password Encryption in Denodo Testing Tool
answered 21-08-2017 14:24:41 -0400

Hi, I followed the article under Q & A section (FYI: How to get encrypted passwords in your configuration.properties file for the Denodo Testing Tool (DTT)) to encrypt the password in config file. However, I am getting the error message below. ...

Answers: 2

Denodo TEsting Tool

Display two decimal only in the Column
answered 21-08-2017 09:25:47 -0400

Hi All, I have one column Revenue it will poplater data as below Revenue 2500.123615 3500.345634 8900.12349343 In this above data, I want to get two decimals after the number Revenu 2500.12 3500.34 8900.12 like this.. Please let me know any idea h...

Answers: 1

Access issue for the project admin
answered 21-08-2017 08:26:25 -0400

Why does the project admin could not see detail report icon link on denodo scheduler admin. Regards Karthi

Answers: 1

Denodo scheduler admin

Recursive/Hierarchical Query
answered 21-08-2017 03:13:46 -0400

We are looking to perform a hierarchical/recursive query similar to a CONNECT BY query in Oracle or a CTE in SQL Server. Here is a working query in SQL Server that we are attempting to reproduce in Denodo. Denodo understands the "with" clause, but no...

Answers: 5