DB Trigger to NiFi

menorah84 — Thu, 25 May 2017 16:46:56 GMT

We have an Oracle DB and we run nightly batch job but when that job would end varies. Now we have a NiFi workflow getting data from this Oracle DB but should not be during the batch job run. How do we turn off/on the entry point processor (say ExecuteSQL) whenever the Oracle Batch job is running/has stopped?

We thought of using Oracle DB trigger and then invoke a HTTP request within that trigger when the job would end, but is there a processor in NiFi where you can put up a simple web service / REST endpoint and then use that to trigger or turn on the ExecuteSQL processor?

Re: DB Trigger to NiFi

MattWho — Thu, 25 May 2017 19:05:18 GMT

@J. D. Bacolod

Anything you can do within the NiFi UI, you can also do via NiFi Rest-api calls. So you could issue a rest-api call to stop specific processors before the batch job is started and then issue another rest-api call to start the processor again after the batch job completes.

https://nifi.apache.org/docs/nifi-docs/rest-api/index.html

Thanks,

Matt

question DB Trigger to NiFi in Archives of Support Questions (Read Only)

DB Trigger to NiFi

Re: DB Trigger to NiFi