SIS Data Integration

Overview Many institutions have upgraded to Informer 5 on their campus. If your campus is upgrading to Informer 5, you may want to transition your Student Success & Engagement data feeds from Informer 4 to Informer 5. This can be done entirely by the institution or it can be done by the institution with some assistance from the Watermark team to compare the data feeds b...

Overview This is useful to determine whether an Accelerate query is functional isolated from any issues that may be caused by Connect/Accelerate, or to test query changes locally before updating the Accelerate configuration. CSV Method - Using Apache Drill For institutions using Connect Method 1: CSV, follow these steps to use Apache Drill locally on the Connect server:...

Import  Anticipated graduation date is imported on the Transcript datafeed and is not a required field for the Transcript to successfully import. Transcript  File: transcript.csv Description: The high-level transcript work of a student. SS&E supports one transcript per person. Default Pull Frequency: Every 6 hours. Position Name Required Description 20 anticip...

Summary A student’s course of study data may include both the primary and secondary degree/program that the student is currently enrolled in, as well as in-progress and completed credentials.  The following screenshots show an example of the Profile Header, Transcript, and Programs tabs displaying Olivia Student’s academic information on the UI, dependent on the academi...

Long running batch processes, specifically the SIS Import Batch Job, LMS Enrollments Import Batch Job, and the Analytics Import Batch Job, will get terminated after a specified number of hours by the batchJobTimeout field in the Application page in the Administration view. By default, this number of hours is set to 24. These jobs are terminated after this specified amou...

By design, canceled course sections are removed from both the Student Courses tab and the Instructor Courses tab. This means that canceled course sections will not display on the Student record in SS&E under any status dropdown! To clarify: A "canceled" course section status imports from the SIS on the Course Section data feed. More information about the SIS Import Def...

Student Success & Engagement allows Continuing Education students and staff to track their studies, no matter how many classes or terms are being attended. In order to bring this student population into SS&E, the Continuing Education population import can be added to the existing SIS Import process. More information about the Continuing Education population add-on can ...

Overview Based on the SIS Data Import Definitions found here, the default Student Success & Engagement SIS Data Export Configuration does not support displaying only a nickname, preferred, or chosen name on the UI. For a workaround solution, the following article explains how schools can display a different first name for all users by making a change to the Person data ...

The SIS import job and the steps inside it have a status while and after they run. The following list shows the possible statuses and their meanings: STARTED The job/step was successfully launched and is currently executing FAILED An error occurred while executing the job/step. Clicking into the failed step will show the error message that caused the failure. STO...

The manual connector page permits an administrator to issue on-demand calls to SS&E datastreams.  This is often uses in debugging whether connectivity exists between SS&E and the SS&E Connect Job. Actions Connector Cache Resetting the cache for a data stream instructs the ETL process to reprocess all records for that stream. Use this when an administrative change has o...

When a course section displays as "Online" in SS&E, it is primarily used for the following cases: Alert Configuration Online course sections may be included or excluded when configuring some alerts. For example, Attendance and First Week Attendance Automated Alerts Configuration have an "Other - Attribute" to "Include Online Course Sections" that can be set to true or ...

SS&E Connect permits data integration to occur between an underlying data source (direct queries, flat files, etc) and SS&E Enterprise in the cloud. The current version of SS&E Connect is version two. Prior to SS&E Connect v2.0, an institution could use the SS&E administrative screens to set SS&E Connect configuration settings. This information was pushed down to SS&E C...

If you'd like SS&E Connect to timeout in the case of long-running queries, add an appropriate timeout to your connection string in the Accelerate Configuration. Note: When adding or changing the timeout length, remember to edit only the Child XML. To do this: 1. Navigate to Administration > SIS Integration > Accelerate Configuration. 2. Find the 3. Add to the very end ...

Course prerequisites are stored and calculated using the following prerequisite data feeds: Prerequisite Groups Prerequisite Courses Prerequisite Tests Prerequisite Permissions Prerequisite Data Structure Each prerequisite group contains an id and a course_id. The course_id listed is for the course that requires prerequisites. The group id is used by prerequisite te...

Overview Adding transfer coursework into SS&E from the SIS via the SIS Import process involves a few key decisions made by an individual institution. The primary question to answer is whether your institution wants to see transfer work represented in the same term as other institutional courses taken, or if your institution prefers to see this coursework separated into ...

Overview Data Extracts are created by the Connect Job and end with a .JSON file type. They are used by the SIS Integration to import data from an organization's SIS system into SS&E based on the data extract definitons, aka logic found in the client system Informer/CSV files or Database Queries/Views and the SS&E Accelerate code. To identify which data feed is importin...