Release 2023.CCCData.2.6.0

Owned by Mark Cohen
Last updated: Oct 17, 2023
2 min read

Schedule

CCCData 2.6.0 will be deployed:

  • To pilot environment: Friday, October 6, 2023

  • To production: October 17, 2023

Release Summary

  • Support for Canvas Data 2 in CCC Data Warehouse

  • Support for MyPath data in CCC Data Warehouse

Support for Canvas Data 2 in CCC Data Warehouse

With the release of CCC Data 2.6 Canvas data (utilizing the Canvas Data 2 API) will be available in the CCC Data Warehouse. In order to have Canvas data included in the CCC Data Warehouse, the college or district must opt-in by contacting their College Relationship Manager and providing their Canvas Data API key to the CCC Technology Center.

Canvas Data 2 supports 89 unique datasets, including Learning Outcomes data; the full set of data supported in Canvas Data 2 are detailed in the data dictionary provided by Instructure. Once migrated to the CCC Data Warehouse, Canvas data may be accessed by college or district researchers through a direct (ODBC/JDBC) connection to the CCC Data Warehouse secured through a site-to-site VPN.

The deployment of Canvas Data 2 will replace support for the prior Canvas Data API which Instructure intends to deprecate by the end of the calendar year.

Upon the release of CCC Data 2.6, pilot testing will be conducted on support for Canvas Data 2 in the CCC Data Warehouse. Upon the conclusion of the pilot testing the CCC Tech Center will notify colleges and districts of the option to include their Canvas data in the CCC Data Warehouse through Canvas Data 2.

Notice: Action Required for Canvas Support

Districts or colleges may opt-in to have their Canvas data supported in the CCC Data Warehouse by contacting their College Relationship Manager at crms@ccctechcenter.org.

Support for MyPath data in CCC Data Warehouse

Data from MyPath was added to the CCC Data Warehouse. As with other data in the CCC Data Warehouse, MyPath data is segmented by MIS code to assure that colleges may access data associated with their college, while districts may access data associated with their colleges.

MyPath data consists of the following tables:

  • Advisor card reminder data

  • Advisor usage data

  • Audit table

advisorcard_reminders Table

reminder2statustime

TIMESTAMP

reminder3status

VARCHAR

miscode

VARCHAR

reminder3statustime

TIMESTAMP

reminder1status

VARCHAR

reminder1statustime

TIMESTAMP

id

bigint

completed_timestamp

TIMESTAMP

reminder2status

VARCHAR

advisorcard_usage Table

id

bigint

state

VARCHAR

timestamp

TIMESTAMP

username

VARCHAR

createdby

VARCHAR

miscode

VARCHAR

card_title

VARCHAR

task_title

VARCHAR

card_order

INTEGER

task_order

INTEGER

has_reminder

BOOLEAN

audit Table

event_type

varchar

miscode

varchar

created_timestamp

timestamp

originator

varchar

target

varchar

Documentation

Instructure has made the following data dictionary available for Canvas Data 2 (v. 4.2.9).

Other related documentation: