Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

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