Page Comparison

Product

Product Owner/Manager

Product Overview

Prerequisites

Adoption & Implementation

Contract Requirements

CCC Data Warehouse Lake (part of the CCC Data platform)

John Sills / Mark Cohen

• Stores data gathered from CCCTC products & servicessystemwide resources, including:

  • CCCApply Suite

  • MyPath

  • Multiple Measures

  • COCI

  • C-ID

  • Canvas

  • MIS

  • Launchboard

  • NOVA

• Sourced through:

  • SuperGlue, Kinesis and AWS Data Pipeline

• SSO Proxy (need to track integration)

• Canvas API key (for inclusion of Canvas data)

• Sign-up: ES / InterVision

• Opport.: ES Team

• Implementation: ES ICE team supports direct access (OBDC/JDBC) connection setup and testing

• Signed IPA

CCC Data Lake

Data Warehosue Direct Connection

CVC/OEI

(formerly Course Exchange)

TBD

• Allows student to access courses offered at other participating colleges

• Students enroll via a streamlined registration process

1. Project Glue

2. SSO Proxy 

• Signed IPA Addendum G

• Course Exchange  questionnaire

Data Warehouse Report Server

John Sills / Mark Cohen

NEED from Product Team

• Authorized IRPE Users are vetted and must be approved by college or district Vice President or other authority

• User account setup and access requires end-user implementation of compliant authentication software to facilitate multi-factor authentication (MFA) login requirements.

• VPN (already in place between CCCCO and CCCTC)

Data Lake is not available to CCC’s.

• Approved CCCCO staff may be provided access (as requested of Mark Cohen, and approved by Barney Gomez)

• Implementation: Intervision manages access

• NA

CCC Data Warehouse (part of the CCC Data platform)

John Sills / Mark Cohen

• Makes select data from the Data Lake available in a structured database, with CCC Data 2.1, includes:

  • CCCApply Suite

  • MyPath

  • Multiple Measures

  • COCI

  • Canvas

• N/A

Data accessed through either DW Direct Connect or DW Report Server

• NA

Data Warehouse Direct Connection (part of the CCC Data platform)

John Sills / Mark Cohen

• Provides access to available data sources in the Data Warehouse

• Direct (ODBC/JDBC) connection enables colleges to connect their preferred BI tool or queries through SQL workbench

• Custom site-to-site VPN between district and CCCTC

• Log-in credentials

• https://zoom.us/j/99753506333?pwd=MGIxTW1PeXJmVDI5MndDVDhCdlFnZz09

• Sign-up: ES

• Opport.: ES Team

• Implementation: ES ICE team supports

No formal contract or MOU, but approval for access includes vetting and approval from college/district V. President

eTranscript California

Mark Cohen

• Edexchange (pesc.org)

• (Will require SuperGlue-FY18/19)

• Sign-up: CCCTC Sales Team, or Topacio Vargas at XAP

• Opport.: CCCTC Sales Team

• Implementation: Enabling Services Project Management oversight of XAP and college tasks (for eTranscript 2.0 and beyond)

(Contract with XAP)

InCommon Federation

Amir Kahn

• Provides a trust fabric for higher education, their vendors, and partners to facilitate single sign-on from local campus accounts.

• Chancellor’s Office and the CCCTC have put together an agreement for InCommon membership for all California community colleges to be paid centrally

• SSO Proxy 

• Signed IPA

• MOU for InCommon membership

Multiple Measures Placement Service (MMPS)

John Sills / Mark Cohen

• Facilitates collection of High School transcript data and delivery of AB-705 compliant placement recommendation (Self Reported data from CCCApply, verified data from CCGI or CALPASS)

• SuperGlue

• CCCApply 

• College Adapter v2.5.5 or later

• CCCMyPath (future)

• .csv file push to colleges:  Dev

• Sign-up: CCCTC CRM Team

• Opport.: CCCTC CRM Team

• Implementation: Enabling Services

• direct access (OBDC/JDBC) connection setup and testing working with Intervision

• Approved CCCCO staff may be provided access (as requested of Mark Cohen, and approved by Barney Gomez)

• Signed IPA

• ES authenticates access with IR lead

Data Warehouse Report Server (part of the CCC Data platform)

John Sills / Mark Cohen

• Provides access to available data sources in the Data Warehouse

• Direct (ODBC/JDBC) connection enables colleges to connect their preferred BI tool or queries through SQL workbench

• Authorized IRPE Users are vetted and must be approved by college or district Vice President or other authority

• User account setup and access requires end-user implementation of compliant authentication software to facilitate multi-factor authentication (MFA) login requirements.

• Sign-up: ES CRM / IPM

• Opport.: ES Team

• Implementation: ES ICE team supports user account setup and basic training

• Approved CCCCO staff may be provided access (as requested of Mark Cohen, and approved by Barney Gomez)

• Signed IPA

• ES authenticates individual CCC access with IR lead

Multiple Measures Placement Service (MMPS)

John Sills / Mark Cohen

• Facilitates collection of High School transcript data and delivery of AB-705 compliant placement recommendation (Self Reported data from CCCApply, verified data from CCGI or CALPASS)

• SuperGlue

