Update Processes for Existing DWRS Users (v2.2.0)

The following one-time update process pertains to all existing Data Warehouse Report Server (DWRS) users prior to CCC Data Warehouse v.2.2.0 release (February 2023).

Overview of Changes

Two significant updates have been made to the Data Warehouse Report Server tool since the beginning of 2023, including a new secure identity management system (v.2.2.0) and new self-serve password reset functionality for direct access user accounts (v.2.3.0). These changes result in a new URL and sign-in process for college/district accounts using SSO, and a one-time account update for non-SSO users, such as Chancellor’s Office, CVC/OEI and other external user accounts.

Below are two support processes with instructions for users based on user type. College and district users (SSO users) will now access the DWRS via a custom URL configured to their MIS code, allowing single sign-on authentication through their institution’s IdP. All other users (non-SSO) will be re-directed to a new URL and will undergo a one-time re-authentication process, similar to the First-time Log In Process used when they first created their accounts.

Next Steps: See the change table below which outlines next steps depending on your user type.

On This Page

Changes by User Type

Reminder! The following changes pertain to user accounts established prior to the CCC Data Warehouse v.2.2.0 release in early February 2023.

User Type		What Changed?	Does user need to update their existing Password?	Does user need to update their existing Email Address?
College User (Single college district)	SSO User	New URL configured to your MIS code (see process below) Use current college IdP credentials for SSO See the New Process for College/District Users below.	Only if needed on the college IdP system’s end. If so, contact your college/district IT staff for support.	Only if the email address used in your existing DWRS account has changed or changes in the future. If your email address changes, contact CCCTC Support.
District User	SSO User	New URL configured to your MIS code (see table below). Use current district IdP credentials for SSO	Only if needed on the district IdP system’s end. If so, contact your district IT staff for support.	Only if the email address used in your existing DWRS account changes. Same as above.
Chancellor's Office User	Non-SSO User	New URL for direct access (non-IdP) users* User account’s Password must be reset (one-time process) User account’s Email address must be valid (associated with user account) to receive the password reset link. User must repeat the authentication process upon first sign in (including QR Code, etc.) (one-time) See the Update Process for Existing DWRS Users below.	Yes. All existing users must reset their password due to the security changes in this release (one-time). See the Update Process for Existing DWRS Users below for steps to reset your password and re-authenticate their existing account (one-time).	Contact CCCTC Support to confirm or update email address. Must be valid in order to complete Forgot Password? reset process.
CVCOEI User	Non-SSO User	Same as above.	Yes. Same as Chancellor’s Office User answer above.	Contact CCCTC Support
CCCTC Administrator	Non-SSO User	Same as above.	Yes. Same as Chancellor’s Office User answer above.	Contact CCCTC Support

*Non-SSO User = A direct access user (non-IdP) using two-factor authentication (2FA).

New Process for College/District Users

For college/district users the security updates implemented in Release v.2.20 have enabled single sign-on to the DWRS through your institution’s IdP. This means that college and district users will no longer “sign in” or verify your credentials using two-factor (2FA) authentication.Once you have logged in to your internal system, you simply go to the URL configured for your institution and you’re in.

New URL: Each college/district now has a unique URL to access the Data Warehouse Report Server. These URLs are configured to the institution’s MIS code and IdP.

Find your new Data Warehouse Report Server URLs and bookmark your new link.

Use Institution Credentials: This change enables authorized users using their existing institution’s IdP credentials (email, password, etc.). However, the email address in the new DWRS system must match the one used to create the account initially. If that email address changes at the college end, please contact CCCTC Support to update this information.

NOTE: Your email address in your college/district IdP must match the address in your DWRS user account. Please direct any issues or errors encountered to CCCTC Support.

Your DWRS account needs to recognize your IdP email address. If your email address in your existing DWRS user account has changed or changes in the future, you must contact CCCTC Support to have them manually update it in our system. Unlike the new self-serve password reset feature, there is no way to update your email address without contacting CCCTC Support.

The Data Warehouse Report Server User Guide has been updated with changes and new functionality, including the new Password Reset Process.

Update Process for Existing User Accounts (non-SSO)

For all external users (non-SSO) such as Chancellor’s Office or other external stakeholders, the security updates implemented in Release v.2.2.0 require a one-time update for existing accounts.

Below is the process at a glance:

Your new DWRS URL: https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html
Your email address must be valid and match the email address in our new system
Your password must be reset using the new self-serve Password Reset process
You must repeat the steps from the First-time Log In process to verify authentication

Instructions

Navigate to the new URL for the DWRS: https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html
From the Sign In page, click the Forgot Password? link.
Enter the email address that was used to create your existing account.
A success message should appear on the sign in page.
Retrieve the confirmation email message sent to your email Inbox. Follow the instructions in the email by clicking on the embedded link to verify your address.
On the Change/Update your password screen, enter a new password and repeat the password to confirm. Click Continue.
Back on the Sign In page, enter your valid email address and new password in the input boxes. Click Submit to continue.

Note: If you cannot remember the email address used in your existing DWRS account, or if the email address has changed, contact CCCTC Support to update the email address in your account.

The remaining steps in the process are the same as the First-Time User Log In Process that you used initially to create your DWRS account. Ensure you have your Authenticator app available (i.e., Google Authenticator, Chrome Authenticator, etc.) and use the DWRS code that appears above any other instance associated with the DWRS.

When prompted, scan the QR code image that appears on the screen.
As the authenticator scans the barcode (QR Code), a six-digit verification code will appear/register in your authenticator app. Copy the code.
Paste or type the six-digit code in the input field, then click “Submit” to go to the next page.

This is a one-time process to re-authenticate your new account password. Following this update, continue to use the existing Verified User Log In Process for DWRS access.

Helpful Section Links from the User Guide

Password Reset Process

First-Time User Log In Process

Verified User Log In Process

Data Warehouse Report Server User Guide

Email & Password Reset Support

Put a note about problems or issues with colleges/districts that have email issues - direct them to Support. Authentication (use the code on top) or use local time.

For help using the Report Server, please refer to the Data Warehouse Report Server User Guide.