Latest Activity

code

GraphQL service - passing credentials for Basic Auth

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

code

remove column when null

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

code

How to connect denodo to SQL server which uses Hera KMS to protect sensitive data

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

code

User is not able to see "include users and roles" checkbox while vdb export

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.

code

Denodo Web Container Port

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

code

Unable to create users other than admin with a free trail license

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

code

Rest API as a Data Source with push down optimization

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

code

About Denodo 7 and Denodo 8 Linux JDBC driver

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

code

Can't access denod via JDBC

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

code

Accessing Cache table from schedular job.

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