Q&A

GraphQL service - passing credentials for Basic Auth
answered 09-07-2021 12:29:33 -0400

Hi Team, We were trying to use GraphQL service using an IDE something like GraphQL Playground, however, were unsure how to pass connection details into the header for basic authentication. By looking at Denodo's documentation you specify that - '' In...

Answers: 1

GraphQL

remove column when null
answered 09-07-2021 04:16:02 -0400

Hello, I have exposed the data in JSON and now I want column/key which has null value in it should not appear in JSON, example: { "student": "1203", "Rollnumber": "1", "status": "deactivated", "Grade": ...

Answers: 1

null

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 linux JDBC Driver 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