Q&A

About VCS Statistics of views
answered 05-08-2020 17:35:10 -0400

Hi team Currently all of DV views are VCS by gitlab. I have a base view created, which is build on Oracle database. Now the views is under VSC bygitlab also, but it has no stastics gathering. So I gathered its statstics, and I also make the vql shown w...

Answers: 1

VCS gitlab view statistics

name the csv reports
answered 04-08-2020 18:14:14 -0400

Hi, using Denodo Testing Tool, I would like to have a distinct csv report for each .denodotest file, using the %NAME of the test for the name of the csv. for example if in my .denodotest file I have %NAME test1, i would like to have a report named test...

Answers: 1

Teradata to denodo sql
answered 04-08-2020 07:16:22 -0400

how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1

Answers: 1

date

Connection error:Connection timedout connect
answered 04-08-2020 03:35:17 -0400

Hi Team, After starting all the servers in the VDP login page of the Denodo platform Control Center 6.0,getting the below error. Connection error:Connection timed out connect. Please help on this regard.

Answers: 4

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