Q&A

how to set up an active-active Denodo Cluster with 2 nodes behind the Nginx load balancer
answered 08-07-2022 14:10:43 -0400

how to set up an active-active Denodo Cluster with 2 nodes behind the Nginx load balancer for Denodo 8

Answers: 9

Load Balancer Nginx Denodo 8

Step by Step Screen shot or Videos
answered 08-07-2022 13:52:58 -0400

Why doesn't Denodo offer free video on the step by step process on the installation and bootstrapping process, from MySQL to the platform or screen shots?

Answers: 1

Installation video

Scheduler job are failing with below error.
answered 08-07-2022 13:48:45 -0400

Scheduler job are failing with below error. Error executing query. Total time 58.293 seconds. Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results __6A8344AF-188C-4395-BF17-5B65090A3EBF_J8677F255-F04D-497C-A94...

Answers: 1

DENODO Denodo Scheduler 8.0

Diagnostic & Monitoring Tool: Unable to connect to VDP server with Token
answered 08-07-2022 09:30:03 -0400

Hi, I'm trying to connect to one of the VDP Server using Diagnostic and Monitoring Tool from SolutionManager. I get below error Unable to connect to VDP server '10.x.0.x-nonprod' (admin@10.x.0.x:9999/admin with Token): Cannot connect to server '10.x.0....

Answers: 3

Solution Manager Denodo Diagnostic & Monitoring Tool

Installation & Bootstrapping
answered 08-07-2022 06:44:13 -0400

Not seeing a new database schema called "acme_crm" with three tables defined (address, client and client_type). When running script, says dupliate database but when I look at Programdata/MySQL... I see acme_crm and the separate IBD Files but no databas...

Answers: 1

Installation Denodo Installation

Denodo VDP cache
answered 06-07-2022 17:14:15 -0400

Hi, I am trying to create a VDP cache Job that invalidates and loads data every 30 min. It was throwing the below error when I checked "Load / Invalidate data in a single transaction" box on our demo environment but it is not happening when we do it ...

Answers: 1

vdpcachedatasource VDPCache

SPLIT and FLATTEN in the same query statement
answered 06-07-2022 14:55:31 -0400

Hi, regarding to the FLATTEN documentation you have to create a view containing a split first, before you can use FLATTEN. https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/from_clause/flatten_view_flattening_data_stru...

Answers: 1

Invoke Snowflake procedure
answered 05-07-2022 09:57:37 -0400

Unable to invoke snowflake procedure(mentioned below) from Denodo. Getting error as CALL not supported CALL uspLoadBatchKey('2022-06-06',8,'N','N','10','MonthlySta') Note: Not able to see this procedure from Denodo during base view creation. Could ...

Answers: 5

snow flake procedure

Kerberos vs third party identity provider
answered 01-07-2022 19:40:46 -0400

The documentation is rather vague on the scope of the different SSO authentication methods There is basically SSO using either Kerberos or a third party integrator using SAML/Oauth etc. Thats clear. Whats not clear however is what parts of the Denodo s...

Answers: 5

Kerberos Authentication SAML VDP Client

Pull Passwords and Logins From Excel File
answered 01-07-2022 19:35:41 -0400

How do I pull logins and passwords from an Excel file? So, my processes can automatically login to the needed cites using the login info from our excel spreadsheet. We already have our Excel file deployed as a data source in the Web Automation Schedule...

Answers: 1