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

RealTime Activity from Notes to MS SQL Server 2000

I am new to LEI. We are trying to create a RealTime Activity from Notes to MS SQL Server 2000. We were able to figure out many things like Direct Transfer and some RealTime Activities. Right now, we are stocked in configuring Collapse/Expand connection in one RealTime Activity. When updating a Notes document multi-value field, it append/s row/s instead of updating the rows in SQL Server table. Is there something we missed? Please help!
You must not be specifying the proper Writeback key(s). When you define the C/E MetaConnection you specify the Grouping Keys, which seems fairly logical - "the shared key which groups multiple values." However, the "Additional Write Keys" is considerably less intuitive. This field must contain the field(s) or column(s) that uniquely identify each multi-value set of fields on the Notes document. Make sense? Still kinda confusing, huh!?!? Here's an example: Let's say you have Notes documents containing book orders with three multi-value fields that you want to expand so that each Nth value gets mapped into a row in SQL Server. For each order you have an Order Number, which is used as the Grouping Key. For each book on the order you have a unique key in the ISBN and the multi-value data contains ISBN, quantity and selling price (since discounts might be applied on a per-order basis.) In this example the ISBN is the Writeback key. LEI will then use the Order Number to find the Notes Document and the Order Number and ISBN together to find the right (Nth) value in SQLServer.

Note: You might try using DECS which offers the exact same functionality as the LEI RTNotes Activity (shares the same code base). This would eliminate needing LEI running on your production application.

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.

-ADS BY GOOGLE

SearchWindowsServer

Search400

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

SearchDataCenter

SearchContentManagement

Close