We have a Performance Appraisal Notes application that we would like to integrate with Oracle HR to pass various fields from Notes to Oracle HR once the appraisal has been approved. Currently the integration is being done manually. We want the HR clerk to hit a button to update Oracle. I'm going to be utilizing two Oracle APIs for this integration to take place.
One is an update of an existing record in Oracle. I'm assuming that I can utilize an "Update" event based on a flag used as a filter so that the update to Oracle doesn't take place every time the Notes document is saved.
The second update is actually calling an API to create a row in an Oracle table. I was thinking I would actually have to create a new document with a different form and inherit the fields that I want to get to Oracle, then create an activity that monitors the "creation" of this second document? Is this the best way to accomplish this?
Have you identified the Lotus tools needed to perform this integration? API calls almost always equate to programming, unless you are using a high-end EAI system. Also, the main suggestion I would like to make is: Be very careful!!! When working with transaction systems and ERP systems, the back-end database can be extremely complex. Be aware that there is a big difference between "Oracle" the database and "Oracle" the ERP system (or pieces of it, like HR). If you have not already done so, talk with your Oracle HR DBAs and find exactly what the rules are for updating the two different sets of data you are referring to here.... See if the Oracle DBAs can provide you with Stored Procedures that performs the update & insert operation with values you provide. If so, then you should be able to automate the process using a DECS Activity that monitors only the appropriate Notes Document Event. And, yes, you can use flags to help filter which documents should be included or excluded in an operation.
Dig Deeper on Lotus Notes Domino Interoperability
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.