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 updated version of the Denodo Express 6.0 with new features and fixed issues starting in June 2017.

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 6.0 at the Express home page in the Denodo Community

Denodo4e source download?
answered 24-07-2017 04:45:38 -0400

Hi, Where can I download the denodo4e? Currently we dont have access to our Denodo Instance.

Answers: 1

Auto Documentation/Data Lineage Gif
asked 21-07-2017 12:41:51 -0400

Hi there, Is there a script that would scan through VIEW_DEPENDENCIES() and produce GIF/Data Lineage diagram or possibly a PDF and store in a folder? We are looking for a fast and reasy way of documentating the virtual data models rather than manually ...

Answers: 0

Throwing Error in VDP Job Query in Scheduler
asked 21-07-2017 12:21:50 -0400

Hello, I am working on creating a job inside of Denodo Scheduler that will throw error if a specfic condition is false. Example: CASE WHEN(foo This function should be comparable with SQL's RAISE ERROR command. Please advise, Nate

Answers: 0
Related to: VDP Conformance with Standard SQL

Job scheduler Scheduler Throw Denodo Scheduler 6.0 Error RaiseError

VQL edit problem
answered 21-07-2017 09:37:09 -0400

Hi, I need to change a timeout of certain selection (view) by editing VQL. When I edit and save CREATE VIEW "example" FOLDER = '/exampleFolder' AS SELECT a.a AS a FROM t CONTEXT ('formatted' = 'yes','timeout'=0); VDP returns to the Summary screen witho...

Answers: 1

SEARCH METHODS- USAGE
answered 21-07-2017 08:48:05 -0400

I have created a base view for client(client_id text, client_type text, name text, surname text) coming from a jdbc data source. Five tuples: Client_id text any OPT ANY { } YES. I changed the Output tuple to NO but still when I query the base view usi...

Answers: 1

search methods

Connect to Denodo from R
answered 21-07-2017 08:42:07 -0400

Hi, I wonder how I can connect to Denodo from R? Regards, Alex

Answers: 1

R

Making an API call to a external data set
asked 21-07-2017 02:06:09 -0400

I want to read data from the US Census Bureau public data set files. The data is available (for free) via an API call to their site. I would like to use Denodo to access that data via the API. How do I do this? Example Call: api.census.gov/data/2015...

Answers: 0

API users JDBC Data Sources

State ROW_LIMIT_REACHED
asked 20-07-2017 09:22:56 -0400

I have updated Denodo with 20170515 patch and after update ROW LIMIT has been set to 1000. I'm unable to find out where can we have this parameter changed. On execution panel I have only Limit rows and execute with trace check boxes enabled. I believe ...

Answers: 0

ROW_LIMIT_REACHED State

How to start web service
answered 20-07-2017 08:43:48 -0400

Hi Team, I am new to this tool. i have not installed my sql as i have connected it to post gry server for learnign purpose. I am not sure how to connect to we bservice and whatare the prerequisite software needs to be installed. I see its below stuff ...

Answers: 1

Web Service Data Source

Validating the Denodo Backups
answered 20-07-2017 08:09:18 -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: 1

Denodo Backup DENODO