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

Data Sources

The CCC Data platform is populated with data from (Data dictionaries for CCC Data sources):

  • CCCApply Application (Credit and Noncredit): Available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • CCCApply International application: Available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • CCCApply Promise Grant: Available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • Multiple Measures Placement Service (MMPS): Available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • Canvas data, as requested by college: With the CCC Data 2.1 release will be available to colleges and the CCCCO through DW Direct Connect

  • COCI (courses and programs): With the CCC Data 2.1 release will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • MyPath: With the CCC Data 2.2 release will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • C-ID (articulation data): With the CCC Data 2.2 release will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • CCCCO MIS: With the CCC Data 2.2 release, select tables (pending CCCCO authorization) will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • Launchboard: With the CCC Data 2.2 release, select tables (pending CCCCO authorization) will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

  • NOVA: With the CCC Data 2.2 release, select tables (pending CCCCO authorization) will be available to colleges and the CCCCO through DW Report Server (DWRS) and DW Direct Connect

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 (scheduled for April 2021)

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

CCC Data 2.2 (scheduled for June 2021)

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:

  • C-ID

  • MyPath

  • MIS (select tables, pending CCCCO authorization)

  • Launchboard, including SCFF data (select tables, pending CCCCO authorization)

  • NOVA (select tables, pending CCCCO authorization)

Support

Need help? 





News & Information

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