Coursedog

Submit a ticket My Tickets
Welcome
Login  Sign up

Jenzabar Integrations

The Coursedog Method

Coursedog can implement a bidirectional data exchange with Jenzabar One, CX, and EX through one of the primary integration pathways:

  • Direct Database (SQL) queries and flat file exchange
  • Web APIs

Each pathway has a distinct list of benefits and considerations to take into account. We also understand that each institution is unique in regards to their system and customizations. Coursedog takes a simple 3 step holistic approach to find the best fit for your integration needs.

  1. Technical Discovery Session - Our initial step is to gain a better understand of your technical landscape. We will discuss your current set-up, customizations, security, and integration preferences. 
  2. Data Workbook Session - It is important to understand how your institution stores and maintains the following data: sections, courses, departments, buildings, rooms, instructors, and terms. Example screenshot from a Data Workbook:
  3. Recommendation Session - After gathering information we will present our best fit analysis along with considerations and benefits for each (See below).

Direct Database (SQL) queries

Direct database queries are the backbone of many integrations to older versions of Jenzabar. It allows controlled direct access to data regardless of the level of customizations. Coursedog will handle the ETL data mapping work once the data is pulled from Jenzabar. 

It is the best fit for the following types of institutions:

  • Highly customized data structures
  • Legacy system configurations
  • Not currently using Web APIs
    • Note: Any customizations to the data structure may require additional extensions.

Benefits

  • Does not require an upgrade
  • Security - You have full control of who has access to each table and run the client scripts. Standard transfer protocols available such as SFTP are available.
  • Flexible to your needs. IT staff will likely have the expertise to help close any gaps due to customizations.

Considerations

  • May not be the long term vision of the IT staff
  • Shared Support Model - Support responsibility is shared given the need for a local client and 
  • Client IT staff may not have expertise or resources to assist with the deployment.

Transfer Protocals

Coursedog supports two primary transfer protocols for a direct query approach:

  • Secure File Transfer Protocol (SFTP) - Authentication will be handled solely via Private Key (PKI) authentication per client. All transmissions will be handled over SSH so no need for you to open any additional ports (22). 
  • Local HTTP/REST client - Coursedog will install a lightweight client that will pull the information from your database and expose the information externally via HTTP. All transmissions will be handled over SSL so no need for you to open any additional ports (443). 

Web APIs

The Web APIs offer Jenzabar institutions a modern standards based approach to integrate against the Coursedog API libraryIt is the best fit for the following types of institutions:

  • You stay close to the out of the box data structures
  • Updated system configurations (e.g. SQL)
  • Currently using Web APIs to expose data externally.
  • IT staff is available to close gaps due to customizations.

Benefits

  • Modern standards based (REST, JSON) approach to expose your data.
  • Security - You control who has access via a key or single username/password.
  • Flexible to your needs. IT staff will likely have the expertise to help close any gaps due to customizations.

Considerations

  • You may not be currently using Web APIs to expose data externally.
  • IT staff may not have expertise or availability to install extensions (if necessary)

C
Coursedog is the author of this solution article.

Did you find it helpful? Yes No

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