Q&A

Create data sources, base views, derived views, etc. from a RESTful service
answered 30-08-2019 09:27:28 -0400

Hello, we are looking to automate denodo object management (data sources, base views, derived views, permissions, etc.); is there any way to create objects through a RESTful service or some method other than manually through the GUI or through JDBC/ODB...

Answers: 2

Calling Simple API from Custom function/Procedure
answered 30-08-2019 08:39:24 -0400

Hi Team, We have a customer requirement to call the encrption/decrytion activity which will be via simple API from denodo layer.Could you please help /support us how to create custom function/procedure in Java to call simple API from Denodo Thanks Balu S

Answers: 3

Custom Functions

How to create a Denodo Role with limited admin rights for monitoring & support team
answered 30-08-2019 06:28:16 -0400

Hello, I wanted to see if there is a way to create a Denodo Role with privileges for read-only to all database, roles and privileges, and running queries/sessions, but can kill runaway queries and disconnect users. The objective is having a support ...

Answers: 1

Unable to establish connection: IO Error: The Network adapter could not establish the connection
answered 29-08-2019 11:01:47 -0400

Please note that this question refers to the Data Virtualization Developer (Introduction) - On-demand course. I have after 4 frustrating weeks of trial and error finally got the Denodo Quickstart virtual machine up and running on VirtualBox 6.0.01. I...

Answers: 1

Network Adapter

DB and SCHEMA - default versus usage
answered 29-08-2019 08:28:52 -0400

i have the JDBC connection set and the Database URI includes a default DB, SCHEMA and WAREHOUSE. when selecting CREATE BASE VIEW, i see other schemas. If i select a table from a schema or db other then the values provided in the JDBC connection string,...

Answers: 1
Related to: How to connect to Snowflake from Denodo

schema snowflake

How to use REST Web Service as Data Source
answered 28-08-2019 09:03:17 -0400

Hi, We are on Denodo 7.0. I am using VDP Admintool to extract data from a web service which returns the result set in pages. I am havnig difficulty in retrieving data after the first page; the situation is as described below: The URL benig used is of...

Answers: 1

REST Web Service Data Source

Diagnostics and Monitoring Tool
answered 28-08-2019 08:35:16 -0400

Hi Team, Please let me know what kind of data Diagnostics and Monitoring Tool will be stored? We are very much interested whether private date (Personal Identifible Information PII) will be store in the Solution manager. If so how are ensure GDPR for t...

Answers: 1

Denodo Diagnostic & Monitoring Tool

Fetching data from Sharepoint to Denodo
answered 27-08-2019 11:09:59 -0400

Hi, I am trying to fetch a list from Sharepoint to Denodo using the RSS method. I have the following issues. 1) The base view only provided me 25 records using the RSS link from the share point, whereas the sharepoint contains 1000's of records. 2) T...

Answers: 1

Sharepoint

Write back data into DB with denodo web service
answered 27-08-2019 05:00:15 -0400

We want to write back data from denodo to Snowflake with web service. Can Anyone suggest on this How we can implement this. We do not see any option to create a REST API for write back. Is it avialable in Denodo rest APi to write back data into DB. P...

Answers: 1

API

Unexpected error simulating this feature
answered 27-08-2019 03:36:24 -0400

Denodo 7 version on Windows 10. Creating a base view from selected table works fine... however, if i do a simple select (without parameter) select * from ADOBE_CLIENT_TARGETS it gives an error: Error executing sentence: com.denodo.util.exception...

Answers: 1
Related to: Create Base Views From Query With Parameters