You can translate the question and the replies:

Export Denodo View

Are there any APIs with which I can export data out of the views into a sql table or a csv file? Also wondering if this can be done in a schedule.
user
24-11-2021 14:02:31 -0500

1 Answer

Hi, In order to export the view data in a CSV file / JDBC source, you can use the tool Denodo Scheduler. In Scheduler, a job can be created and in the Extraction section of the job, a query to fetch the data from the VDP view can be provided. Further, in the Exporter section, you can configure the desired exporter to export the data and if you want to schedule the job periodically you can also configure the Trigger section based on which the job will get executed. For more information, you can take a look at the “[Configuring New Jobs](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/configuring_new_jobs)” section under the Scheduler Administration Guide. Additionally, if required, you can also use** Scheduler REST Client API **to start the configured jobs or perform any other desired operations via API. For more information about Rest-Client API, you can take a look at the “[Scheduler REST Client API](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/developer_api/rest_api/rest_api)” section under Scheduler Administration Guide Hope this helps!
Denodo Team
25-11-2021 01:27:13 -0500
You must sign in to add an answer. If you do not have an account, you can register here