You can translate the question and the replies:

Automatic detection of source changes

Hi, Is there available a built-in functionality to automatically monitor and notify on changes at sources level? Platform: Denodo 8 Thank you, Dominic Chitac
08-11-2021 08:10:06 -0500

1 Answer

Hi, In Denodo Virtual Dataport, you can utilize the pre-defined stored procedures [GET_SOURCE_CHANGES]( and [GET_VIEWS]( to detect the changes at source level. * GET_SOURCE_CHANGES procedure returns the difference between schema of the base view and schema of the table in the datasource. * GET_VIEWS procedure returns information about all the views. * It is possible to join the GET_VIEWS procedure and the GET_SOURCE_CHANGES procedure to detect which fields of the views have changed. For more information, you could refer to the following Knowledge Base article [How to detect changes in data source]( Additionally, if you want to automate this process, then you can create a scheduler job. For detailed steps, refer to the following Knowledge Base article[ Automating the detection of the changes in scheduler]( I hope this helps!!!
Denodo Team
09-11-2021 05:47:25 -0500
You must sign in to add an answer. If you do not have an account, you can register here