Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Compare Objects From One Environment to Another
answered 12-05-2021 18:16:43 -0400

Hi, We have 3 environments -- Development, Stage and Production. Ideally, these environments should have the same objects/views to it but of course if there are development/testing chances are, there will be differences but is there a quick way to fin...

Answers: 1

Date subtraction
answered 12-05-2021 17:10:35 -0400

I am trying to subtract 4 months from the current date (without time) and then convert it to numeric value in the YYYYMMDD format. Looking at the manual (https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_...

Answers: 1

Date Conversion

Retieve header from http client request
answered 12-05-2021 09:27:51 -0400

Hello, In order to connect a denodo to a rest API, I need to first execute the request to log in and retrieve a cookie that is return among the headers of the response. The body of that response is a json. So I created a JSON Data source connector. I...

Answers: 1

On-prem Denodo connecting to AWS
answered 12-05-2021 07:52:14 -0400

Access Key ID: The access Key ID using s3a. This parameter sets the fs.s3a.access.key parameter. Secret Access Key: The Secret Access Key using s3a. This parameter sets the fs.s3a.secret.key parameter. IAM Role to Assume: The Amazon S3 IAM Role to Assu...

Answers: 1
Related to: https://community.denodo.com/kb/en/view/document/How to integrate Amazon S3 with Denodo Distributed File System Custom Wrapper

DENODO

Number formatting - equivalent to to_char?
answered 12-05-2021 05:12:49 -0400

I need to format a number as 9,999.00 (ex: 2,324.22). In Oracle I would use the to_char function. Do you have any built-in functions that would do anything similar?

Answers: 3

VDp mask

Data Catalog partial/selected synchronization
answered 11-05-2021 21:44:19 -0400

We are using the current Denodo 8 update release - Data Catalog version 8. Is there a way to sync only selected VDP virtual schemas or Denodo databases? For example, it would seem there would be no need to expose the 'admin', 'itpilot', etc. to the D...

Answers: 1

Data Catalog sync to VDP

Denodo 8 Migfration - Third party driver issue
answered 11-05-2021 18:01:04 -0400

Hi Team, We have started migration from Denodo 7 to Denodo 8. Export and import of metadata is completed. We are in process of testing the northbound connection. There is a data source which basically will connect to hive and the database adapter whic...

Answers: 1

#Hivedriver #migration #ThirdPArtyDriver

About Scheduler Administration Tool
answered 11-05-2021 13:20:23 -0400

two questions about denodo Scheduler tool: does denodo Schedule tool can call shell script job or python script job Does only the administrator of VDP has the access/write right for tool Scheduler Administration?

Answers: 3

Denodo Scheduler 7.0

Connect Denodo to Azure-DataBrick with Simba driver
answered 11-05-2021 08:25:38 -0400

Hi, I am trying to connect Azure Databricks through Simba driver, but getting error due to autherntication or something else. Steps: I downloaded it from website (https://databricks.com/spark/jdbc-drivers-download) and put it in Denodo ( DenodoPlatfor...

Answers: 1

simba databrick deltalake

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