Problem solve Get help with specific problems with your technologies, process and projects.

Integrating Performance Appraisal Notes app with Oracle HR

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...