A part of the Data Services Program initiative from the California Community Colleges Chancellor's Office, CCC Data provides the necessary infrastructure for the California Community College System to be able 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 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 supports the ability for authorized colleges and districts to implement direct site-to-site VPN connection to the CCC Data Warehouse (Redshift) and to the CCC Data Warehouse Report Server (Jaspersoft) for the following data sources:

• California Colleges Promise Grant Application

• CCCApply International Application

• CCCApply LGBTQ Data (AB 620)

• CCCApply Standard and Noncredit Applications

• C-ID - Course Identification System

• COCI - Chancellor’s Office Curriculum Inventory

• MIS (post-processed files) - Chancellor’s Office Management Information Systems

• Multiple Measures Placement Service (MMPS)

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 alternative to or in addition to, using the Data Warehouse Report Server. 

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.

ODBC is a SQL-based communication standard created by Microsoft that is used by software applications to access databases. JDBC is an SQL-based communication standard created by Sun Microsystems to enable Java-based software applications to use SQL for database access.

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

Yes. We will notify colleges as additional data sets are added.

The head of IRPE 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.

SuperGlue is the software infrastructure that is the single point of contact for data exchanged between software deployed by the California Community Colleges Chancellor's office and the software enterprise systems at the 116 individual community colleges across the state.

SuperGlue supports student success by delivering pertinent, timely data to students, faculty, and staff.

The CCC Data Warehouse is a structured master data source that can be used to generate data marts, reports, and analytics. It also encompasses a broader set of data products, including a data lake, data marts, and reporting tools.

To get started with direct data access, see Implementation Process in the Direct Access User Guide.

The best way for CCC staff and faculty to contact the Support Services team at the CCC Technology Center is to visit http://CCCTechnology.info , the online support community for faculty and staff. 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.

• For college or district researchers, please contact cems@ccctechcenter.org.

• For CCCCO or other other users who are not researchers, please contact crms@ccctechcenter.org.

Support is available to authorized Report Server users in our 24/7 online support community http://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.

Chancellor's Office and Other External Stakeholders: All requests for access to the CCC Data Warehouse Report Server from the Chancellor's 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, DII.

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 includes “quick start” information specifically for authorized CCC Data Warehouse Report Server users.