Build a foundation and potential for much greater collaboration in the areas of E-resource troubleshooting, accounts management, and common workflows.

Implement by end of Summer.  Sooner if possible.

ProQuest - Serials Solutions Resource Manager (SSRM)

1.       What is the problem we need to address?

Different systems used at each CUL for various functions is a greater barrier to successful collaboration than simply having different workflows. E-resources work relies heavily on Electronic Resource Management systems and currently, Cornell and Columbia have different systems.  The official delay of Alma implementation has highlights the need to find an interim solution that will allow us to develop more common workflows, identify and perform shared work, and be better able to troubleshoot and solve e-resource problems across 2CUL. 

2.       How will the product address this problem?

SSRM

COUNTER - Data in a common place for joint data analysis, potential shared maintenance, and to take advantage of future enhancements in the 360 COUNTER system.

Consortial RM -

3.       Has a trial taken place? What were the results?

Columbia has been using SSRM (2007) and 360 COUNTER (2009) systems in production.

Cornell has had an active trial to SSRM since September 2013. 

• E-Resources Unit (Liisa Mobley, Rebecca Utz, Sally Lockwood, Heather Shipman, Jesse Koennecke) - Tested the general functionality, workflow features, and data management aspects of the Resource Manager system from a Cornell specific perspective.  The e-resources staff are already familiar with the Serials Solutions staff interface while working with the currently subscribed Serials Solutions services (MARC Updates, 360 Link, and Summon).  Adding ERM features to this existing workflow, rather than in a completely different system will likely show some increased efficiency in some areas of e-resources work.   Members of the unit have reported overall satisfaction with the system and they have unanimously expressed a desire to make the change.  The response from this team suggests that Cornell would consider migrating the the Resource Manager system even if 2CUL were not a factor.
• Discovery & Access Team - Two public interfaces at Cornell rely on the Innovative ERM system currently.  D&A has been considering updating these services to utilize the Integration Layer data or other systems, rather than Innovative.  They are examining this in depth during their February sprint.  It is likely that they will be able to replicate these services using a combination of Voyager data incorporated into the integration layer, the License Term API provided by SSRM, and the SSRM journal A-Z list interface.  More detail about this can be found in Appendix 2: Implementation Details.
• Technical and Data loading group (Gary Branch, Heather Shipman, Peter Martinez, Pete Hoyt, Chris Manly) -
  • Record loads - The group discussed how the current processes for updating Voyager, Innovative, and Serials Solutions will be affected by the transition.  They raised no concerns about making the change to SSRM and feel that any changes that are required in scripts or processes will be minimal.  Heather feels that the record loads into the Innovative ERM account for XXXX hours every month.  This time can potentially be recouped, or used to manage more freqquent updates from SSRM to Voyager.  Either way, we save some time or keep systems in better sync.
  • System hosting - The Innovative ERM system is locally hosted on a Cornell IT server.  This requires regular maintenance and updates in addition to a $2000/year fee.  Resource Manager and 360 COUNTER are cloud hosted systems, managed by Serials Solutions.  The cost for this service is included in the annual fee structure for the SSRM service.
• Usage Statistics group (Rich Entlich, Sally Lockwood) - Looked at the 360 COUNTER product.  Cornell Trial began 1/22.  Detailed feedback may not come until Feb 7 or later.

2CUL has not had an opportunity to trial the consortial aspects of SSRM, the pricing offer provided by Serials Solutions assumes that the first year of work in the consortial environment will be a pilot.

4.       Is the product needed at both institutions?

Yes. Resource Manager and 360 COUNTER already in place at Columbia.  Both products are needed at Cornell to maximize common systems.  Additionally, we propose to add a consortial layer allowing more interactivity between the partner institutions.

5.       What staff will use the product?

• E-Resources - Extensively for workflow, resource management, troubleshooting.
• Selectors - Usage stats, resource information
• Batch processing - Perform batch loads from SSRM to Voyager and other systems.  Also to batch load acquisition data into SSRM.
• Assessment - Usage stats and package information
• Public Services (particularly Interlibrary Loan and E-Reserve) - To look up license permissions.

