CCC Data Warehouse User Documentation for use by the California Community Colleges
Introduction
The purpose of this document is to outline the ES implementation process required to support colleges access their Canvas API key data in the CCC Data Warehouse.
Canvas Data in the CCC Data Warehouse
[ description of the availability of Canvas data in the DW via direct connect. ]
About Canvas DW Direct Connect
Direct connection
College Participation & Implementation
Requesting to Participate
Send request to CRM team at the CCC Technology Center (Opt-In)
Work with Enabling Services implementation team
Obtaining & Submitting Canvas API Information
Obtain and submit your college’s Canvas API token and secret key
Admin Credentials
DW Direct Connect Implementation
Testing Access to Canvas Data
Support FAQs
CCC Data Warehouse User Documentation
Instructions
Follow the steps below to initiate custom implementation for each college:
ICE team will work with the college to identify their Canvas Administrator who will be asked to generate the Canvas data API key to be securely transmitted to the Tech Center.
College locates and submits their unique Canvas API key to the ES team
College Canvas Admin / Pilot participant will connect to the CCC Data Warehouse through ODBC/JDBC connection (secured through the use of a site-to-site VPN), and accessing the Canvas data either through a local BI application (typically Tableau or Power BI) or SQL query.
ES member creates InterVision SNOW ticket and attaches API key for custom configuration process.
The Canvas API Access Token
Support FAQs
Q. How do I obtain an [Canvas] API access token in the Canvas Data Portal?
A. Colleges can review this page for instructions and other information related to their custom API access token.