Hello Tessitura Users,
We are in the beginning stages of initiating data sharing with our Campus' donor management system, Advance, but there are some concerns due to the fact that we're on a hosted solution. Has anyone else on a hosted solution successfully done this type of data sharing with Advance?
Thank you!
Mandy
We have (Cal Performances at UC Berkeley). What I consider the balance of the work has been borne by UDAR, since they have the larger pool of developers (i.e. > 1). We are in the middle of a multi-stage project to share information in both directions, with Phase 1 in operation and me scrambling to get Phase 2 going.
Phase 1 was really the most important. Since the UC Advance db was the system of record for all campus contributions, our Transaction Processor was having to dual enter everything: first entering and processing the gift into Tessitura, then entering the gift details in "CADS", then coming back from CADS with UC financial and customer codes to enter into custom fields in Tessitura. Phase 1 was the automation of that process. My part was simply to pull together all of the pieces of information UDAR needed for each gift/pledge/pledge payment and then hand it to them for processing. This I did by creating a Custom/Execute endpoint with the REST API that they could access. They can run the endpoint passing in a few parameters (such as transaction start and end dates) and I send back the transactions with added biographical and financial information. Currently we are expected to have flagged customers in our database with correct ids for the customer accounts in CADS, or to create them in in CADS manually if they are missing.
Phase 2 is pulling back limited bio data from CADS that we lack or have a hard time keeping up with in Tessitura. In this case I've created a Custom/ "Data Service" endpoint (or set of endpoints, actually) that correspond to custom staging tables in Tessitura. UDAR can then use these to enter data into the tables, and then it is on me to have procedures (currently in process) to review and then import the various bits of data into the appropriate places in Tessitura.
We are a RAMP client (like, I expect, you) and the only ramifications of that were getting the appropriate server IPs from UDAR and having RAMP whitelist them for API access.
Thanks for starting this conversation. We (UMS at the University of Michigan) are not RAMP but have similar complications in data sharing with the university system.
We process donations in Tessitura, then have hard copies (one sheet per donation) of the details of each gift which we give to the U for them to process in their system - DART.
Our current area of struggle is with plans. We do not want to do dual entry so we need to figure out a way to have the gift officers enter info in one system then transfer it to the other system, preferably with as little work as possible. I've been going through the process of constituent matching (thankfully they have a procedure for this) and ensuring we have DART IDs in Tess and Tess IDs in DART. We've also had them create a lot of accounts in DART to correspond with Tess. It's a start but we haven't come up with a plan for the next phase. Your post, Gawain, gives me some food for thought.