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...

*This article is in progress and may be updated at any time* Overview Connect (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...

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...

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 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 As you build your data feeds, you will need to identify populations to import into SS&E. In SS&E, historical student and applicant 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 & Applicants Include any person w...

Assigning Roles: To start, leave role blank for all staff/faculty, only fill role for students. After the project team configures roles, work together to add staff/faculty/advisors/etc.  Once a role has been set through the SIS import process, it will not be removed if the role is no longer present in the import for a user. It must be removed using the user interface. ...

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 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 ...

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 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...