Versions Compared

Key

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

This CCC Data Warehouse User Documentation for use by the California Community Colleges

Note

This user guide supports implementation of the Canvas DW Direct Connect implementation for the CCC Technology Center service, exclusively for California Community Colleges faculty and staff.

...

Introduction

The purpose of this guide is to provide colleges with an overview of the Canvas DW Direct Connect implementation process and the preparatory information steps required for colleges to successfully access their Canvas API data in the CCC Data Warehouse.

Note

Canvas Data is currently only available and accessible to colleges via DW California Community Colleges via CCC Data Warehouse (DW) Direct Connect service.

About Canvas Data in the CCC Data Warehouse

[ description of the availability of Canvas data in the DW via direct connect. ]In May 2021, the CCC Technology Center will deliver the ability for college Canvas Data to be added to the CCC Data Warehouse/Data Lake. Access to this data will be available by direct access connection (ODBC/JDBC) only until further notice.

Canvas DW Direct Connect Service

The Canvas DW Direct Connect service allows colleges to access their Canvas data in the CCC Data Warehouse/Data Lake through direct access connection (site-to-site VPN). Colleges must “opt-in” or request access separately, even if they are in a multi-college district.

Colleges must officially request (opt-in) may request to implement this exclusive service . To (opt-in, please ) by email. Please contact Enabling Services at the CCC Technology Center.

...

To participate in the Canvas DW Direct Connect service - to access your college Canvas data in the CCC Data Warehouse via direct access connection - the authorized IRPE at your college or district must send an email to Enabling Services requesting to implement the service.

The email subject line should read, “Request for Canvas DW Direct Connect at [college]”.

The CCC Data Warehouse is now able to provides the ability for colleges to access their Canvas data by direct access connection (VPN) in the CCC Data Warehouse/Data Lake.

Access to their Canvas data is available by Direct Access Connection (ODBC/JDBC) only in the v.2.1 release.

Each college must “opt-in” or request access , each college must request to implement the service (opt-in) separately, even if they are in a multi-college district.Colleges must contact their CRM to request direct access to Canvas data.

To request your college's Canvas data be included in your instance of the Data Warehouse, contact your college's College Relationship Manager (or email crms@ccctechcenter.org if you do not know who your CRM is). The inclusion of Canvas data will require each college in a multi-college district to opt into its inclusionopt-in, the authorized IRPE at your college or district should 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 first step in the process is to add Canvas DW Direct Connect implementation process has two steps: first, your Canvas data will be added to the CCC Data Warehouse in order using the Canvas Data API , and then we configure the ability for your college to access it the data via direct access connection. To do that, an authorized Canvas Admin at your college must generate the

To get your data into the CCC Data Warehouse, the CCC Technology Center will use the Canvas Data API which requires your unique API credentials (key and secret values) in a specific the format that works with the structure of your Canvas account.

To generate your college’s Canvas Data API credentials, follow the steps below. Once the credentials are generated, a copy of the credentials should be captured for security purposes, and safely passed to the CCC Technology Center in a secure manner.

...