Q&A

denodo roadmap
answered 18-09-2020 14:55:50 -0400

where can I found roadmap? what is the difference between denodo and dremio?

Answers: 1

roadmap

Multiple Users in 1 session, assessing same database same view.
answered 18-09-2020 08:08:27 -0400

would just like to check whether there are any restrictions or performance related impacts when multiple users are accessing the same views at the same time.

Answers: 1

session

Extract all option in Excel without sheet name is possible(Excel has multiple sheets)
answered 18-09-2020 07:54:04 -0400

Hii, I have a question related to Excel data dource wherein I am trying to create a scenario where I have multiple sheets in one single excel..say demo1.xsls. When I tick (a) Extract Sheet name as column name (b) extract data from all sheets. Then...

Answers: 1

Excel Denodo Excel Add-In

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