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 September 2019.

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.

Create view from the predefined Denodo stored procedures
answered 25-03-2020 12:48:30 -0400

How do you create a base view from the predefined/out-of-the-box Denodo stored procedures? I do not see them listed in the element tree although I am able to return results as well as list the procedures via the VQL shell query.

Answers: 3

Denodo stored procedure

Quoting columns that are keywords or start with digits
answered 25-03-2020 10:41:10 -0400

I'm trying to run the following query against a virtualized Postgres database via JDBC SELECT "fielding" . "gs" AS "gs" FROM "data_world_gosales" . "fielding" AS "fielding" I get an error Field not found 'fielding.gs' in view 'fielding' . Other field...

Answers: 1

View parameter : function as Default Value
answered 25-03-2020 10:40:00 -0400

Hi, putting View Parameters in a Derived View, can I specify a function result as Default Value. e.g. Getyear(date) => any specific syntax needed ? Thanks

Answers: 1

view parameter default value

XSLT Stored procedure
answered 25-03-2020 06:14:26 -0400

Hello, I have been trying to use XSLT stored procedure following the examples in the documentation with no success. Here is a try that returns null : SELECT XSLT( ' <shop> <products> <product> <id>1</id> <name>Vi...

Answers: 1

Denodo VPC change migration in AWS
answered 24-03-2020 12:32:01 -0400

Hi Team, Denodo is UP and running in AWS Environmnet, Now we need to change VPC on AWS and want to Move/Migration SAME denodo setup (as it is up an running ) in another VPC, Please let us know the Step what are chnages need to done in new VPC etc.....

Answers: 2

code migration

license information
answered 24-03-2020 10:36:52 -0400

Hi Team, Is there any file which stores the license details? Thanks.

Answers: 4

License

Denodo scheduler with cached views queries.
answered 23-03-2020 10:32:17 -0400

Hi team, I'm a Denodo7 admin and wanted to know how can I validate the views that are cached have a corresponding schedule that keep the cache up to date? For example I can use CACHECONTENT() to see last it was 'full' cached but is there a existing job?

Answers: 1

#Scheduler #cache

How to find Invalid views using VQL or Query
answered 23-03-2020 04:21:49 -0400

I want to find the invalid views using vql or query . This is really important as when import happens to higher environement using solution manager it really doesnt show the errored view and need to manually check all the views which is very tedious. ...

Answers: 2

Thanks for the video
answered 20-03-2020 05:32:25 -0400

Thanks so much for sharing the video.

Answers: 1
Related to: Denodo Platform Enhancements - 7.0 Update 20200310

Thanks for sharing it in vedio format
answered 19-03-2020 02:24:44 -0400

Thanks :)

Answers: 1
Related to: Denodo Platform Enhancements - 7.0 Update 20200310#details