Versions Compared

Old Version 11

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version 12

changes.mady.by.user Patricia Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note

The following support information 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 have resulted in new URLs 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 verification processused when they first created their accounts.

Panel
bgColor#F4F5F7

Next Steps: All existing DWRS users should refer to the change table below which provides an overview of next steps depending on user type.

On This Page

Table of Contents
minLevel1
maxLevel7

Changes by User Type

Panel
bgColor#FFFAE6

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 Usersbelow.

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

  1. New URL for direct access (non-IdP) users*

  2. User account’s Password must be reset (one-time process)

  3. User account’s Email address must be valid (associated with user account) to receive the password reset link.

  4. 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 Usersbelowfor steps to reset your passwordand 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.

Panel
bgColor#FFF0B3

Find your new Data Warehouse Report Server URLsand bookmark your new link.

Use Institution Credentials: College/district users will now be using their existing institution’s IdP sign-in credentials (email, password, etc.) to effectuate single sign-on. An important note: the user’s email address must match the one stored in the DWRS system, typically the one used to create the account initially. If that email address changes at any time, please contact CCCTC Support to update this information in the DWRS system.

Note

NOTE: Your email address in your college/district IdP must match the address stored 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.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

The Data Warehouse Report Server User Guide has been updated with all changes and new functionality resulting from releases v.2.2.0 and v.2.3.0, including the new Password Reset Process.

Update Process for

Existing User Accounts (non-SSO)For all external users

Direct (2FA) Users

For existing DWRS users signing in with multi-factor authentication (non-SSO) such as Chancellor’s Office, CVC/OEI, or other external stakeholders, a one-time user account update is required due to the security updates enhancements implemented in Release v.2.2.0 require a one-time update for existing accounts. Follow the instructions below to ensure your account is updated and verified.

Below is the process at a glance:

  • Your new 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

  1. Navigate to the new URL for the DWRS: https://dw-reports.ccctechcenter.org/jasperserver-pro/login.html

  2. From the Sign In page, click the Forgot Password? link.

  3. Enter the email address that was used to create your existing account.

  4. A success message should appear on the sign in page.

  5. 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.

  6. On the Change/Update your password screen, enter a new password and repeat the password to confirm. Click Continue.

  7. Back on the Sign In page, enter your valid email address and new password in the input boxes. Click Submit to continue.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#FFFFFF

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.

Panel
panelIconId2699
panelIcon:gear:
panelIconText⚙️
bgColor#F4F5F7

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.

  1. When prompted, scan the QR code image that appears on the screen.

  2. As the authenticator scans the barcode (QR Code), a six-digit verification code will appear/register in your authenticator app. Copy the code.

  3. Paste or type the six-digit code in the input field, then click “Submit” to go to the next page.

Panel
panelIconIdatlassian-check_mark
panelIcon:check_mark:
bgColor#F4F5F7

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

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

The Data Warehouse Report Server User Guide has been updated with all changes and new functionality resulting from releases v.2.2.0 and v.2.3.0, including the new Password Reset Process.

Email & Password Reset Support

For help updating your email or password in your DWRS account, please contact CCCTC Support for assistance.

Note

NOTE: All DWRS user accounts must contain the user’s valid email address. Please direct any issues or errors encountered to CCCTC 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.