Coursedog

Submit a Ticket My Tickets
Welcome
Login  Sign up

Custom/Homegrown SIS Integration Toolkit

Coursedog provides canned integrations with most major student information systems.  However, Coursedog also supports various integration methods with custom, or homegrown student information systems (SIS).  Coursedog  provides the tools for your IT team to identify, extract, and transfer curricular data from your SIS. Your technical team will be able to transfer the data through one of three integration methods:  

  • SFTP
  • API
  • CSV Migration (one time import mechanism)

Coursedog recommends a discovery and recommendation session with your technical teams and a Coursedog Solution Architect before engaging in a particular strategy. See our integration methodology for more information on the process.

Coursedog Schema
Coursedog provides a structured schema that will allow your IT staff to map data to into the application. A dedicated Data Engineer will work  with your institution to identify the data to help with the extraction. See our schemas here:

Secure File Transfer Protocol (SFTP)
Coursedog supports a scheduled, asynchronous method to transfer data between systems. Coursedog will provide a hosted inbox and outbox to retrieve and push changes as well as a defined schema.  Your institution will be responsible for the data extraction, formatting, and collection.  See assumptions below for more information.

Assumptions & Specifications

The following are a list of system requirements needed in order to begin the Implementation:

  • Coursedog and institution will build an asynchronous bidirectional data integration through secure file transfer protocol (SFTP)
  • Coursedog hosted the SFTP server (AWS)
  • Your institution is comfortable with the mechanics, security, and architecture of SFTP.
  • All transmissions are handled over SSH (22). Institution is  responsible for maintaining their firewall.
  • Authentication is handled solely via Private Key (PKI) authentication (password is not supported).
  • Your Institution understands the required data structures for the Coursedog application. See our open API documentation for more details
  • Your institution is comfortable maintaining the import and export processes within the SIS/system of record.
  • Your institution is responsible for the formatting of the data to the Coursedog schema in JSON format.
  • Institution is responsible for maintaining event handling/process scheduling to maintain a regular sync cadence (e.g. daily/nightly) between the systems:
    • Institution is responsible for placing flat file(s) into the inbox/ folder
    • Coursedog is responsible for retrieving flat file(s) from the inbox/ folder.
    • Coursedog is responsible for placing flat file(s) containing updates into the outbox/ folder
    • Institution is responsible for retrieving flat file(s) from the outbox/ folder.


API
Coursedog provides Rest APIs that allow your institution to build custom integrations to sync your data. This a great option for institutions that have the infrastructure and IT staff that are familiar with this type of integration. 

Assumptions

CSV Load
Coursedog supports an initial data load. This is a great IT free option for institutions that are unable to build out a custom integration. Coursedog provides import templates and QA to help with the initial data load process. After the initial upload, data must be maintained in both SIS and Coursedog. Coursedog will provide training to your staff to help support and maintain data integrity.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.