The Integration Pack for Student Information System (IPSIS) platform
The Integration Pack for Student Information Systems (IPSIS) platform is an integration platform in Brightspace that consists of common components and a collection of products that allow you to import information from your organization's information system to Brightspace, for example, your organization structure, users, and enrollment information. Once that information is imported into Brightspace, you can continue to update your information system and import that information to Brightspace using the IPSIS platform.
Supported information systems
The IPSIS platform integrates with the following common types of information systems:
- Student Information Systems (SIS) - A software tool used by educational organizations to manage students, courses, and enrollments.
- Human Resource Systems (HRIS) - A software tool used by corporate organizations to manage employees and their data.
- Learner Information Systems (LIS) - A software tool used by educational organizations to manage the registration of student enrollments.
Components and products in the IPSIS platform
Under the IPSIS platform, there are common components and several products with unique features to integrate your specific information system with Brightspace. The collection of components and products are:
- D2L Standard CSV – Used for integrating with SIS/HRIS systems by using D2L-defined Comma-Separated Value (CSV) files.
- Ellucian ILP – Used for integrating with Banner or Colleague systems, based on LIS specifications.
- OneRoster CSV or OneRoster REST – Used for integrating with K-12 information systems that support the IMS Global Learning Consortium’s OneRoster specification.
- LIS v2.0 Adapter - Used for integrating with information systems that support the IMS Global Learning Consortium's LIS specification.
- SIS Course Merge - An interface in Brightspace used to enable instructors to merge and unmerge multiple IPSIS-processed courses into and out of one parent course offering.
- Section Association Interface (UI) - An interface in Brightspace used to manually manipulate relationships between enrollable courses or sections in an SIS and course offerings in Brightspace.
- IPSIS Administration Interface (Admin UI) - An administration interface in Brightspace used for configuring and reviewing the status of SIS integrations with Brightspace.
OneRoster is an IMS standard designed to allow secure sharing of class rosters and related data between a student information system (SIS) and any other system. The OneRoster standard supports spreadsheet-style (CSV) export-import as well as direct system exchanges using REST API’s. This administration guide focuses on the REST specification.
Before you use OneRoster REST 1.1
D2L supports the IMS OneRoster v1.1 specification and recertifies against the IMS Global product certification suite yearly. D2L supports the following Conformance Certifications:
- REST Data Provider Gradebook Push Core
- REST Data Consumer Rostering Core
The Brightspace implementation of the OneRoster v1.1 specification lets administrators schedule data to be pulled from their SIS to populate the required roster related data (schools, classes, users, enrollments, etc.) in the Brightspace platform. The new IPSIS OneRoster REST user interface includes a schedule to allow administrators to configure the time of day when the data pulls occur. Additionally, for an SIS partner supporting the Gradebook service, administrators can set the grades to be returned with the daily data sync and/or allow a faculty member to initiate a manual sync.
Endpoints used
| Type |
URL |
|---|
| GET |
ims/oneroster/v1p1/academicSessions |
| GET |
ims/oneroster/v1p1/classes |
| GET |
ims/oneroster/v1p1/enrollments |
| GET |
ims/oneroster/v1p1/orgs |
| GET |
ims/oneroster/v1p1/orgs/{id} |
| GET |
ims/oneroster/v1p1/users
|
How OneRoster REST is mapping to Brightspace
Below are the mapping values between a OneRoster object type and a Brightspace object type
| One Roster |
D2L Brightspace |
|---|
Academic Sessions
|
Org Units* |
| Orgs |
Org Units* |
| Schools |
Org Units* |
| Courses |
Course Template
|
| Classes |
Course Offering & Course Section |
| Users |
User
|
| Enrollments |
Enrollment
|
*Org unit types are typically custom org unit types that can be mapped during the configuration process.
Academic Sessions
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
| sourcedId |
|
N/A |
Y |
| status |
active or tobedeleted |
Create/Replace or Delete |
Y |
| dateLastModified |
YYYY-MM-DDTHH:mm:SS.sssZ |
N/A |
Y |
| metadata |
N/A |
N/A |
|
| title |
|
Org Unit Name and Org Unit Code |
Y |
| startDate |
YYYY-MM-DD |
Exposed for academic session in gradebook and course offering |
Y |
| endDate |
YYYY-MM-DD |
Exposed for academic session in gradebook and course offering |
Y |
| type |
Semester, Term, Grading Period, SchoolYear |
Org Unit Type |
Y |
| parent |
N/A |
N/A |
N/A |
| Children |
N/A |
N/A |
N/A |
| SchoolYear |
N/A |
N/A |
N/A |
Orgs
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
SourcedId
|
|
N/A |
Y |
Status
|
active or tobedeleted
|
Replace or Delete |
Y |
DateLastModified
|
YYYY-MM-DDTHH:mm:SS.sssZ |
N/A |
Y |
MetaData
|
N/A |
N/A |
|
Name
|
|
Org Unit Name and Org Unit Code |
Y |
Identifier
|
|
Org Unit Code (If provided) |
N |
StartDate
|
YYYY-MM-DD |
N/A |
Y |
EndDate
|
YYYY-MM-DD |
N/A |
Y |
Type
|
District, Department, Local, National, School, State |
Org Unit Type |
Y |
Parent
|
|
Parent Org Units |
Required to create org structure |
Children
|
N/A |
N/A |
N/A |
Courses
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
SourcedId
|
|
N/A |
Y |
Status
|
active or tobedeleted
|
Active |
Y |
DateLastModified
|
YYYY-MM-DDTHH:mm:SS.sssZ |
N/A |
Y |
MetaData
|
N/A |
N/A |
|
| Title |
|
Org Unit Name and Org Unit Code |
Y |
| SchoolYear |
|
Parent Org Units |
N |
| CourseCode |
|
Org Unit Code (If provided) |
N |
| Grades |
N/A |
N/A |
|
| Subjects |
N/A |
N/A |
|
| Org |
|
Parent Org Units |
Required to create org structure |
StartDate
|
YYYY-MM-DD |
N/A |
|
EndDate
|
YYYY-MM-DD |
N/A |
|
| SubjectCodes |
N/A |
N/A |
|
| Resources |
N/A |
N/A |
|
Classes
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
SourcedId
|
|
N/A |
Y |
Status
|
active or tobedeleted
|
Active or Inactive |
Y |
DateLastModified
|
YYYY-MM-DDTHH:mm:SS.sssZ |
N/A |
Y |
MetaData
|
Not Mapped |
| Title |
|
Org Unit Name and Org Unit Code |
Y |
| ClassCode |
|
Org Unit Code (If provided) |
N |
| ClassType |
N/A |
| Location |
N/A |
| Grades |
N/A |
| Subjects |
N/A |
| Course |
|
Parent Org Units |
Y |
| School |
|
Parent Org Units |
Y |
| Terms |
|
Parent Org Units |
Y |
| SubjectCodes |
N/A |
| Periods |
N/A |
| Resources |
N/A |
Users
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
SourcedId
|
|
OrgDefinedId |
Y |
Status
|
active or tobedeleted
|
IsActive |
Y |
DateLastModified
|
YYYY-MM-DDTHH:mm:SS.sssZ |
N/A |
Y |
MetaData
|
Not Mapped |
| UserName |
|
UserName |
Y |
| UserIds |
Not Mapped |
| EnabledUser |
|
IsActive |
Y |
| GivenName |
|
FirstName |
Y |
| FamilyName |
|
LastName |
Y |
| MiddleName |
|
MiddleName |
N |
| Role |
|
Role In Org |
Y |
| Identifier |
|
OrgDefinedId (If provided) |
N |
| Email |
|
ExternalEmail |
N |
| Sms |
|
N/A |
N |
| Phone |
|
N/A |
N |
| Agents |
|
Brightspace Parent & Guardian |
N |
| Orgs |
Upper Org Unit Enrollments (With Role in Org) |
| Grades |
N/A |
| Password |
|
User Password |
N |
Enrollments
| OneRoster |
Supported Values |
Used by Brightspace for |
Required |
|---|
SourcedId
|
|
N/A |
Y |
Status
|
active or tobedeleted
|
Active |
Y |
DateLastModified
|
YYYY-MM-DDTHH:mm:SS.sssZ |
|
Y |
MetaData
|
N/A |
| User |
|
User to Enroll |
Y |
| Class |
|
Course Offering & Section to Enroll in |
Y |
| School |
N/A |
| Role |
|
Role |
Y |
| Primary |
N/A |
| BeginDate |
N/A |
| EndDate |
N/A |
Assumptions and Limitations
Assumptions
D2L can work with any SIS that supports OneRoster 1.1 REST and is certified with IMS Global or working towards their certification.
REST Process
- Scheduled runs run from the previous run date of the data extract to the start date of the current data extract. If this is the first run, it acts like a sync operation and runs with no start date to the date range.
- There is an option to trigger a run manually from the previous run date, from a specific date or for all records in the system
- Call Order: The order that the various endpoints or consuming the various files are called in.
Academic Sessions
Orgs
- Schools
Courses
Classes
Users
Enrollments
Limitations
- Records with a status of tobedeleted are only deleted if the child is deleted.
- Enrollments into upper org units that were created before the June 2024/20.24.6 release cannot be unenrolled via the OneRoster integration.
- Enrollments that were created manually in Brightspace cannot be unenrolled via the OneRoster integration.
- Unsupported characters: there are several characters that are not supported in the Brightspace Org Unit Code. These characters are replaced with an underscore (_). Unsupported Characters: \ : ? “ ” < > | ‘ # , % &
- Truncations: The max length for the Org Unit Code in Brightspace is 50 characters. If it exceeds this length, it is truncated in the UI.
Configuration options for OneRoster REST
You will work with your Brightspace Implementation Consultant to set up your OneRoster REST source system. Brightspace automatically defaults to your most common settings. However, these settings can be edited at any time with the appropriate permissions.
Before the source system can be configured, make sure you have the following items completed:
General Requirements
Contact your OneRoster representative to obtain your API information. You will need:
- Endpoint URL
- Consumer Key
- Consumer Secret
- OAuth Signature Method = SHA-256
Configuration
After the initial set up, you can update the configuration of your OneRoster REST source system:
- From the Admin Tools menu, select IPSIS Administration, select the Configuration tab
- Credentials provided during initial set up will appear first, these credentials can be edited if required.
- Source System fields:
- SIS Name: The SIS Name field is editable and is recommended to be kept up to date.
- Scheduled Updates: The time that Brightspace will automatically sync with the SIS. It is recommended that this process is completed overnight.
- Overwriting Brightspace: Granular choices to identify which fields in Brightspace your SIS can overwrite.
- People
- SIS Role Mappings: This section contains the OneRoster specific role to map SIS role names to Brightspace role names. Teacher and Student roles are included by default, but they can be deleted. The following are the roles available in OneRoster:
- Administrator
- Aide
- Guardian
- Parent
- Proctor
- Relative
- Student
- Teacher
To add additional SIS specific role names to map to Brightspace roles, click + Add Role.Note: If the SIS sends a role that is not configured, it results in an error and the user cannot be created.
- Map SIS Entries to Existing Users: Provides the option to map SIS entries based on username or OrgDefinedId to existing users that were created outside of the SIS (manually, bulk operations, API, etc.). If mappings are off, duplicates may be created.
- Courses and Sections
- Courses and Sections - Mappings: This section contains the OneRoster specific org unit types to map SIS orgs to Brightspace org names.
- Click + Add Org Unit Type to add additional SIS specific org unit names. The following Org Unit Types are required for ClassLink:
- SIS Orgs
- District
- School
- Local, National, State, and Department are optional
- Academic Session Type
- Semester
- Term
- SchoolYear
- GradingPeriod
- SIS Group
- Course Offering
- Course Section
- Course Template
- Section Association
- Deletion: Provides two options on how a tobedeleted status affects an org unit in Brightspace.
- Do Nothing – the org unit mapping will be deleted from IPSIS mappings, but the org unit will remain unchanged in Brightspace
- Inactivate course offering – the org unit mapping will be deleted from IPSIS mappings, the course offering will be marked inactive in Brightspace, section and enrollments will remain
- Map SIS entries to courses and sections: Provides the option to map SIS entries based on org unit code to existing org units that were created outside of the SIS (manually, bulk operations, API, etc.). It is not recommended to turn these on for any org units created by your SIS unless you confirmed the codes are unique across schools and school years. If they are not unique, the SIS may overwrite existing org units with data from other org units.
- Course Content: Provides the ability to copy course content from a master course or a course template to the newly created course. Select Yes and choose one of the following:
- If Find an Org Unit to automatically copy from based on specified criteria? is not selected, content is copied from a Master Course Offering to the sibling Course Offering when the Master Course Offering and Course Template share the same Org Unit Code
- If Find an Org Unit to automatically copy from based on specified criteria? is selected, you can choose from two options:
- Parent course template of the new course
- Content is copied from the parent Course Template to the new child Course Offering
- Sibling course where the Org Unit Code matches the parent template. Content is copied from the source course offering to the new child Course Offering based on the source course being manually added to Brightspace with the same org unit code as the parent template.
- Course Offering Dates: Allows you to use academic session information for course offering start and end dates. This check box is set to off by default. This option allows you to choose if academic session (semester, term, school year, or grading period) dates are associated to the course offering (this option defaults to term). The start date and end date of a course can also be offset by a specified number of days. If multiple academic sessions are set for a single course offering, the first Academic Session received from the SIS will be used for the start and end dates.
- Unenrollment: Provides the option to unenroll users from sections and courses based on the enrollment End Date provided by the SIS, and the option to unenroll users from SIS Orgs if they’re no longer associated with them in the SIS.
- Departments, Semesters, and Other:
Map SIS entries to existing org units: Provides the option to map SIS entries based on org unit code to existing org units that were created outside of the SIS (manually, bulk operations, API, etc.). It is not recommended to turn these on for any org units created by your SIS unless you confirmed the codes are unique across schools and school years.
- Once complete, select Save Configuration.
- When you’re ready to sync data. Navigate to the IPSIS Administration - Dashboard, choose the down arrow beside Run Update Now – Resync all SIS Records to sync chosen data from ClassLink.
Note: you may need to do this twice if ClassLink sends the District after sending the Schools in the org end point (it is expected that District is sent first).
Troubleshooting
The Dashboard provides the processing status of the latest batch. Both the Dashboard and Batches pages show a final indicator if the batch completed successfully or with errors. Each batch has a quick link to the Audit Log and if completed with errors to Error Messages.
Review all logs to verify all records processed as expected. If error messages were logged, expand the error to review the metadata captured to identify the error, correct the data in your SIS and either wait until the next day for the Scheduled Update or request an update from the Dashboard. The goal is to have the runs completed without error.