Q&A

asynchronously integration with denodo
answered 10-05-2021 06:39:43 -0400

Can I integrate with denodo asynchronously, submit a query to denodo and then get results later by an id returned with the query is submitted? Query will be submitted from AWS Lambda function in java Also, the query written must be VQL and not SQL ? ho...

Answers: 1

Denodo 7: Capture Logon Information for Failed Logins
answered 07-05-2021 16:12:23 -0400

How do we capture additional logon information when a connection fails? In our VDP logs we see messages, like the one below. Our challenge is that we do not know how to correlate this with a user account. 8222466 [RMI TCP Connection(5403)-127.0.0.1] E...

Answers: 1

Logging Denodo 7 Failed Logins

Access to Excel files on S3
answered 06-05-2021 21:34:01 -0400

Good day. According to yours documentation (https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20the%20Denodo%20Platform) for obtaining Excel (xlsx) file from S3 data storage, it have to be used "S3 REST API" aproac...

Answers: 1
Related to: How to integrate Amazon S3 with the Denodo Platform

CONTECT('cache'= 'off') is not fetching data from sources
answered 06-05-2021 18:15:10 -0400

Hi Team, I'm using Denodo 7.0. I have a derived view dv_join which has several intermediate views. Full cache mode is enabled for this view and Oracle is the cache DB. Loading the cache for this view is taking around 1 hour to complete. I want to s...

Answers: 1

cache context

Flatten multiple view in one go
answered 06-05-2021 13:56:52 -0400

Hi, when I am trying to flatten many arrays in one go but I coudnt, can you please let me know how can I do it. I read some community questuon where you said it cant be possible. **If there is valid support contract can one get it done?

Answers: 1

FLATTEN

Connecting to SQL Server using Windows Authentication with an SA Account
answered 05-05-2021 17:28:44 -0400

I have credentials for a QA SQL Sever enviroment but it requires Windows Authentication and you have to sign in as the SA account in order to access the DB. Is there a way to force this using the JDBC string? Or - do I need to do some type of authent...

Answers: 1

JDBC SQL Server password authentication

How to update a record which has special characters in it
answered 05-05-2021 16:46:18 -0400

Hi Team, i have scenario where the primary key value has special characters in it like below: "CSO NCu P/T SF, #6 South"--- is the single column value URL1:CSO NCu P/T SF, #6 South http://localhost:5090/denodo-restfulws/community/views/bv_countries/UA...

Answers: 1

Help ASAP with Property File Location
answered 05-05-2021 09:26:15 -0400

Hello, we have created a custom policy to provide row-level security to certain objects. Inside the logic, this policy works with config tables to get the provided level of security for the users via JDBC. Since we are connecting via JDBC, we have to s...

Answers: 2

Denodo 8.0 custom policy properties

Installation & Bootstrapping - regarding setting up the environment
answered 05-05-2021 07:39:03 -0400

1."Import the mysql-connector-java-.jar in to Virtual DataPort Administration Tool. The Denodo Platform does not include the JDBC driver for this adapter. So, upload the jar files of the driver using Admin Tool wizard 'File -> Extension management' ...

Answers: 1

base view in denodo by stored procedure to return table or set of coumns
answered 04-05-2021 18:32:00 -0400

I am trying to create a base view from a stored procedure in a data source that is a SQL Server database. However, when I browse to the stored procedure from the data source in the Denodo , the stored procedures show a return value of: @RETURN_VALUE (...

Answers: 1