Latest Activity

code

query return different value in VDP and python script connect denodo via JDBC driver

Hi Team, I ran below two command in VDP and python script (via JDBC driver), thry show different value, why? I want to have the python script running have the same return result as the VDP return result. DESC VIEW view_1 VDP result: include name, expre...

code

Issue while configuring Kerberos Authentication

Hi Team, We are in process of enabling Kerberos authentication at server level. We have created the global user, SPN and the Keytab file and enabled the Kerberos at the server level giving all the required details. When we restart the vdp server, it s...

code

18 digit timestamp LDAP timestamp conversion

I have a timestamp field in the following 18 digit format from our LDAP 132332110839739771 Is there any easy way to convert this to a standard date format? based on converter online this is the value: Epoch/Unix time: 1588737483 GMT: Wednesday, Ma...

code

Where Condition on Analytical Function Output

Denodo 6.0 20201123 I created a new field from the RANK analytical function in one of my datasets. In order to do so, I had to use the workaround of sending the data from a view down to a temporary table on a SQL server. This was because part of the d...

code

Error while inserting data with bulk load activated on Oracle Data source

Hi, I’m making tests on data file load using Denodo Express 8.0 for Windows 64 bits. I have an Oracle instance running on the same computer. I run catldr.sql as sysdba on the Oracle database. I created a data source (dstrcr) and activated "Use Bulk D...

code

Apply update option not available

Hi, When I open Environments > Configuration, I cannot see the operations section as shown in the video. I only see 'Actions' where I can either diable the environment or open Diagnostic and monitoring tool. I am using the Denodo 8 solution manager...

Related to: Automatic installation of Updates

code

Timestamp From 24 Hours Ago of Current Timestamp

Hello, I know that I can get the current timestamp using the currenttimestamp function. I wanted to know what is the right way to subtract 24 hours from the timestamp returned from that function, in order to find the timestamp of exactly 24 hours befo...

code

Virtual dataport

Virtual DataPort identifies the return structure of a web service containing polymorphic/recursive data types and anyType by the

code

JDBC Data Sources

In JDBC data sources, when should you create a base view from query

code

kerberos Setup for Denodo80

Hello, We are on Denodo7.0 and now building Denodo8.0 setup having one Solution manager and one Denodo server. I am just wondering while enabling SSO through kerberos, i have to put SPN ,Keytab and configuration file details, as I am performing POC i w...