Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

About Databases handshaking

stefan_kolev4
Participant
0 Likes
308

Hi,

I have external Oracle database and records in it that should be readed by SAP, afterwards SAP should update the SAP database and to update records as processed into external database. How should be done if the connection between both systems is broken or what will happen if one of them is down ? I need working solution which will exclude duplicating or missing records.

Pls advice !

Thanks in advance !

Stefan

1 ACCEPTED SOLUTION
Read only

brad_bohn
Active Contributor
0 Likes
280

Well, presumably, if you have a job scheduled at certain intervals, and there's no connection, then the job terminates without doing anything and there's no issue? If the SAP system is down, the job doesn't run and picks itself back up on the next run. Are you using a direct connection or a connection to an application via RFC function or web service? The DB Assistant has an alert monitor which will handle checking the connection and notification. You can also check the connection manually by pinging the DB server or using one of the DBCON functions as well before executing your core application code.

1 REPLY 1
Read only

brad_bohn
Active Contributor
0 Likes
281

Well, presumably, if you have a job scheduled at certain intervals, and there's no connection, then the job terminates without doing anything and there's no issue? If the SAP system is down, the job doesn't run and picks itself back up on the next run. Are you using a direct connection or a connection to an application via RFC function or web service? The DB Assistant has an alert monitor which will handle checking the connection and notification. You can also check the connection manually by pinging the DB server or using one of the DBCON functions as well before executing your core application code.