Completed Projects

Time Tracking Integrations

  • Obtain leave request information from Operational Data Store (ODS) via Mule platform to UCSF IT PMO instance of Workfront (using Workfront APIs).
  • Completed June 2017

Cross Campus Enrollment System (CCES) - Home Campus

  • The Cross-Campus Enrollment System is a UC-wide project to provide an efficient means of intercampus communication centered around a student’s enrollment in and completion of a course offered by another UC campus.
    • UCSF is participating as a "home" campus with UCSF graduate students taking undergraduate courses at other "host" campuses. As such the scope of this project is to implement a limited set of interfaces in three functional areas.
  • Completed March 2017

Ilios to E*Value

  • Ilios provides APIs that can be used to extract data from Ilios and E*Value provides APIs to input data into E*Value.
  • This project, for the Office of Education & Instructional Support in the School of Pharmacy, used these APIs to develop an interface from Ilios to E*Value via the Mule Platform to populate Schedule information in E*Value. This replaced a very manual process for creating course and lecturer evaluations in E*Value.
  • The Ilios APIs are used to gather course, session and learner group information. This data is used by the ESB which calls the E*Value APIs to automatically create course and lecturer evaluations in E*Value for Ilios sessions of type Lecture.
  • Completed February 2017

StateServ Interface

  • The scope of the StateServ (DME) Interface project is to implement an interface on the MuleSoft Platform to accept HL7 ADT message from Cloverleaf and send it through webservice call to StateServ (DME).
  • Completed November 2016

Student Information System (SIS)

  • SIS provides schools, terms, departments, subjects, courses and course enrollment data as separate RESTful web services.
  • Integration Services buillt APIs to expose this information.
  • The Collaborative Learning Environment (CLE) uses the APIs.
  • Completed November 2016

ServiceNow Integration

  • Develop a generic API that will use the existing ServiceNow REST/SOAP API integration to create incident tickets in ServiceNow.
    • Applications commonly generate alert e-mails when they cannot connect to a specific service or server. Each application will have a threshold that once reached, requires an incident ticket to be generated in ServiceNow so that the appropriate team can investigate and resolve the issue. The generic API will automate that process and enable applications to create the incident tickets in ServiceNow and utilize existing PagerDuty Escalation procedures
  • Completed August 2016

Archibus (Space Management System)

  • Developed interface to provide employee and employee location to Archibus from Enterprise Directory Service (EDS) via Java Message Service (JMS).
  • Developed interface to receive employee location from Archibus, publish to JMS, update Campus Locator System (CLS).
  • Developed API with building metadata from Archibus (building id, floor, room, room-split) for other systems (Service Request System (SRS) and Directory Self Service) to use (will simplify entry of addresses and improve accuracy of address information).
  • Completed April 2016

Benefit/role fields to Salesforce's ExactTarget Marketing Cloud Platform

  • Provided 5 benefit/roles-related fields in Operational Data Store (ODS) that are not in Enterprise Directory Service (EDS) to enable Benefits HR, the University Relations group and others to send more targeted e-mails to groups at UCSF.
  • Completed September 2015

Enterprise Directory Service (EDS) to PeopleSoft Financials

  • Keep PeopleSoft in sync with changes to people records made in EDS and support the de-provisioning of users in PeopleSoft.
  • Pilot Project for the ESB
  • Completed March 2015

Platform as a Service (PaaS)

  • The Integration Services team worked with the Athena team on a pilot to link Apex, via button and Information Health Exchange - Retrieve Form Data capture (IHE RFD), to SalesForce/OneSource Surgical/Pathology Checklist form which captures data in Salesforce
    • Completed July 2017
  • The Integration Services team worked with the Advance team in the ITS Enterprise Applications group to help them proxy their CV API on the UCSF API Portal.
    • Completed November 2016
  • The Integration Services team worked with a research team from the Memory and Aging Center (Department of Neurology) on a project that to use the Mule Platform to support functional monitoring of study participants through wearable devices and mobile phones.
    • Completed August 2016

Mule Platform

  • Mule platform move to Quincy Data Center
    • Development servers - May 2017
    • Stage and production servers - June 2017
    • Completed June 2017
  • Platform upgrade from MuleSoft 3.7.2 Enterprise Edition (EE) to 3.8.3.
    • Upgrade to provide additional MuleSoft functionality to users and admins, synch the API gateway and Mule ESB core runtime engines to a single runtime version (reducing maintenance overhead), and improve application security.
    • Completed February 2017
  • API Portal Organization:
    • Consolidate the current the two master organizations representing test environments (e.g. Dev, Stage) into one master organization representing all non-production environments - Completed
    • Configure both master organizations (e.g. non-production and production) to leverage environments to allow for maximum flexibility in managing APIs - Completed July 2016
  • Implemented Single Sign On (SSO) for API Portals
    • Completed April 2016
  • Upgraded production cluster of Mule ESB (worker nodes) and the MMC from version 3.5.2 to 3.7.2 (Enterprise Edition)
    • Completed November 2015