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
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
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
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
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
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
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
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
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
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