CCC Data Warehouse Public Documentation

 

CCC Data Program Overview

CCC Data has been developed by the CCC Technology Center in coordination with, and at the direction of, the CCC Chancellor's Office.  

A part of the Data Services Program initiative from the California Community Colleges Chancellor's Office, CCC Data provides the necessary infrastructure to the California Community College System to aggregate data across disparate systems to an enterprise data warehouse. 

Access to these data is provided to institutional researchers, college and district administrators, and other decision makers at the 116 California Community Colleges, district offices, and the Chancellor’s Office, where these critical data may be used to support instructional and institutional decision-making aligned with the Chancellor's Vision for Success.

CCC Data Overview

Architecture Overview

The CCC Data project is an AWS-centric, cloud-based solution that stores and structures data sets from the CCC data sources. The data is quickly discovered, retrieved, and used for analytics, reporting, or data mining.

CCC Data High Level Architecture

Data Warehouse Access

The CCC Data Warehouse may be accessed through one of two methods, (i) the Data Warehouse (Jaspersoft) Report Server, and (ii) a direct data warehouse (ODBC/JDBC) connection.

Release Summary

CCC Data 1.4.1 (Released August 27, 2020)

CCC colleges and districts may access the following data through the CCC Data Warehouse (Jaspersoft) Report Server, secured through multi-factor authentication, with access to data from:

  • LGBTQ+ Data and report

  • CCCApply: Application (Credit and Noncredit)

  • CCCApply: International application

  • CCCApply: Promise Grant

  • Multiple Measures Placement Service (MMPS)

CCC Data 2.0 (Released January, 2021)

With this release CCC colleges and districts can directly connect with the CCC (Redshift) Data Warehouse through ODBC/JDBC connection. This allows for data warehouse tables to be connected to the colleges preferred analytics/BI tool, or to connect data from the CCC Data Warehouse as external tables with a local data warehouse.

With this release colleges and districts may directly access data from:

  • LGBTQ+ Data and report

  • CCCApply: Application (Credit and Noncredit)

  • CCCApply: International application

  • CCCApply: Promise Grant

  • Multiple Measures Placement Service (MMPS)

CCC Data 2.1 (Pilot May 2021, Production July 20221

This release adds additional data sources to be accessed through either the Data Warehouse Report Server or Data Warehouse Direct Connect. Data sources may be expanded to include:

  • Canvas data (requires the college to request their Canvas data be added) - to be accessed through DW Direct Connect

  • COCI

  • C-ID

  • MIS, NOVA, Launchboard - accessible to CCCCO through DW Direct Connection

CCC Data 2.2 (Pilot scheduled for July 2022)

This release upgrades the DW Report Server, and adds additional data sources to be accessed through either the Data Warehouse Report Server or Data Warehouse Direct Connect. Data sources may be expanded to include:

  • MyPath

  • SSO support for access to DW Report Server

Support

Need help? 





News & Information

CCC Data awarded the 2020 Best of California Award for “Best Application Serving an Agency’s Business Needs.”