Q&A

Convert text to Timestamp
answered 13-05-2021 11:23:10 -0400

Hello. I am trying to convert a text to timestamp: My text has this format dd-MMM-yyyy HH:mm:ss I am using this function to_timestamp('dd-MMM-yyyy HH:mm:ss', bv_ho_orders.date_placed) When I convert to timestamp some of the dates are null. ...

Answers: 2

Date Conversion timestamp

Configuring an environment with localhost
answered 13-05-2021 11:21:54 -0400

Hello, I am trying to follow the demo in DEN80EDU18S01, but when I use localhost as a host it does not let me. Is there any way of doing this demo in the same server? Thank you

Answers: 2

Environments Solution Manager

How to assign specific admin role that prevent modification on databases created by others ?
answered 13-05-2021 06:24:11 -0400

Hello, I'm wondering how to assign a specif ADMIN role to users that : allow granted users to create/modify their own databases and related objects does not allow these users to modify existing databases created by others Currently, I'm only ...

Answers: 3

Roles Users

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