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

Tools for data integration when copying Notes to Oracle

I have a Notes DB with about 400 documents. Once a month I want to copy a totals field out of each document to an Oracle table. I'm a rookie at data integration. So, my initial research shows lots of possible methods available. For example, LS:DO, JDBC, DECS, LEI, LSX LC, etc. I'm thinking DECS looks quickest and easiest. I know LotusScript but not Java, and we do not own LEI. What are your thoughts?
I'll start by offering a little clarity about the tools/technologies you mentioned: DECS is for real-time only, i.e. I create, delete or edit and save a document from a Notes client or Web browser (some UI interaction) and something happens to a backend database (an insert, delete, or update, respectively). JDBC and the LC LSX are programmatic interfaces (don't bother with LS:DO; Lotus only continues to ship it for legacy support). LEI does a variety of batch processes, plus real-time (same as DECS) and polling. Since you know LotusScript I suggest that you look at the LC LSX. I recently wrote an article for the Advisor Expert on Lotus Notes & Domino R5 with details on how to use the LC LSX that you should find helpful.

Dig Deeper on Lotus Notes Domino Administration Tools

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 ...