Content Comparison

...

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 because of the size (as per canvas)
6. There are alternate mechanisms available to maintain the historical data which can be accomplished using alternate designs
7. CanvasDataMart currently utilizes MySQL backenddatabase

Canvas DataMart - User Procedures

1. When any new user is created,
   1. Assign the relevant grants (preferably select grants alone)
   2. Assign the maximum number of connections

...

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

...