Q&A

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

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

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

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.

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

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

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

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

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

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