Update on 2.1 pilot and support for Canvas data

2.1 in pilot. Includes

• Data Warehouse Report Server upgrade to Jaspersoft 7.8 (currently in production)

• COCI and C-ID data in the Data Warehouse and DW Report Server (for CO and CCC’s)

• Support for MIS, NOVA, and Launchboard data in the Data Warehouse (Limited to authorized CO accounts)

• Canvas data in the DW

Canvas is configured at the root level, while some colleges have chosen to configure Canvas at the college level, most implementations are at the district and Canvas does not provide a way to segment to the college. We have been working with Canvas to identify how to identify colleges through the API and find that their system does not support this. 

This makes the process of segmenting the data to the college challenging, and while we believe we can segment some of the data, this will be a time consuming process. 

Instructure has indicated a possible October release date for Canvas 2 which will necessitate reworking these data pipelines and may resolve these issues. 

With this release, Canvas data will be supported through a direct connection to the DW, where the district or college elects to have their data stored in the DW; it will be available only at the district level, except where

• the district is made up of a single college, or

• the district has configured their canvas system at the college level. which will allow the data to be made available to the district and college. 

We continue to speak with Instructure to understand the timing of Canvas 2, and we are working to identify CCC’s in the pilot so that we may start working in an upcoming release in preparation of colleges moving over to this new version. 

Post processing is possible, but given that a new version of Canvas is on the horizon all the work would have to be redone. We will do what we can with the pilot colleges and the API (direct connect), but we are approaching the work as a dual phased approach, with the next phase beginning around October 2021 with the release of Canvas 2.

Update on 2.2 release currently in development

This release will includes: 

• Updates to how user accounts are managed, including: 

  • SSO support, 

  • Keycloak integration, and 

  • self-service password reset for the DW Report Server 

• Support for Student Success Suite products, including: 

  • MyPath Statistical Reporting in the DW Report Server, and 

  • OpenCCC 2.0 Schema Changes

• Technical debt, including: 

  • updates to reflect changes in data sources as necessary, and 

  • Pipeline refactoring to AWS recommendations 

With the 2.2 release we are also completing the segmentation of MIS data and will be seeking approval from the CO to make these data available to the colleges through the DW, direct connection and report server with ad hoc reporting available. 

We also plan to work on segmenting SCFF data within the Launchboard data in the DW, pending availability of analyst resources and CO approval. 

Release tentatively scheduled for September 2021.

Roadmap for 21/22 underway, will update Advisory committee during the July meeting.

Update on Data Warehouse survey

We are holding off for the summer, looking to identify the best timing for feedback. There are some edits to be made before we do release this.

Discussion on student identifiers

Dustin J. Tamashiro from Pasadena

The student ID was added to MIS, though not in the data dictionary. It is present as the 7^th column in the SI file: https://webdata.cccco.edu/ded/si.pdf.  

He can discuss it as something the RP Group or someone should do a webinar on for researchers at colleges that are less familiar with the MIS tables

Best practices for utilizing data base information? Navigating schemas, general information, would be helpful- how do we support all the colleges? How does the RP group support IRs now?

RP group has been helping with:

Methodology, training, and supplemental documentation

SQL Training

Date Issue/Question Raised: Data on Demand

Date Resolved/Answered:

Owner:

Date Issue/Question Raised:

Date Resolved/Answered:

Owner:

Date Issue/Question Raised: 14 Jun 2021

Date Resolved/Answered:

Owner:

Date Issue/Question Raised: 14 Jun 2021

Date Resolved/Answered:

Owner: