Q&A

Multiple Union statements with parameters are not working in VQL.
answered 03-08-2020 08:29:36 -0400

Hi There, We are trying to implement multi UNION. It is something like following: `CREATE VIEW iv_union_test as SELECT * FROM iv_derived_vw q1 WHERE q1.date = i_date AND q1.id = i_id AND q1.flg = 0 UNION SELECT * FROM iv_derived_vw q2 WHERE q2.date ...

Answers: 1

UNION

Can you run a delete statement through the scheduler instead of deleting the entire table before inserting data?
answered 31-07-2020 16:01:28 -0400

Is there a way in Denodo Scheduler to delete specifics rows from a database table without having to delete the entire table and re-populating it with the rows that should not be deleted?

Answers: 1

Denodo Scheduler 7.0

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 31-07-2020 13:13:16 -0400

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 3

Cache

How to deploy Scheduler jobs via Solution Manager REST endpoints?
answered 31-07-2020 05:04:07 -0400

Hi Team - I know we can deploy Scheduler jobs by using Create Revision GUI of Solution Manager. I also know there is a REST endpoint for creating revisions from VQL file which takes only a VQL file as an input. Now my question is how can I create a re...

Answers: 1

Solution Manager API

Fail to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM.
answered 31-07-2020 04:07:13 -0400

Hello, I try to connect VDP Admin tool to a sgbd Oracle, running in a training virtual machine named DQVM. A screenhot is joined for illustrate, the error message is (ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )...

Answers: 2

DQVM Oracle

Denodo Base view created upon SQL Server Stored Procedure does not accept special characters as input parameter.
answered 30-07-2020 12:48:47 -0400

I have created a Base View upon a SQL Server stored procedure which accepts a single input parameter of string datatype. I tested the base view in the EXECUTION PANEL with some sample inputs containing special characters and spaces. But for some reason...

Answers: 3

Can Denodo pull arp tables?
answered 30-07-2020 07:39:46 -0400

Curious if denodo can query network devices for ip/mac information. IS there a way to do a custom connection using SNMP and parse the results?

Answers: 1

VDP server service issue
answered 30-07-2020 04:26:52 -0400

Hello, We are using the Denodo v7.0 evaluation version and are in the middle of a Proof Of Concept. We are experiencing an intermittent issue where the Virtual DataPort Server will be stopped when we check on the services in the mornings. Last week w...

Answers: 1

CAST - Function to DB2
answered 29-07-2020 17:56:42 -0400

Hi all, Can anyone tell me if it is now possible to push down a CAST function to a DB2? I have enormous performance losses, because Denodo cannot push down the cast function. Thanks in advance

Answers: 1

#CAST #DB2 #Push-down

RHEL 7.8 and Solution Manager - blank window
answered 29-07-2020 08:17:09 -0400

Hi, I tried to install Denodo Solution Manager 7.0 on Red Hat Enterprise Linux Server 7.8 with graphically wizard but when the wizard started I have a blank window( white window). So I resolved with a command line installation but when I try to start ...

Answers: 1

SolutionManager; RHEL; Interface