Latest Activity

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

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

How to Connect Denodo to a NEO4J data-source?

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

Insert colunm in SQLServer

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

Not able to login to Denodo Admin Portal with VPN enable, although I am able to login to Denodo Admin Portal without VPN enabled.

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.

What is the meaning of the below example and how can we bring it up in denodo ?

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

Data Catalog - Synchronize comments

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

Converting the text data type into an integer data type

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

Query impala not working when run over VQL vdp client.

i have query VQL like this: select nmtkp, FORMATDATE('yyyyMM',cast(tglapprove as timestamp)) as blnlApprove, COUNT(distinct(sku)) as JlhBarang,SUM(price) as HargaTotal from dbmart.facttrans a where GETYEAR(cast(tgltrans as date))=2020 and jnsklaimreg=...

dynamic parameter in derived view

How we can create a dynamic parameter to read the value for each run and then move to next condition till the condition statify please give some example

Denodo Monitor - Stopping

Hi there, Quick question about the "denodo monitor". We have a need to log all queries from all users within VDP. I have followed the online steps and have enabled them on the server in question, but I see some strange behavior. We currently have d...