automated import of constituent research, notes, etc?

Hello,

I'm looking for other organizations who have developed (or discovered) methods for automating the process of moving constituent/donor intel (marketing data, research, convo notes, etc) into Tessitura. I'm looking for a repeatable, scalable solution that we can apply to a variety of information - internally and externally generated. 

I was asked to research this with regard to Plans, but it seems the data we would want to bring in might reside in a number of places; so I'm interested to hear about any and all solutions that you've come up with.

Thank you!

Stacey Voigt
Database Manager
Santa Barbara Center for the Performing Arts
svoigt@granadasb.org