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 the data is provided to institutional researchers, college and district administrators, and other decision makers across the 115 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 2.0 supports the ability for authorized colleges and districts to implement direct site-to-site VPN connection to the CCC Data Warehouse (Redshift) for the following data sources:

The direct connection supports access to the following data sources with this release:

The purpose of CCC Data Warehouse Direct Access Connection is to support direct access to the CCC Data Warehouse (Redshift) for colleges that have a local data warehouse and prefer to use their own local analytics/business intelligence tool as an alternate to or in addition to, using the Data Warehouse Report Server.  

To confirm that colleges and districts can successfully connect to and run queries from the supported data sources in the CCC Data Warehouse, a college pilot project will commence on October 2, 2020.

The pilot will be structured in two phases with two colleges will be selected for this first phase. Once these colleges have completed their pilot testing and a retrospective has been conducted, the pilot will proceed to the second group of remaining pilot colleges.  

CCC Data Warehouse Direct Access Connection allows colleges to leverage their local analytics/BI (business intelligence) software in support of research across different/more data sources.

The DW 1.4.1 release provided authorized access to the CCC Data Warehouse data sources via the Data Warehouse Report Server - a branded version of TIBCO Jasper Software.

The DW 2.0 release supports a direct ODBC / JDBC connection to the Data Warehouse data sources.

ODBC is an SQL-based Application Programming Interface (API) created by Microsoft that is used by Windows software applications to access databases via SQL. JDBC is an SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access.

The following data sets are available to authorized users in the CCC Data Warehouse for both Data Warehouse Report Server users and by direct ODBC/JDBC connection:

Yes. We will notify colleges as additional data sets are scheduled to be added. These additional data sets will include, though not limited to, COCI, C-ID, MyPath, and Canvas data.

Approved IRPE researchers at each college or district will be established as the authorized user and “gatekeeper” for their organization (MIS Code) upon confirmation from their college or district Vice President. Gatekeepers can then request access for additional researchers at their organization (MIS Code) by submitting an email request to ES Support Services with the information below.

Communication will be provided as additional data sources are scheduled for release.

The best way for CCC staff and faculty to contact the Support Services team at the CCC Technology Center is to visit CCCTechnology.info, the online support community for faculty and staff, and post a comment, ask a question, submit a change request, or make a request for technical assistance. Support engineers are monitoring every incoming post between Monday and Friday, 7:00am - 4:00pm PST. Reporting an outage or incident with a staff- or student-facing online application, you can send an email directly to Support Services at staffsupportccctc@openccc.zendesk.com.

Support is available to authorized Report Server users in our 24/7 online support community CCCTechnology.info - where college and district staff can share ideas, ask questions, and report bugs and issues for all the CCC Technology Center online applications. Our experienced support engineers monitor all incoming posts and comments, Monday - Friday, 7:00am - 4:00pm PST. Depending on the nature of the issue or comment, support engineers will respond within 24 hours to critical issues regarding production applications.

IRPE Researchers: The identified lead IRPE Researcher at each college or district will be established as the authorized user and “gatekeeper” for their organization (MIS Code) upon confirmation from their college or district Vice President. Gatekeepers can then request access for additional researchers at their organization (MIS Code) by submitting an email request to ES Support Services with the information below.

Chancellors Office & Other External Stakeholders: All requests for access to the Data Warehouse Report Server from the Chancellors Office or other external stakeholder, must be directed to Mark Cohen, Product Manager, CCC Data, mcohen@ccctechcenter.org who will obtain approval from Vice Chancellor, Barney Gomez, bgomez@cccco.edu.

Authorized users of the CCC Data Warehouse Report Server are provided their account credentials and password during the implementation process between the user and the CCCTC Enabling Services implementation team. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

The Data Warehouse Report Server - User Guide includes “quick start” information specifically for authorized Data Warehouse Report Server users.