I need to get some piece of data from Oracle database twice per day. For example at 12:00am and 12:00pm. Standard JDBC Receiver channel has no needed settings. It has only "poll interval" without exact time.
I can set up "poll interval" to 12 hours, but this can't guarantee that JDBC receiver channel will works only twice per day. For example after XI system restart JDBC adapter loses time counter. It means that JDBC adapter can starts more than 2 times per day.
I have only one idea at this moment.
I can create ABAP program which can be planned as ABAP job at needed time and with needed period.
This program should send some dummy message to Integration Engine. Integration Engine should start some Integration Process which can read data from Oracle database via JDBC channel.
What else opportunities are?