Q&A BY TAG 'VDP'

You must sign in to ask a question. If you do not have an account, you can register here

Virtual DataPort 8.0: Remote license not found. The server is not registered in Solution Manager. When 2 SM server is load balanced
answered 16-12-2022 20:28:54 -0500

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

Answers: 1

Load Balancer Solution Manager VDP

Denodo 8: synchronize the VDP server metadata with Data Catalog using Data Catalog REST API
answered 23-07-2021 20:15:36 -0400

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

Answers: 3

Denodo 8 REST API VDP Synchronize Data Catalog

TomcatManager error when starting VDP
answered 09-06-2021 18:33:25 -0400

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

Answers: 1

Tomcat vdp TomcatManager

handelng leading zeros
answered 09-06-2021 17:42:35 -0400

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

Answers: 4

VDP SAP leading zeros

Number formatting - equivalent to to_char?
answered 12-05-2021 05:12:49 -0400

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?

Answers: 3

VDp mask

VDP v7 Not able to pull from Gitlab
answered 15-04-2021 08:27:33 -0400

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

Answers: 1

VDP GIT

python cur.execute result is not the same as the query result from VDP
answered 29-03-2021 08:20:44 -0400

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

Answers: 1

python VDP cur.result not correct

GetSession not working outside of the VDP
answered 11-03-2021 07:55:36 -0500

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

Answers: 1

select query vdp getsession dbeaver

query return different value in VDP and python script connect denodo via JDBC driver
answered 08-03-2021 07:10:09 -0500

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

Answers: 1

python VDP return result different

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

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,

Answers: 1

Date Conversion VDP DENODO