Q&A

Command to confirm for odata4 service running in vdp server?
answered 02-12-2020 06:24:37 -0500

What is the command to confirm for odata4 service running ( by default) in a vdp server?

Answers: 1

DENODO

I have installed Oracle VM VirtualBox and I cannot find the file referenced as Denodo Training QuickStart Virtual Machine.ova
answered 01-12-2020 12:50:03 -0500

I have installed Denodo 8.0 successfully and Oracle VM VirtualBox and I cannot find the file referenced as Denodo Training QuickStart Virtual Machine.ova. In order to point the Virtual Box to the Denodo data for the Developer course. Does anyone know w...

Answers: 2

Data catalog change timestamp type fields format
answered 01-12-2020 07:06:36 -0500

Hello, Currently when we query views containing fields of type "timestamp" in our Data Catalog, the data in these fields is formated in an odd way like the following example: Mon Dec 05 09:52:00 2005 When querying the same view through the VDP...

Answers: 3

formatdate Data Catalog formatting timestamp

How to have all view statistics regarding to how many times queries have been thrown to each view
answered 01-12-2020 06:39:27 -0500

I would like to know how to have all view statistics regarding to how many times queries have been thrown to each view. https://community.denodo.com/docs/html/browse/6.0/vdp/administration/optimizing_queries/cost-based_optimization/gathering_the_stati...

Answers: 1

DENODO view statistics Denodo view

How to schedule a CSV export to S3?
answered 01-12-2020 05:53:41 -0500

Is there a way to schedule a CSV export to AWS S3 location? Any example

Answers: 1

S3 Export

Custom wrapper EBCDIC sources
answered 01-12-2020 05:35:00 -0500

Hi, we have as a source an EBCDIC file and we have to configure a custom wrapper to read it. Do you know best practices or do you have any experience with this format file or similar one?

Answers: 1

EBCDIC custom wrapper

LDAP Datasource & Base View Creation
answered 30-11-2020 16:35:15 -0500

System Distributor ID: Ubuntu Description: Ubuntu 18.04.5 LTS Release: 18.04 Codename: bionic Denodo Version: 8 (denodo-install-8.0-ga-linux64) Updates: None Issue Ldap datasource gets created fine & 'Test Connection' succeeds. But the creatio...

Answers: 1
Related to: LDAP authentication best practices

LDAP openldap

Migrating vql scripts to other environments
answered 30-11-2020 04:15:47 -0500

I created two data sources one is for delimited file source and another is for filesystem custom wrapper. For each data source I created one base view. Then I create one derived view by joining those base views. In the derived view I have specified whe...

Answers: 1

Flatten array with column of index of value in array
answered 27-11-2020 13:33:46 -0500

Hi, I have a view in which there is an ID column, and a column with an array in that I want to flatten. This of course flattens the array so each value in the array becomes a new row, with the same ID column across multiple rows. What I want to be ab...

Answers: 1

Refresh token not fetched when connecting to Azure Blob Storage
answered 27-11-2020 11:18:23 -0500

Hi all, I followed the steps accoring to the Denodo Data sources guide (https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Azure%20Blob%20Storage%20from%20Denodo) and obtained the OAuth2.0 credentials. Everything worked fine but a...

Answers: 1

Azure azure blobl storage Web Service OAuth 2.0 Refresh Token