SS&E - SIS Integration

Overview Data is extracted from the SIS and transmitted to the Student Success & Engagement application using several data feeds. Student Success & Engagement accepts the data using one of two methods: via CSV files using Apache Drill, or via a Direct Database Connection (using queries within SS&E Accelerate or SQL Views). See the Connect Overview and Import Process art...

Overview Connect2 (formerly Aviso Connect) is a software package offered by Watermark Student Success & Engagement that permits the SS&E hosted platform to integrate with an institution’s on-premise systems. This guide provides information regarding prerequisites for the connector implementation and the various setup and configuration requirements of an institution. The...

Import Process Overview There are two methods for implementing Student Success & Engagement SIS Data Integration on the institution's Connect server. Connect Method 1 uses CSV files (often exported from the SIS via Informer or another custom export method) as the data source. Connect Method 2 is a direct database connection using SQL Views or Queries. No matter which ...

Overview The following article lists all data feeds and fields that can be used to import SIS data into SS&E. To learn when to refer to this article, click here. When a value is not required, fields may be populated with null/" "/left empty if there is no data importing for the field from the SIS system.  When a field is required, it must be populated with a valid va...

In the data integration there are two major steps, the Connect2/Accelerate process and the Import process. See the SIS Data Import Process for a visual on each of these steps. View JSON Extract This is data that is waiting to be imported into SS&E. This step is after the Connect2 task/Accelerate configuration has processed the data from the source system (CSVs or Databa...

Overview In Student Success & Engagement, the data integration has two major steps: The Connect2/Accelerate process The Import process  See the SIS Data Import Process for a visual on each of these steps. This quick guide outlines what successful data transfer looks like, as well as the types of errors or failures that can occur at each step. Use this in conjunction ...

Overview In Student Success & Engagement, the data integration has two major steps: The Connect2/Accelerate process The Import process  See the SIS Data Import Process for a visual on each of these steps. If you are experiencing issues with the SIS Data Integration, check for errors at each step of the process. It is also important to confirm the source data is corre...

Overview Data integration changes are common, whether it is due to institutional business process changes, data definition changes, or product enhancements that support additional data for integration. This is the same process used during data integration in implementation. Understanding the data integration tool for SS&E (Watermark Connect) is helpful when making data ...

Overview This article outlines rules, tips, and recommendations for building data feeds using any method, as well as for specific methods and implementations. There are also some best practices for how to set up specific feeds and fields. All Methods Ids must be unique Note: Many times, this Id is a combination of values imported on other columns that together create ...

Overview In Student Success & Engagement, most data that is imported from the SIS remains in SS&E, even if it is no longer actively importing. Sometimes records can be orphaned or deleted from the SIS, imported by mistake, duplicated, or otherwise undesired in SS&E. Certain data feeds support deletion using a supplementary feed called the “All IDs feed”. There are also ...

Overview In Student Success & Engagement, degrees and programs are used to filter students into populations and then to take actions, send alerts, messages, etc. on that population. There are 6 required Degree Program-related data feeds. There are optional related feeds including major, and curriculum/area of study feeds. There are also other feeds referenced including ...

Institutions may import information relating to their physical campus locations on the Locations datafeed. See the SIS Import Definitions page for config information.   This datafeed will be visible within Admin>SIS Integration> Datafeeds as Location The values will appear within the UI (reports and meeting scheduler) as Campus If an institution has only one physical ...

Overview In preparation for your upgrade to Student Success & Engagement Enterprise, you have been asked to think about the five person types are available for your campus to use and that can be displayed:  Student Applicant Prospect Staff Faculty Person Types are used to group records (people) into spaces that can be worked with by staff in different roles. Here is a...

Overview Phones and Addresses can be useful contact information to have on student, applicant, and prospect records. However, many institutions find it beneficial to limit the contact information that is imported into SS&E and/or limit phone and address types that are imported. This article contains basic information and best practices for implementing phone and address...

Overview As you build your data feeds, you will need to identify populations to import into SS&E. In SS&E, historical student data is used in Predict to provide better predictive analytics insights. Staff and Faculty records are imported to allow users to login, and they are also linked to course section records. Students Include any person who has been an active stude...

Overview Roles can be assigned either manually in Student Success & Engagement (SS&E) individually or in bulk, or via the SIS Import/Person Datafeed. Security permissions in SS&E are Role-based, so it is important to ensure that the correct roles are applied to users. A user’s role in SS&E may not align exactly with the corresponding role in the SIS–it is important to d...

Overview The list of tags may be created either manually in Student Success & Engagement (SS&E) or via the SIS Import/Person Datafeed. Tags can be assigned to a person in three ways: Automated Tags (assigned by SS&E system), Data-Backed Tags (assigned via SIS Import on personTag datafeed), and Manual Tags (assigned by an SS&E Administrator). This guide covers Data-Backe...

Overview Transfer credits are imported on the transcriptCourse feed. On the transcriptCourse feed, academicCalendar and courseSection records are required fields, but often these records don't exist in the SIS. Instead, transfer credits are associated with a course record in the SIS, not a courseSection record. If transfer credits are already associated with course sect...

Overview The SS&E Connect Server facilitates the data integration between an institution’s SIS and SS&E, by sending the data files via SFTP to the Watermark SS&E environment. See more information on the SIS Integration data flow here: SIS Data Import Process and Infrastructure Summary. If your institution needs to upgrade the Connect Server OS, migrate the server to the...

SS&E Accelerate (formerly known as Connect) is an integration utility that allows an institution to define how data should be extracted from local systems (especially an SIS) to then be transmitted and ingested into SS&E. The utility itself runs on a server on the institution's local network where it has access to the source data. It is configured from the SS&E administ...

Overview For best results, Student Success & Engagement requires ongoing maintenance in order to deliver new and exciting features that rely on accurate and up-to-date data extracted from third-party systems. Historically, upgrading an institution to include new SIS data integration features was a laborious process, requiring multiple steps by both Watermark SS&E and i...

The LMS Transcript Course Datafeed provides an alternative method for SSE to integrate with the LMS. Traditionally, SSE integrates with the LMS directly via API. If this option is not suitable or applicable, the LMS Transcript Course Datafeed may be used.  The LMS Transcript Course Datafeed does not support assignment level data integration. This refers to the assignmen...