Q&A

How to connect denodo to SQL server which uses Hera KMS to protect sensitive data
answered 08-07-2021 18:50:12 -0400

Hi Team, One of our consumer is migrating their DB to SQL server and will be using Hera KMS to protect their sensitive data. They want a mechanism in denodo to connect to the SQL server and decrypt the data which is encrypted by Hera KMS. They are look...

Answers: 1

#decryption #herakms #kms

User is not able to see "include users and roles" checkbox while vdb export
answered 08-07-2021 14:08:01 -0400

Hi Team, One of our consumer is unable to see"include users and privileges" checkbox while she is trying to export her vdb though she has local admin rights to the vdb she is trying to export. What is the reason behind it? How to correct it? Please help.

Answers: 1

#Export_metadata #vdbexport #Roles

Denodo Web Container Port
answered 08-07-2021 13:16:01 -0400

Hi, By default Denodo uses port 9090/9443 to host all the different Web applications such as “Web Design Studio”, “Data Catalog” and so on. I want to know if it is possible to configure a separate port for each web application. For example: Web Desi...

Answers: 1

Unable to create users other than admin with a free trail license
answered 08-07-2021 13:13:28 -0400

Hi team, I am trying execute the query CREATE OR REPLACE USER xxx 'xxxx' ENCRYPTED TRANSFER to create user other than admin. Returning error as Only a single user and role is allowed by the license. does denodo support multiple users with free trail li...

Answers: 1

Rest API as a Data Source with push down optimization
answered 08-07-2021 02:58:26 -0400

Hi Team, We are using rest service as a JSON data source. And created a Base view on top of it. Now we need to query the base view passing the where clause as a parameter which should be pushed down to the data source level as a query parameter. Have ...

Answers: 1

About Denodo 7 and Denodo 8 Linux JDBC driver
answered 07-07-2021 14:25:17 -0400

Hi team, I have some python script which use linix JDBC driver to run some vql to Denodo 7, now our Denodo upgrade to Denodo 8, Can i understand the Denodo 7 JDBC driver cannot run vql like create/delete Denodo objects to Denodo 8? If I want to run vql...

Answers: 1

Denodo 8 JDBC Driver linux import.sh

Can't access denod via JDBC
answered 07-07-2021 04:49:15 -0400

denodo-vdp-jdbcdriver.jar (from server) denodo-vdp-jdbcdriver-8.0-ga.jar denodo-vdp-jdbcdriver-8.0-update-20210209.jar denodo server version is <version displayName="8.0" major="8" minor="0"/> my local is jdk 8, python 3.6.8, jayBeBeApi 1.2.3 ...

Answers: 1

JDBC

Accessing Cache table from schedular job.
answered 06-07-2021 18:44:34 -0400

Hi is there any way where we can access cache tables from denodo scheduler jobs ? I have a situation where I have to modify the contents of cache table (Initcap function) before exporting it as a CSV file for the customer can i do this from sched...

Answers: 1

Denodo Rest webservice throwing error after Denodo upgrade 7 to 8
answered 06-07-2021 08:43:48 -0400

Hi Team, Some of the denodo Rest webservices throwing error after Denodo upgrade 7 to 8 while accessing it There was an error while generating this response: Connection error: Check the host name and port number are correct, and that client and serve...

Answers: 3

REST Webservice

LDAP Authentication
answered 06-07-2021 03:49:53 -0400

Hi team, We have able to set up the LDAP authentication for the users and created roles in Denodo VDP tool but not imported the roles. The users are able to connect with Denodo components as per the privileges provided to them. The Problem is that whe...

Answers: 1

LDAP Role and User Management