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):

Source Data Set

CCCCO Access

District/College Access

Introduced in Release Version

DW Direct
Connection
DW Report Server
DW Direct
Connection
DW Report Server

CCCApply Standard Application

CCC Data 2.0

CCCApply Noncredit Application

CCC Data 2.0

CCCApply International Application

CCC Data 2.0

California College Promise Grant Application

CCC Data 2.0

Decrypted LGBTQ Data (and Report)

CCC Data 2.0

Multiple Measures Placement Service (MMPS)

CCC Data 2.0

COCI: Chancellor's Office Curriculum Inventory

CCC Data 2.1

C-ID: Course ID Numbering System

CCC Data 2.1

CANVAS (Requires district/college to opt-in for inclusion)

CCC Data 2.1

CO-MIS

CCC Data 2.1

NOVA

CCC Data 2.1

Launchboard

CCC Data 2.1

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 (scheduled for September 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:

  • MyPath

  • Select tables from MIS, NOVA, Launchboard to be accessed through DW Report Server and DW Direct Connection - 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.”