Q&A

Access DENODO over the network
answered 05-07-2019 06:57:38 -0400

Hi, Would like to ask how to access DENODO over the network. Thanks in advance!

Answers: 1

How to connect to Google cloud storage?
answered 04-07-2019 08:13:39 -0400

I need to connect to Google Cloud Storage from VDP Admin tool. Below user manual seems not clear enough. https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual Di...

Answers: 1

cloud DENODO custom Connection Custom Connector HDFS custom data source DataSource

Does Denodo support environment variables and/or environment.property file?
answered 04-07-2019 08:07:28 -0400

I have a custom stored procedure which needs to access a keystore file stored on the environment filesystem. This location depends on the environment itself (dev, tst, prd). I have a derived view, which is a join between this custom Stored Procedure a...

Answers: 1

Complex query that return a time out in VDP
answered 04-07-2019 07:43:26 -0400

Hello, I have a query like that: SELECT t1.* FROM elements t1 WHERE ( ( t1.name IS NULL OR t1.name = '' ) AND t1.id NOT IN ( SELECT t2.id FROM elements t2 WHERE ...

Answers: 1

SQL

connection error.cannot trust in the server to establish a ssl connection
answered 03-07-2019 09:05:02 -0400

Hi Team, Iam facing this issue when trying to log in to VDP admin tool after installing self signed certs . can you please hellp in solving this issue and guide me do i n eed to do any chnages other then what i have done. changes made Changes Made: ...

Answers: 3

This driver is not configured for integrated authentication
answered 03-07-2019 08:32:29 -0400

Version Denedo 7. SQL Server Version: SQL Server 2016. Jar File version : mssql-jdbc-6.4.0.jre7.jar File :sqljdbc_auth.dll exists in c:\windows\system32 and exists in <DENODO_HOME>/jre/bin. Connection string is in order. But, Failed to establish...

Answers: 1

This driver is not configured for integrated authentication denodo

How to view the Underlying Table or the CSV file Names using data lineage capability of Denodo Catalog
answered 03-07-2019 05:42:00 -0400

How to view the Underlying Table or the CSV file Names using data lineage capability of Denodo Catalog. While browing we were able to view the underlying views and the data sources but cannot drill down further to know the underlying table or CSV files...

Answers: 1

#Data Lineage

How to identify if values in a column is numeric ( Function similar to Isnumeric is SQL)
answered 02-07-2019 07:45:30 -0400

Hi All, I am deriving one column logic where i have to check if the column value is numeric or not, i did not found any fuction like ISNUMERIC() here, can anyone please help how to achieve same in VQL. Thanks in advance.

Answers: 1

isnumeric() number values numeric

HTTP POST in Denodo Testing Tool
answered 02-07-2019 07:21:50 -0400

Is there any working to specify a HTTP POST request (including params + body params) in a QUERY and/or RESULT directive? Is there any plan to include this feature in a further version of the testing tool?

Answers: 2

Denodo Testing Tool

Denodo query simplification taking a long time.
answered 01-07-2019 21:15:17 -0400

We have a complex final view that utilizes many (20+) base views. All of the base views are cached so the query execution plan in very simple. However, in looking at the execution plan we can see that the optimizer is taking 8-9 seconds in query simpli...

Answers: 1

VDP query optimisation