SIS Integration

  • Connect Overview and Infrastructure Requirements

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

  • SIS Integration Overview and Requirements

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

  • Accelerate Configuration

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

  • Accelerate Upgrade

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

  • SIS Data Import Process and Infrastructure Summary

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

  • SIS Import Definitions (for Views and CSV Files)

    Overview The following article lists all data feeds and fields that can be used to import SIS data into SS&E. 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 value. If for some reason the required field is und...

  • Data Feed Guide: SIS Integration

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

  • Extract/Transfer Phase Troubleshooting (data stream out of date)

    1. The first place to check for Connector issues is in Administration -> Advanced -> External Logging, filtering by Log Level "Error".  If there are no errors, check for issues that display when searching by Info or other log levels. If the information isn't helpful, proceed with the following steps. 2. If every data stream is out of date: Connect 1: Remote int...

  • Data Feed Guide: Person Types

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

  • Data Feed Guide: Roles

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

  • Data Feed Guide: Transfer Credits

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

  • Quick Guide: Data Integration Changes

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

  • Quick Guide: View JSON Extract and Imported 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...