I normally use the [Extraction option](https://community.denodo.com/docs/html/browse/6.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section) present in the Denodo Scheduler which allows you to configure jobs in the form of a query expressed in server’s query language (VQL). Once the data is extracted using the query present in the extraction job, it can be exported in different formats like CSV, database (JDBC or VDP) or a list.
Another option that Denodo offers is the concept of [Materialized table](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/materialized_tables/materialized_tables) which is a special type of base view whose data is stored in the database where the data is cached, instead of in an external data source. Schema and data of Materialized views are managed from Virtual DataPort.
If this is a one-time need then you can use modifying statements (Insert, update, delete) depending upon the datasource of the base view. Denodo allows updating data on a base view created over the JDBC,ODBC data sources or custom wrappers that were developed to be updateable.
Results of executing these statements in Denodo will modify the data stored in the underlying data source.
Please refer to this [link](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/inserts_updates_and_deletes_over_views/inserts_updates_and_deletes_over_views) to know more about Inserts, Updates and Deletes Over Views and its limitations in Denodo.
Hope this helps !