Canvas DataMart - Details and Connectivity steps

Please follow the below steps when you are connecting to Canvas DataMart for creating Jasper Reports or for adhoc queries

Canvas DataMart - Details

1. Canvas provides the warehouse data through REST API
2. CanvasDataMart follows Star Schema. DataModel and related details can be found in the following url: https://portal.inshosteddata.com/docs
3. 'CanvasDataImport' job imports the data and maintains the canvasDataMart database.
4. 'CanvasDataImport' job is deployed in Talend Console and is scheduled to run at 0715 ET everyday. Average runtime is around 10 minutes. The DB will not have data when the tables are truncated and the data is inserted. This is expected to be less than 5 minutes
5. All the tables other than 'Requests' tables have historical data while the Requests table is limited to 1 day
6. There are alternate mechanisms available to maintain the historical data which can be accomplished using alternate designs
7. CanvasDataMart currently utilizes MySQL database

Canvas DataMart - User Procedures

1. When any new user is created,
   1. Assign the relevant grants
   2. Assign the maximum number of connections

Steps for Connecting to CanvasDataMart

The following steps list the procedure for connecting to CanvasDataMart DB using MySQL Workbench. The steps are similar for any mechanism (java ojdbc, tools like MySQL Workbench, JasperReport Studio etc)

1. Download MySQL workbench for your OS version and install in your machine. This can be found in the following url: https://dev.mysql.com/downloads/workbench/
2. Open the workbench and select 'MySQL Connections +' icon
3. Provide the following details
   1. Connection Name - Your preferred connection name
   2. Connection Method - 'Standard (TCP/IP)
   3. Host Name: spinup-000460.yu.yale.edu
   4. Port: 3306
   5. Username: <xxxxxx>
   6. Password: <xxxxxx>
   7. Default Schema: CanvasDataMart
4. Please contact 'Vijayshree Erodula' or 'Kate Hathaway' for Username & Password

Related articles