Cloud Pak for Integration

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

You can use there TimerNode, but it would be 5 minutes from when the flow starts.  So if the Pod restarts, it will be 5 minutes from the restart.  Probably not ideal.  You could use OCP's Cron to kick off a flow for you.  Or you could use a little java program under OpenLiberty to poll on the times you want using the @Service annotation and TimerService.

Brian

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

Hello
Will it not trigger immediately on the restart, then trigger again after 5 minutes?

Kjetil

You can use there TimerNode, but it would be 5 minutes from when the flow starts.  So if the Pod restarts, it will be 5 minutes from the restart.  Probably not ideal.  You could use OCP's Cron to kick off a flow for you.  Or you could use a little java program under OpenLiberty to poll on the times you want using the @Service annotation and TimerService.

Brian

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

You could use ACE designer with a scheduler and also use Oralace database to do a check. Scheduler could configure whether invoke the flow at first start as shown below:

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

Hi @Gang Wu 

Is there even a chance to configure the scheduler without using the web based ACE designer but the toolkit instead?
How to configure such a scheduler in an automated way without using the web based UI?

Kind regards
Jan

You could use ACE designer with a scheduler and also use Oralace database to do a check. Scheduler could configure whether invoke the flow at first start as shown below:

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

There are lots of connectors in the Designer that are not in the Workbench and some in the Workbench that are not in the Designer.  What you can do is create a Java node that gets executed when the Flow starts.  You can then use java.util.Timer  to set a schedule the timer.

Brian

------------------------------
Brian S Paskin
Sr. Technology Engineer
IBM Cloud Engineering

Original Message:
Sent: Tue May 09, 2023 06:11 AM
From: Jan Frederik Sorge
Subject: Using Timer nodes in ACE in CP4I

Hi @Gang Wu 

Is there even a chance to configure the scheduler without using the web based ACE designer but the toolkit instead?
How to configure such a scheduler in an automated way without using the web based UI?

Kind regards
Jan

------------------------------
Jan Frederik Sorge

Original Message:
Sent: Mon May 01, 2023 03:16 PM
From: Gang Wu
Subject: Using Timer nodes in ACE in CP4I

You could use ACE designer with a scheduler and also use Oralace database to do a check. Scheduler could configure whether invoke the flow at first start as shown below:

------------------------------
Gang Wu

Original Message:
Sent: Tue April 25, 2023 10:58 PM
From: Santhosh Ramanathan
Subject: Using Timer nodes in ACE in CP4I

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

------------------------------
Thanks,
Santhosh Ramanathan
------------------------------

Hi @Gang Wu 

Is there even a chance to configure the scheduler without using the web based ACE designer but the toolkit instead?
How to configure such a scheduler in an automated way without using the web based UI?

Kind regards
Jan

You could use ACE designer with a scheduler and also use Oralace database to do a check. Scheduler could configure whether invoke the flow at first start as shown below:

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?

How we did it in the toolkit was creating a service that schedule runs. So we have a database with last run, when to run, and which integration to run. Then created some code in the service that checks that database for scheduled runs. The service is triggered by the timer node every minute. Simpler way to do it, is by trigger the integration with the timer node, then use an esql node to check if the current time is when you actually want to trigger it. 

Regards,
Kjetil

Hi @Gang Wu 

Is there even a chance to configure the scheduler without using the web based ACE designer but the toolkit instead?
How to configure such a scheduler in an automated way without using the web based UI?

Kind regards
Jan

You could use ACE designer with a scheduler and also use Oralace database to do a check. Scheduler could configure whether invoke the flow at first start as shown below:

Hi,

I have a requirement to poll an Oracle database every 5 minutes to fetch data, Is it possible to use TimerNode in ACE deployed in CP4I environment? if it is possible, what will happen when the pod restarts, will it be able to do the trigger automatically or manual intervention is needed?