You can translate the question and the replies:

Automate Source Refresh

Hi Denodo Team / Community, Is it possible to automate your source refresh on a scheduled manner? Thank you and more power.
user
18-07-2019 05:30:07 -0400
code

4 Answers

Hi, In Denodo Virtual DataPort, you can utilize the inbuilt stored procedures [GET_SOURCE_CHANGES](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_changes#get-source-changes) and [GET_VIEWS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) to detect the differences between the current schema of a base view and its underlying data source. In Virtual Dataport, if you modify the base view it will show the list of affected dependent views. So, you must select which views you want to propagate these changes. As of now, It is only possible to do source refresh for each base-view by choosing the “Source Refresh” option available on the “Edit” tab of the base view in the Virtual Dataport. For more information, you can also refer the following knowledge base article[ How to detect changes in data sources](https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources) and the document[ Source Refresh](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh) of the Virtual DataPort Administration Guide Hope this helps!
Denodo Team
19-07-2019 03:24:55 -0400
code
Has this situation changed? This is a common requierement: to sinchronize the source table with the corresponding views, when new attributes are added, to make them "available". Regards
user
18-05-2021 06:39:46 -0400
Hi, Currently, there’s an enhancement request to add support for what you have described that’s currently being considered for a future update of the Denodo Platform. This feature allows the Virtual Dataport Server to automate the source refresh to propagate the changes to the base view. Hope this helps!
Denodo Team
07-06-2021 00:34:16 -0400
code
Hi, I have a similar problem, but could not find any info regarding a new feature for automated source refresh. Can you provide me with a bit more info regarding tools or commands for automated source refresh? Thanks!
user
11-01-2023 04:48:40 -0500
You must sign in to add an answer. If you do not have an account, you can register here