Home / Q&A / All Questions

Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Create an empty csv file if a query returns any results
answered 09-12-2019 15:10:25 -0500

Hi Denodo Team, I have a job on the scheduler server running a query, and creating a CSV file with the result of the query. But, in case of a specific field contains NULL values, then the file should be generated as empty. Wthat I have done is to sp...

Answers: 3

Importing flat files using FTP Server
answered 09-12-2019 13:26:49 -0500

How can I connect my vdp with ftp server. I want to import flat files from the server?

Answers: 1

FTP

List all interfaces with field names
answered 09-12-2019 12:12:35 -0500

We're looking to get a list of all our interfaces, with field names, and preferably attributes (ex. data type, max length). The end goal is to allow report developers to be able to search for all interfaces which contain specific field names. Is this p...

Answers: 2

names Interface statistics

Databricks as a Cache store for Denodo
answered 09-12-2019 10:18:26 -0500

Has anyone used Databricks as a Cache store for Denodo? I am able to connect to Databricks cluster successfully but not able to configure it as a Cache.

Answers: 4

How to enable the DENODO REST API's from AWS ? Is that a config under security groups? Need to access the REST service from a different location and using the Public IP by enbaling all access (0.0.0.0/0) is not working.. Simply cant reach the service
answered 09-12-2019 03:50:20 -0500

Dneodo 7 on AWS BYOL

Answers: 1

How to create self-referential data source?
answered 06-12-2019 15:28:28 -0500

Hello Denodo experts, I want to create a base view from query from a self-referential data source..how do I create this self-referential data source? Please advise. Thanks!

Answers: 1

Database Baseview DataSource

Updates failing in scheduler
answered 06-12-2019 02:51:05 -0500

I have designed a VDP job in schdeuler. I have two three columns in the MSSQL table and all three of them are part of primary column. In the exporter section of scheduler job I have set the config as below Delete table contents to false update tupl...

Answers: 2

VDP Denodo Scheduler 7.0 Export MSSQL

Is it possible to write back to a delimited file?
answered 05-12-2019 23:59:12 -0500

Working on denodo 7.0. Is there anyway where a base view created on delimited file (like csv file) can be used to insert data back into file?? Regards, Gopal Krishan

Answers: 1

Copy of the Database / Folder
answered 05-12-2019 23:56:46 -0500

Can we make the copy of the folder or database in the same environment in Denodo 6. The clients doesn't maintain the repository - to handle any changes - planning to make the copy of the existing views and make the changes in one copy which may help t...

Answers: 1

Duplicates

How to get "Result" values from jobs in Scheduler
answered 04-12-2019 12:20:49 -0500

We are trying to get the history detail for each job using the scheduler API. We are able to get the start time using the JobReport.getStartTime p.e. However, we are not able to get the "Result" values (COMPLETE, ERROR etc) for each execution in the ...

Answers: 6

#Scheduler #SchedulerAPI