Alert Configure after Detect Changes in Data Source (Oracle DB)

Hi team, I already knew that we can detect changes in data sources as shown in the following help page. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources After detecting the changes, I WANT to send the changes' metadata to my application directly. I noticed in the following page that we can configure alert notification https://community.denodo.com/kb/view/document/Configuring%20alerts%20in%20Denodo?category=Operation **BUT if it is possible to send the changes directly to my application to use?** ( such as send the changes metadata as JSON, XML, etc, or just CSV file not as the help page showed attaching to the email ) Thanks, Wei
user
09-10-2019 09:44:44 -0400

4 Answers

Hi I was able to to get the desired results into the CSV format by doing the following steps: * Create base views based on top of [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#get-views). * Join the 2 base view to create the derived view as mentioned in the [How to detect changes in data sources](https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources) Knowledge Base article. * Create a scheduler [job](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/jobs/jobs) (VDP type) to extract the data from the corresponding Virtual DataPort Server in the Scheduler administration tool. * Specify the query i.e the required view in the[ extraction section](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section#vdp-extraction-section). * Choose the CSV [exporter]() and save the job. * After the successful execution, you can find the file <DENODO_HOME>/work/scheduler/data/csv You can also get the above information in JSON or XML format by publishing the above view as the[ Rest web service](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services#publishing-rest-web-services). Hope this helps!
Denodo Team
10-10-2019 07:13:46 -0400
Hi team, Thank you for the answer. One more question, what is the minimum frequecency of the scheduler job? for example, once per minute, or once per second, etc > Create a scheduler job (VDP type) Thanks, Wei
user
10-10-2019 09:30:41 -0400
Or if the minimum frequency couldn't less than 1s, does any other realtime method provided by Denodo? Cause we want to send the source changes to application by real time.
user
11-10-2019 00:21:42 -0400
Hi, The minimum frequency of the Scheduler is 1 second. For now, the Scheduler cannot be used to send\stream the data at the real-time. For your scenario, I would suggest you to use the application which can query or stream the Denodo Platform's metadata at real-time. Hope this helps!
Denodo Team
18-10-2019 08:06:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here