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

New security measures were implemented for the Data Warehouse Report Server in the CCC Data Warehouse 2.2.0 version release that will impact existing user accounts (only), requiring a one-time update for external users and a new URL for college/district accounts using SSO.

Below are 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 6 quick steps to reset your password and re-authenticate their existing account.	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:

New DWRS URL - bookmark it
Your email address must be valid and match your account address in our 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 DWRS URL:
On the Sign in to your account page, click on the Forgot Password? link.
Enter the email address that was used to create your existing account. If you cannot remember the email address used, or if the address has changed, please contact CCCTC Support to manually update the credential in your 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.
Open your Google Chrome or other Authenticator application and rescan the QR code that appears on the screen.
Enter the verification code

First-Time User Log-In Process

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.

FAQs

All other user account types (non-SSO users) must complete a one-time update process for their existing accounts
From the DWRS Sign in page via the new DWRS URL (should redirect the user, but not sure):
- Enter your Email Address
Confirm account Email address is valid and updated in our system (KC).
- Ensure the Email Address entered is the one used during account creation. This is needed to validate and reset password (one-time).
- If email is no longer valid or is forgotten, the user should contact CCCTC Support to update the email address in their user account. The user should then return to the Sign In page.
On the Sign In page, click on the Forgot Password? link, enter your email address and Submit.
Retrieve Reset Password email and click the verification link. Add and confirm a new password when the Update Password page appears.
Return to Sign In page and retry logging in with email and new password.
Ensure
Continue
Enter email address and