Canvas Data files should be used to create queried reports in ODBC analytics tools. Common tools include Tableau, SQL Workbench/J, Excel, and R. Analytics tools can also access the Redshift database.
As part of the Canvas Data Portal, the Canvas Data Schema includes documentation that explains all the table data that is exported from Canvas. This documentation shows all the available files and the data in each file.
For full Canvas Data use, data files should live in a database. Once you have downloaded your institution's flat files, table headers must be added to the files before analysis can be run through your preferred database.
If your institution does not have its own data warehouse, Amazon Redshift is available as a premium option to host and run analytical data. Please contact your Customer Success Manager for more information.
When using an IP Address Allowlist, software files should be set up from a computer that can access the allowlisted IP address.
For help with using Canvas Data in various software platforms and sample queries, please view the Canvas Data Group in the Canvas Community.