...
About the CCC Data Warehouse
In May 2021, the ability for authorized California Community College to add and access their college Canvas Data through the CCC Data Warehouse/Data Lake was made available by the CCC Technology Center. Access to this data is by request (opt-in), and is only available via direct access connection (ODBC/JDBC)CCC Data has been developed by the CCC Technology Center in coordination with, and at the direction of, the CCC Chancellor's Office.
A part of the Data Services Program initiative from the California Community Colleges Chancellor's Office, CCC Data provides the necessary infrastructure to the California Community College System to aggregate data across disparate systems to an enterprise data warehouse (CCC Data Warehouse).
| Info |
|---|
Access to [CCC Data Warehouse] data is provided to institutional researchers, college and district administrators, and other decision makers at the 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. |
Canvas DW Direct Connect Service
...
Colleges may request to implement this exclusive service (opt-in) by email. Please contact Enabling Services at the CCC Technology Center.
...
College Participation
The CCC Technology Center (CCCTC) Enabling Services group will support the connection of Canvas data to the Data Warehouse, to be made available through a Direct (ODBC/JDBC) Connection. Support for Canvas data will require that the administrator for the Canvas system generate a data API key, to be securely passed to the Enabling Services Integration Engineer.
California Community Colleges that have adopted Canvas CMS may request to implement the Canvas DW Direct Connect service through Enabling Services at the CCC Technology Center. To get started, colleges must meet the following prerequisites and complete the instructions below.
...
College requests to participate (Opt-In) in Canvas DW Direct Connect.
College generates and submits the required Canvas Data API key values to CCCTC Enabling Services
College works with the Enabling Services implementation team to confirm successful access to their Canvas Data using their established direct access connection.
| Note |
|---|
The Canvas DW Direct Connect implementation has two configuration steps: first, your college Canvas data is added to the CCC Data Warehouse using the Canvas Data API and your college’s unique credentials; and second, access to the data is configured through DW direct access connection. |
Step 1: Email a Request to Participate (Opt-In)
To participate in the Canvas DW Direct Connect service, each college must request to implement the service (opt-in) separately, even if they are in As the Canvas Data API key is generated at the root account level, implementation will require each college in a multi-college district to consent to have their Canvas data made available in the CCC Data Warehouse.
To participate (opt-in
...
), send an email to Enabling Serviceswith the following subject line:
...
Request for Canvas DW Direct Connect at [college]
...
.
| Note |
|---|
Data Security: For security reasons, access to the CCC Data Warehouse must be requested and managed by the Institutional Research, Planning, and Effectiveness (IRPE) lead at each college and district (as authorized by the department VP, when the IRPE lead is not the VP). IRPE requests should be submitted to your CRM at Enabling Services at the CCC Technology Center. |
...
Step 2: Generate Your Canvas API Credentials
The Canvas DW Direct Connect implementation process has two steps: first, your Canvas data will be added to In order to make your Canvas Data accessible in the CCC Data Warehouse using the Canvas Data API , and then we configure the ability for your college to access the data via direct access connection. To get your data into the CCC Data Warehouse, the CCC Technology Center will use the data must be added using the Canvas Data API - which requires your the unique API credentials (API key and secret values) in the format that works with the structure of your Canvas account.
...
College Canvas Admin: Generate the following Canvas Data API credentials in your Canvas Admin Portal:
| Note |
|---|
Once the Tech Center receives the data API key, the data pipeline will be configured so that the college's Canvas data is securely passed to the CCC Data Lake and CCC Data Warehouse; after which it will be updated nightly. |
| Note |
|---|
The Way Canvas API Credentials Work |
...