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-facing or student-facing online application, you can send an email directly to Support Services at staffsupportccctc@openccc.zendesk.com.

With the release of CCC Data v2.2.0, the DW Report Server is now secured through single sign-on (SSO). To do this we needed to retire account access to the DW Report Server (and LGBTQ Report), migrate all existing accounts over and enable all new user accounts be created in our new secure system - which means your old password will no longer work.

If you are an authorized college or district user, you will go to a school/district login page and use the password provisioned to you for your other college/district systems. If you are a non-SSO user, you can use the “Forgot Password?” link to reset your password or contact ES Support Services to reset the password for you.

In September 2022, the CCCTC implemented a new secure system to authenticate Data Warehouse Report Server users. Pre-existing users have been migrated to the new secure system, but will need to work with the CCCTC Enabling Services team to re-validate their accounts. CCC college and district users will now log in via a custom URL and their institution’s IDP for single sign-on login. All other users, including Chancellor’s Office and CVC-OEI users, will continue to use the DWRS URL but must re-validate their existing account credentials.

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 stakeholders, must be directed to Mark Cohen, Product Manager, CCC Data, mcohen@ccctechcenter.org who will obtain approval from the appropriate CCCCO Vice Chancellor.

Please notify the research lead at your college or contact CCCTC Enabling Services directly at ES Support Services.

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.

For Non-SSO Users (Chancellor’s Office and CVC-OEI authorized users): Yes. Please contact the ES Support Services team at the CCCTC to obtain a new temporary password for your user account from a CCCTC Administrator. Once the account has been re-verified, you can change the password using the “Forgot Password?” link on the Log In page. If you have trouble using the “Forgot Password?” feature, please contact ES Staff Support to request assistance at staffsupportccctc@openccc.zendesk.com.

For SSO Users: (Colleges & Districts): No. You are no longer required to enter a password when accessing the DWRS through your institution’s IDP (SSO). To reset your local password, please contact your college or district IT department.

For Non-SSO Users Only: A verification code is required as the second factor used in two-factor authentication for non-SSO users only (the password is something you know, and the verification code is something that you obtain). This additional step helps to secure data in the DW Report Server.

For Non-SSO Users Only: A new verification code is generated in the Authenticator app software you installed on your desktop or mobile device during the implementation process. After entering your email and password credentials and continue to the “One-time code” screen, open your Authenticator app and copy the six-digit verification code that is generated for the Data Warehouse Report Server. Enter the code in the “One-time code” field before the code expires (30 seconds).

For Non-SSO Users Only: The verification code is time-sensitive code designed to time out after 30 seconds. Each newly generated code appears with a timer, counting down to expiration. Give yourself enough time to copy the code and return to the sign in process before the code is no longer valid.

The CCC Data Warehouse is a structured database while the Data Warehouse Report Server is an analytics software package connected to that database providing an interface to query and extract data.

The Data Warehouse Report Server is a CCC-branded version of TIBCO JasperReports Server (v.7.8.0) with role-based access to integrated CCC Data for authorized CCC researchers using single sign-on (SSO).

TIBCO JasperReports Server is a comprehensive Business Intelligence (BI) tool that provides robust static and interactive reporting, report server, and data analysis capabilities. A comprehensive Help system is available and can be accessed from any screen in the upper right toolbar. The Help system provides high-level descriptions of feature functionality and step-by-step instructions for how to extract the data and insights you need from your data.

Two-Factor Authentication (2FA), a subset of multi-factor authentication (MFA) is a security system that authenticates a user’s identify by requiring multiple pieces of evidence (credentials) before granting access to a service or system.

Authorized DWRS user types and access levels are defined in the Data Warehouse Report Server User Guide.

Yes. We will notify you 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.

The DW Report Server includes the LGBTQ report developed in support of AB620.

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.

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

The Data Warehouse Report Server User Guide is stored in the CCC Data Warehouse Public Documentation space. This guide is a living document is updated as needed.

SSO Users (college & district users) are provided a custom URL based on the institution’s IDP for single sign-on. College & district URLs can be located in Appendix A of the Data Warehouse Report Server User Guide.
Non-SSO Users (all other authorized users) will continue to use the DWRS URL: https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html

The “first-time user log in” process pertains to Non-SSO Users ONLY. Non-SSO Users must complete this one-time process in order to authenticate their new account with the DWRS secure system. After completing the first-time process, Non-SSO Users need only use the Verified User Log in process to gain access the DWRS.

SSO Users: College & district users will log in using the credentials set by their institution’s single sign-on (IDP) mechanism. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

Non-SSO Users: Chancellor’s Office & other external users are provided account credentials and temporary password during the implementation process between the user and the CCCTC Enabling Services implementation team. To contact the ES implementation team, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

The Organization (MIS Code) is the number assigned to each college and district by the Management Information System Division of the California Community Colleges Chancellors Office. Each district and college has a unique 3-digit MIS code number identifying their college. This code is added as an attribute by a CCCTC Administrator and will show in JasperReports after initial successful login.

The Username or Email field, which appears on the Log In page, is a text input field requiring the authorized user’s institutional email address (.edu).

Non-SSO Users: Chancellor’s Office & other external users are provided a temporary password during the implementation process. See the Non-SSO Users: Account Setup & Log In Process in the Data Warehouse Report Server User Guide.

College & district users (SSO Users) will log in using the credentials and password set by their institution’s single sign-on (IDP) mechanism. For more information, please contact your College Relationship Manager (CRM) at crms@ccctechcenter.org.

The “Scan QR Code” page is a step in the “first-time user log in” process (one-time process), required for Non-SSO Users only. See the Data Warehouse Report Server User Guide for details.

Scanning the QR code during the “first-time user log in” process depends on the Authenticator software you have installed on your desktop device. See the Data Warehouse Report Server User Guide for details.

Scanning the QR code during the “first-time user login” process depends on the Authenticator software you have installed on your mobile device. See the Data Warehouse Report Server User Guide for details.

Once logged into the Data Warehouse Report Server, navigate to the “View > Repository” and open the Public folder to find the LGBTQ folder.

Yes. See the image above to locate the ready-to-run report template for your LGBTQ data.

To customize the LGBTQ report, you must locate and edit the original ad hoc View that was created and saved as the Report. Once you locate the corresponding View from the corresponding Public view folder, highlight the row of the View you want to customize and click the “Copy” button in the navigation menu. Locate your college or district folder and Paste the View there to unlock the permissions. Once unlocked, double-click on the file to open the View in the Ad Hoc Editor.

If you/your college has already completed the process to set up and authenticate your Data Warehouse Report Server user account, you should contact College Support Services at staffsupportccctc@openccc.zendesk.com.

The Data Warehouse Report Server User Guide provides basic, end-user training support for authorized users.

Please contact CCCTC College Support Services at staffsupportccctc@openccc.zendesk.com.