Page Comparison

...

...

Canvas Data in the CCC Data Warehouse

The CCC Data Warehouse can optionally support the inclusion of Canvas data. When a college (or district) elects to have their Canvas data added to the CCC Data Warehouse, these data can then be accessed through a direct connection (secured through the use of a site-to-site VPN). As Canvas data is managed at a district level, each college in a multi-college district may need to opt-in for their data to be supported in the DW. Colleges may request to implement this service by contacting their College Relationship Experience Manager (CRMCEM) through CCCTC Enabling Services.

...

College Participation

California Community Colleges that have adopted Canvas may requestto implement the inclusion of their Canvas data in the CCC Data Warehousethrough Enabling Services at the CCC Technology Center.

...

...

Implementation Process Overview

1. College requests to participate through their College

...

1. Experience Manager.

2. College generates and submits the required Canvas Data API key values to CCCTC Enabling Services

3. College works with the Enabling Services implementation team to confirm successful access to their Canvas Data using their established direct access connection.

...

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.

1. To participate, send an email to Enabling Serviceswith the following subject line: Request for their Canvas data be added to the CCC Data Warehouse.

2. The College

...

1. Experience Manager (

...

1. CEM) will process your request and pass your interest to the Enabling Services Implementation team who will work with your college to facilitate the Canvas to Data Warehouse setup process.

...

From the Admin section of your Canvas application:

1. Open Your Account: Click the Admin link in your Canvas application, then click on the name of your account or sub-account.

2. Open Canvas Data Portal: In Account Navigation, click the Canvas Data Portal link.

3. Create API Credentials: Click the Create Credentials button. A success notification with your API credentials will display.

...

4. Copy API Credentials: Once API credentials are created, copy the API Key and API Secret and prepare to pass to the Implementation Engineer at the CCC Technology Center.

...

Step 3: Configure the Format of Your Canvas API Credentials & Send Them to CCC Technology Center

1. To facilitate the process of adding your Canvas data into the Data Warehouse, provide your API Key and Secret values to your ES Implementation Engineer in the format shown below. These values should be passed using a secure method such as Privnote.
   

   1. Canvas Data API Key: [canvas-datawarehouse-<misCode>-apikey]
      ^{(Replace <misCode> with your college MIS code, and replace “apikey” with your Canvas API key value generated for your specific Instructure account.)}

   2. Canvas Data API Secret: [canvas-datawarehouse-<misCode>-apisecret]
      ^{(Replace <misCode> with your college MIS code, and replace “apisecret” with your Canvas API secret value generated for your specific Instructure account.)}
      

2. Upon receipt of your API values, your ES Implementation Engineer will facilitate the process of adding your Canvas data into the CCC Data Warehouse with the CCCTC DevOps team.

...

Creating New API Credentials: You can create new credentials by clicking the Create Credentials button again.

...

To create a new Canvas Admin user, follow the directions below:

1. To add a user as an admin, you must assign the user to an account role. Before adding a user, ensure that you have created the necessary account-level role.

2. Open the Account: In Global Navigation, click the Admin link, then click the name of the account you want to add a user to.

3. In Account Settings, click the Settings link.  

4. In Settings, click the Admins tab. The Add Admins Account button will display.

5. Click the Add Account Admins button.

6. Add an Account Role and Email.

   1. In the Add More drop-down menu, set the admin role type. The default admin role in Canvas is Account Admin which has access to all account-level permissions. You can also create admin roles for your institution and manage their permissions.  

   2. In the text box, type the email address of the new user.

   3. Click the Continue... button.

   4. Add Account Admins.

      1. Verify the user you added is listed in the admin field.

      2. Select the OK Looks Good, Add this [#] User button to add the admin.

      3. Click the Go back and edit the list of users link to adjust any errors. A message will appear in your browser.

7. Verify the new user administrative user was added.

...

...

...

Step 4: Work with the ES Implementation Team to Test Access & Query Canvas Data Sets

1. After your Canvas data has been added to the CCC Data Warehouse, the ES Implementation Engineer will guide you to connect to the CCC Data Warehouse through your established DW Direct Connect (ODBC/JDBC) and access your Canvas Data either through your local BI application (typically Tableau or Power BI) or an SQL query.

2. Once connected, test connection to your Canvas data using your local BI data application, and attempt to run at least one query against the Canvas Data set.

...

FAQ: Direct Access to Canvas Data in the CCC Data Warehouse

...

From the Admin link in the Canvas Data Portal navigation bar:

1. Open Account: Click the Admin link, then click on the name of the Canvas account or sub-account.

2. Open Canvas Data Portal: In Account Navigation, click the Canvas Data Portal link.

3. Create API Credentials: Click the Create Credentials button.

4. Copy API Credentials: Copy the API Key and API Secret. If you return to the Credentials Portal, you will be able to see the API Key but not the API Secret.

5. Create New API Credentials: You can create new credentials by clicking the Create Credentials button.

...