You can translate the question and the replies:

Can we query Denodo Base view and create csv data extract for the query by using unix script?

Can we query/trigger Denodo Base view and create csv data extract for the query output by using unix script?
user
28-07-2021 18:05:41 -0400
code

1 Answer

Hi, Yes, you can query Denodo Base views using shell scripts. This will need utilizing Denodo JDBC driver (denodo-vdp-jdbcdriver.jar) and a similar question is answered in this [link](https://community.denodo.com/answers/question/details?questionId=9060g000000TRAeAAO&title=Accessing+Denodo+VDP+through+Linux+Shell). If this doesn’t need to be fully integrated to the shell script, you can create a Denodo Scheduler job to export data in CSV. For setting up this job, 1) Create a new VDP Scheduler job by selecting “New Job > VDP” in the Denodo Scheduler. 2) Under “Extraction section” tab, choose the appropriate Data Source and add your query under “Parameterized Query” 3) Under the “Exporters section” tab, Select “New Exporter>CSV”. 4) Automate the execution of the job in the “Triggers section” tab, where you can define a CRON expression to initiate the job at certain intervals. Also, if you want to launch this job via command line, you can refer to the [Q&A response](https://community.denodo.com/answers/question/details?questionId=90670000000XctKAAS&title=Shell+script+Schedule) here. Hope this helps!
Denodo Team
29-07-2021 16:59:20 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here