• CCCApply 

• College Adapter v2.5.5 or later

• CCCMyPath (future)

• .csv file push to colleges:  Dev

• Sign-up: CCCTC CRM Team

• Opport.: CCCTC CRM Team

• Implementation: Enabling Services

• VP of Student Services with collaboration with VP of Instruction

CCC SuperGlue 

(formerly “Project Glue”)

John Sills / Mark Cohen

• Provides a secure, robust framework for data exchange between CCCTC products and colleges

• Software component installed locally behind a college’s firewall to facilitate data exchange between CCCTC projects and college’s Student Information Systems (SIS)

• Enables disparate SISs to communicate in a standardized way through a cloud service

• Master Data Management (YOUnite)

  • Provides a single point of reference for what systems are considered “systems of record” for specified data elements and data exchange interactions. Keeps college data synced with CCCTC centralized applications

  • Facilitates data exchange between colleges and Chancellor’s Office

• SSO Proxy supplied CCCID as required by product

• Sign-up: A prerequisite of a primary product, or may be adopted and  implemented as a preparatory measure.

• Opport.: CCCTC Sales Team, CRM’s

• Add on Feature Sales: Sales/CRM’s/ES

• Implementation: Enabling Services

• Signed IPA Addendum C

Master Data Management (MDM)

John Sills / Mark Cohen

Unlimited SSL Certificates

Amir Kahn

• Available for no charge as part of InCommon Membership

• None

• Sign-up: CCCTC Sales Team

• Opport.: CCCTC Sales Team

• Implementation: Jeff Holden (shifting to Enabling Servicesin May 2018)

• Signed MOU for InCommon membership

SAML / IdP

(Shibboleth, Ethos, Portal Guard)

John Sills / Mark Cohen

• Not a CCCTC product, but necessary to provide IdP (ID’s) within CCCTC Products

• Security Assertion Markup Language is an open standard for exchanging authentication and authorization data between an identity provider and a service provider. 

• Allows sites to make informed authorization decisions for individual access of protected online resources in a privacy-preserving manner.

• None

• Sign-up: College 

• Opport.: N/A (college is responsible)

• Implementation: College 

  • (Unicon for Shibboleth) 

1. N/A

SSO Proxy 

(“Authentication”)

John Sills / Mark Cohen

• California Community Colleges Single Sign-on Federation (SSO)

• “Authentication” is the process of verifying a student or staff member at a college using the SSO Proxy 

• Provides users single sign-on convenience and privacy protection

• Online Service Providers control access to their protected resources.

• All CCCTC Products that require Authentication must be configured and connected via SSO Proxy (ex: Canvas, Apply, Starfish, MyPath, Library, etc)

• District level IdP for staff and student accounts (ie. Shibboleth)

• Sign-up:  A prerequisite of a primary product, or may be adopted and  implemented as a preparatory measure.

• Opport.: CRM

• Implementation: Enabling Services

• Signed IPA

• 2018 Canvas IPA requires SSO Proxy

• 2019  LSP Library integration requires SSO Proxy

John Sills / Mark Cohen

• Provides a secure, robust framework for data exchange between CCCTC products and colleges

• Software component installed locally behind a college’s firewall to facilitate data exchange between CCCTC projects and college’s Student Information Systems (SIS)

• Enables disparate SISs to communicate in a standardized way through a cloud service

• Master Data Management (YOUnite)

  • Provides a single point of reference for what systems are considered “systems of record” for specified data elements and data exchange interactions. Keeps college data synced with CCCTC centralized applications

  • Facilitates data exchange between colleges and Chancellor’s Office

• SSO Proxy supplied CCCID as required by product

• Sign-up:

  • ) 

1. N/A

SSO Proxy 

(“Authentication”)

John Sills / Mark Cohen

• California Community Colleges Single Sign-on Federation (SSO)

• “Authentication” is the process of verifying a student or staff member at a college using the SSO Proxy 

• Provides users single sign-on convenience and privacy protection

• Online Service Providers control access to their protected resources.

• All CCCTC Products that require Authentication must be configured and connected via SSO Proxy (ex: Canvas, Apply, Starfish, MyPath, Library, etc)

• District level IdP for staff and student accounts (ie. Shibboleth)

• Sign-up:  A prerequisite of a primary product, or may be adopted and  implemented as a preparatory measure.

• Opport.:

• CRM

• Implementation: Enabling Services

• Signed IPA

• Signed IPA Addendum C

Master Data Management (MDM)

Unlimited SSL Certificates

Amir Kahn

• Available for no charge as part of InCommon Membership

• 2018 Canvas IPA requires SSO Proxy

• 2019  LSP Library integration requires SSO Proxy

InCommon Federation

Amir Kahn

• Provides a trust fabric for higher education, their vendors, and partners to facilitate single sign-on from local campus accounts.

• Chancellor’s Office and the CCCTC have put together an agreement for InCommon membership for all California community colleges to be paid centrally

• SSO Proxy 

• Sign-up: CCCTC Sales Team

• Opport.: CCCTC Sales Team

• Implementation: Jeff Holden (shifting to Enabling Servicesin May 2018)

• Signed IPA

• MOU for InCommon membership