Q&A

Record size exceeds internal limit error
answered 18-09-2020 04:33:46 -0400

Hello Team, I connected Netezza Data Source.I have created an view in Denodo. I am getting an error like 'Record size 90220 exceeds internal limit of 65535 bytes' while executing query. I serach this error and i found that it is Netezza's error. But ...

Answers: 3

Error

Denodo 7 Unattended Installation Issue with SCCM Deployment
answered 17-09-2020 07:50:53 -0400

Hello, I am currently attempting to install Denodo 7 with update 20200310 and when deploying through SCCM it always fails, here is the output, I have tried increasing the java memory heap but that does not resolve issue, do you have any things to try ...

Answers: 1

Denodo 7 sccm

1. How one can acess Encrypted Excel file via Excel data source.? 2. using an Interpolation variable will excel file who have all different password set
answered 17-09-2020 07:49:11 -0400

I have set passowrd to Excel file and was trying to access my file but it doent helped using Decrypt(DES, MD5 ) option How can we use interpolation variable when we have lots of locked Excel file. SO I have query around password only and How ca...

Answers: 1

Excel Interpolation Variables Denodo Excel Add-In

How to Connect Denodo to a NEO4J data-source?
answered 17-09-2020 06:02:14 -0400

Hi All, I want to connect Denodo to a NEO4J Source. We have the JDBC driver (.jar) and this JAR file is working. How should we connect Denodo to NEO4J? I Can't select NEO4J when creating a new JDBC Source. King Regards, Chris Bos

Answers: 4

NEO4J / JDBC / Connection

Insert colunm in SQLServer
answered 17-09-2020 01:11:49 -0400

Hi, How i format this colunm in DENODO for write back in SqlServer table? COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS NULLABLE SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTE...

Answers: 1

Write-back scenarios

Not able to login to Denodo Admin Portal with VPN enable, although I am able to login to Denodo Admin Portal without VPN enabled.
answered 16-09-2020 09:02:30 -0400

After starting VDP server when I am trying to login into Admin Portal with company VPN enabled in the laptop then I am getting error: "Failed to login. Permission denied". Although I am able to login without VPN enabled in my laptop.

Answers: 1

What is the meaning of the below example and how can we bring it up in denodo ?
answered 16-09-2020 09:01:38 -0400

pivot ( min([Planned Date]) for [test] in ([sample1], [sample2]) )

Answers: 2

Data Catalog - Synchronize comments
answered 14-09-2020 12:17:56 -0400

When I change the description of a database in the data catalog, I cannot see this change in the VDP. Also, when I change the description from the original value in the VDP, this value is never refreshed in the catalog. Do they maintain a different m...

Answers: 3

Data Catalog

Enforce TLS 1.2 on Denodo servers
answered 14-09-2020 08:56:59 -0400

Hello, we would like to enforce TLS version 1.2 on our Denodo servers (including Denodo Solution Manager), SSL/TLS is enabled at the moment but we don't seem to find a way to disable versions 1.0 and 1.1. How could we proceed?

Answers: 1

Converting the text data type into an integer data type
answered 14-09-2020 08:50:46 -0400

Hi there, I'm trying to convert a field of data type 'text' to 'integer' in denodo. The below is my sample operation. select column1, column2, column3 from bv_sample order by cast(field1 as integer) ; I get the below error: "Error converting data t...

Answers: 3

#Denodo #denodotestingtool #testingtool #denodo #SQL #VQL