Latest Activity

Virtual DataPort 8.0: Remote license not found. The server is not registered in Solution Manager. When 2 SM server is load balanced

We have installed two solution managers and configured Postgresql as an external metadata database. These two SM machines are load balanced using an external TCP load balancer. Firewall ports 10091, 19090, and 19443 are opened in the load balancer so i...

Load Balancer Solution Manager VDP

Denodo 8: synchronize the VDP server metadata with Data Catalog using Data Catalog REST API

Hi Team, I am following page https://community.denodo.com/docs/html/browse/7.0/vdp/data_catalog/appendix/rest_api/rest_api#rest-api for metadata synchronization from VDP to Data Catalog for Denodo 8. Can you please help confirm if the Denodo 8 can use ...

Denodo 8 REST API VDP Synchronize Data Catalog

TomcatManager error when starting VDP

Hi Denodo Team, We are using denodo 8.0 version, and we have been having an error related to TomcatManager when starting VDP server; In vdp.log: 2276 [main] INFO 2021-06-08T14:35:05.800 server.start [] - Starting Denodo Platform 8.0 20210209 - Proces...

Tomcat vdp TomcatManager

handelng leading zeros

Hey Team, I have a Database (SAP) that I connect via the custom wrapper (RFC Calls). In this I have a column that contains leading zeros. It usualy contains int with 8 digits but itis saved as text with 10 char (2 leading zeros). Is it possible to map ...

VDP SAP leading zeros

Number formatting - equivalent to to_char?

I need to format a number as 9,999.00 (ex: 2,324.22). In Oracle I would use the to_char function. Do you have any built-in functions that would do anything similar?

VDp mask

VDP v7 Not able to pull from Gitlab

Hi - when pulling the latest code from remote, it succedes. We can see the correct files on the Denodo server. But when pulling inside the VDP client, not all changes appear, but no error is reported. We are running version v7.0.2x We can also push...

VDP GIT

python cur.execute result is not the same as the query result from VDP

Hi team, I used jdbc connect VDP on linux server, I am execute below query in my python script: select * from view_a limit 3; Its result is below: [('2021-03-27', '1970-01-19 10:39:21.600000', '', 'EF\x01\x01', None, None, None, None, None, None, None,...

python VDP cur.result not correct

GetSession not working outside of the VDP

I had the following script and then various views based off this script working in the VDP but then when I tried to run a dervied view from a tool like DBeaver everything is coming up blank because the GETSESSION function is not returning a value. Is...

select query vdp getsession dbeaver

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

python VDP return result different

How to convert a date in string format to interval date

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Date Conversion VDP DENODO