Q&A

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

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

VDP Server will not start due to a data source connectivity problem
answered 18-03-2020 20:31:21 -0400

We cannot get our VDP server to start at the moment. We have a datasource connected to a SQL Server DB where the external security on the host has changed to SSL, so I'm pretty sure in the Denodo driver settings I need to set SSL to 'On' but I'm not ab...

Answers: 1