- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Pull daily record from Database using date.
- Labels:
-
Apache MiNiFi
-
Apache NiFi
Created 02-03-2022 02:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am still a beginner in using NIFI.
I would like to query a database & pull record on a daily basis. And each day record would be converted to CSV and write to a directory.
I have checked this method:
But i would like to know if there is any other simpler way of doing it.
Thank you so much.
Created 02-05-2022 04:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can set the run schedule of the processor to cron driven [1] and give it your cron expression from there.
Note that this cron is not the typical OS cron syntax and its based off quartz cron scheduler [2]
To build a cron expression this is a good online tool to do so [3]
[1] https://nifi.apache.org/docs/nifi-docs/html/user-guide.html#scheduling-strategy
[2] http://www.quartz-scheduler.org/
[3] https://www.freeformatter.com/cron-expression-generator-quartz.html
