I'm not even close to a Pick expert, but it looks like the D3 (D-cubed) ODBC & DECS/LEI would work if the Domino app server is on the Win32 platform. DECS could be used for the "on-demand" push (configure DECS to perform an update to the Pick System when the Notes document is saved; requires a unique key from the Pick system) and LEI could be used for your nightly batch updates. If you are running your Domino server on AIX (or anything other than Win32) then your option appears to be MQSeries, which is true "middleware" (and can be very expensive). Lotus offers the MQSeries LSX that can be used to communicate with the MQSeries network. (If you're interested in finding out more about the MQSeries LSX let me know, as I have quite a bit of experience using it.)
Dig Deeper on Lotus Notes Domino Administration Tools
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.