...

SIS integration can begin as soon as a college has enabled User Authentication. Colleges can also prepare draft SIS extract files for Ex Libris to review at any time. SIS integration must be enabled by May, however, colleges are encouraged to begin as soon as possible to allow the maximum amount of time for testing.

Activities

Review SIS Integration for IT Meeting Recording

Ex Libris / Ontario College SIS Integration for IT Personnel - Feb 18, 2022 - Meeting Recording: Feb. 18 - Ex Libris / Ontario College SIS Integration Meeting

Review Technical Documentation

a) User Management in Alma

• https://developers.exlibrisgroup.com/alma/integrations/user-management

• External Systems – Configuring Integration Profiles

b) Details on SIS integration (extract, xml build)

• https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch

• Alma Integrations with External Systems – Student Information Systems

• Developer Network: SIS Integration

c) Data dictionary (xsd for version 2)

• https://developers.exlibrisgroup.com/alma/apis/xsd/rest_user.xsd?tags=SIS

• SIS User Data Dictionary + Sample XML File

Note: User group code definitions come from the Library’s current ILS, rather than those listed in the xsd link above.  "Mandatory" fields are marked.

...

e) Sample XML file from Loyalist. This file was populated with student information from Banner. The job ran nightly, placing the updated student file in an SFTP folder for upload to Loyalist’s instance of Alma. f) Technical Requirements for Alma and Discovery Implementation

• Includes list of CA IP addresses for whitelisting

Review Shared Information From Other CLSP College IT and Library Staff

a) From Humber Library Staff

If a library chooses to have custom configurations in Alma, they may want to create a sample XML extract of this data to provide to their IT department. The document below includes instructions for extracting a sample user from Alma for IT staff.

b) From Algonquin IT Staff

I will share some details below that I hope are helpful for your efforts:

• SIS: at Algonquin our SIS is an in-house system, not Banner.

• Integration tool: to build a daily process that outputs and uploads the XML file to ExLibris, the tool we are using is SSIS (SQL Server Integration Services). In addition, we are using this third-party connector within SSIS to export the XML in the format that ExLibris expects: https://zappysys.com/products/ssis-powerpack/ssis-xml-destination/

• The tools above are part of the system integration stack we already use for many other integrations, not just Ex Libris.

• So far progress is going well, we can produce an XML file that was submitted to ExLibris for review, and they provided some minor feedback.

• I am happy to share more info and code, but the problem I see is, unless you are also using SSIS, and the Zappy connector, our code will not really help you.

Please let me know any further questions, and if there anything else I can help you with,

Max Figueredo

Data Architect

...