Yeah, it is possible to execute a view from a Java application and export the resultset into a CSV file.
I tried doing the below-mentioned steps:
* I configured the connection between my sample java application and Denodo using Denodo’s JDBC driver as mentioned in the previous response.
* From the java application, I called an *‘EXECUTE’* statement, that fetched the data from the data source and the ResultSet came into the java application through the Virtual DataPort.
* For exporting the data(resultset) into a CSV file from the java application, I used [OpenCSV](http://opencsv.sourceforge.net/) and created something similar to the below,
CSVWriter csvWriter = new CSVWriter(new FileWriter("yourfile.csv"), '\t');
java.sql.ResultSet myResultSet = .... ;
Hope this helps!