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.
Why use Amazon Web Services for data storage? AWS provides big data at a small cost, offering one of the most full-featured and scalable data solutions.
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 Whitelist, software files should be set up from a computer that can access the whitelisted 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.
System Requirements
You install the driver on client computers accessing an Amazon Redshift data warehouse. Each computer where you install the driver must meet the following minimum system requirements:
Mac OS X version 10.6.8 or later
215 MB of available disk space
iODBC Driver Manager version 3.52.7 or later. For more information about the iODBC driver manager and links to download it, go to the Independent Open Database Connectivity website.
An Amazon Redshift master user or user account to connect to the database
Installing the Amazon Redshift Driver on Mac OS X
Use the steps in this section to download and install the Amazon Redshift ODBC driver on a supported version of Mac OS X. The installation process will install the driver files in the following directories:
/opt/amazon/redshift/lib/universal
/opt/amazon/redshift/ErrorMessages
/opt/amazon/redshift/Setup
To install the Amazon Redshift ODBC driver on Mac OS X
Download https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.6.1000/AmazonRedshiftODBC-1.4.6.1000.dmg. The name for this driver is Amazon Redshift ODBC Driver.
Then download and review the Amazon Redshift ODBC Driver License Agreement. If you need to distribute these drivers to your customers or other third parties, please email [email protected] to arrange an appropriate license.
Double-click AmazonRedshiftODBC.dmg to mount the disk image.
Double-click AmazonRedshiftODBC.pkg to run the installer.
Follow the steps in the installer to complete the driver installation process. You'll need to agree to the terms of the license agreement to perform the installation.
Important When you have finished installing the driver, configure it for use on your system. For more information on driver configuration, see Configure the ODBC Driver on Linux and Mac OS X Operating Systems.