Implementation Impact (more details in Appendix 2:):

Batch loading

Public Interfaces

Costs (More details in appendix 1: Costs): 

Licensing the products:

SSRM at Cornell - 11,693/year plus one time set up $1969 (includes data population services) and a onetime consultation fee of $3990

360 COUNTER at Cornell - 10,450/year plus onetime set up 688

Consortial -~$14,000 total, split between CULs for first year.  $20,000 total years 2 and on. 

Standard pricing is about 20k for you all but since this is a pilot (and you all are good PQ customers), we can cut that to 8K for the year of the pilot and see how it goes.  There is also an implementation fee of $2,000 and a consulting fee of $3995.  We can create a statement of work to be sure we are aware of what the implementation looks like.  This will allow you to take time to work on the project without limitations and see how it works for you.

Cost recovery opportunities:

• Innovative ERM License fee - currently approximately $7,500-$8,000/year.  This is paid until September 31, 2014.
• Innovative ERM server - Once we get through the migration to the linux VM, our server cost for the III ERM will be about $2000/year as the server is currently spec'd.  (We may need to adjust its provisioning depending on actual performance once it's up and running in production.)  The support contract with III is in the ballpark of $10K/year.  Let me know if you need more specific numbers than that - chris

Staff time for migration - estimations

Columbia position

Batch

Statement from original charge:

Make a specific recommendation on whether to implement the Consortial Version of Serials Solutions at both institutions or hold off on integrating e-resource management and data migration until we have a shared LMS

Summary:

The 2CUL TSI E-Resources Team strongly recommends that 2CUL license and implement the Serials Solutions Resource Manager system at the consortial level.  This will involve Cornell implementing the Serials Solutions RM and 360 COUNTER systems locally as well.

Expectations

• Get the partner libraries onto a common e-resource management system as soon as possible to:
  • Develop and implement joint workflows
  • Organize data for future transition to Alma

Cornell Resource Manager and 360 COUNTER Implementation plan:

• Public Interfaces - Cornell's Database Name and EJournal searches are currently utilizing the Innovative ERM.  These will need to be updated as described in appendix ???.
• Data Migration - Assistance from Columbia staff member

Appendix 1: Costs

Licensing the products:

SSRM at Cornell - $11,693/year plus one time set up $1969 (includes data population services) and a onetime consultation fee of $3990 - Ideally, Columbia staff can participate in this as well to learn about how newer features can/should be used?

360 COUNTER at Cornell - $10,450/year plus onetime set up $688

Consortial - Standard pricing is about $20k for you all but since this is a pilot (and you all are good PQ customers), we can cut that to $8K for the year of the pilot and see how it goes.  There is also an implementation fee of $2,000 and a consulting fee of $3995.  We can create a statement of work to be sure we are aware of what the implementation looks like.  This will allow you to take time to work on the project without limitations and see how it works for you.

Where are we saving costs:

Innovative ERM License fee - currently approximately $7,500-$8,000/year.  This is paid until September 31, 2014. 

Server maintenance for III ERM - Awaiting estimate from Chris Manly

Summary:

SSRM and 360 COUNTER at Cornell

Annual fees:

Appendix 2: Implementation Details

Database Names - 948 field: webfeatdb - subject fields to facilitate browsability by curated subjects.  DRC curates the list.  License terms to be held in SSRM, linked to from appropriate records.

Responsible parties - Discovery & Access Team (interface design and implementation), E-Resource Staff (Record management and license entry)

****eJournals - D&A or Serials Solutions A-Z list?

Batch Loading (Pete Hoyt, Chris Manly), Gary Branch, Heather Shipman, Jesse Koennecke)

Serials Solutions / Voyager / ERM interaction

899 Codes

Consortial System Implementation - The specific details are still being worked out.  The current plan is to replicate Columbia's Resource Manager data to populate the Consortial layer's "parent" 2CUL database, then linking that to the two "child" databases for Cornell and Columbia.  Many resources will match up relatively easily after this first pass as the 2CUL partners have significant overlap in collections.  We will identify project work to match other resources as appropriate.  This may be a great area for Columbia's proposed staff member to work on.