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):
DW Direct | DW Report Server | DW Direct | 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
NEW! Data Warehouse - Direct Access User Guide
Data Warehouse (Jaspersoft) Report Server - User Guide
Jaspersoft Tutorials for the Data Warehouse Report Server (external links)
See the left sidebar for more links and information.
Support
Need help?
Visit CCCTechnology.info to submit a support request
Or CCC Data support site for questions and answers regarding the CCC Data Warehouse, DW Report Server, and DW direct connection.
News & Information
CCC Data awarded the 2020 Best of California Award for “Best Application Serving an Agency’s Business Needs.”