AnsweredAssumed Answered

Most Efficient Way to Auto-Sync Canvas Data With MySQL Database?

Question asked by Brett Sheeran on Apr 4, 2018
Latest reply on Apr 5, 2018 by Brett Sheeran

Hi,

I'm looking for the most efficient way to auto-sync Canvas Data with a MySQL database

 

Any suggestions?

 

Details as follows.

MySQL is on a Linux instance. We don't require all data, I gather request table is huge. At the moment we need maybe a dozen tables.

 

Currently, I've installed this library:

Canvas Data Cli

https://github.com/instructure/canvas-data-cli

 

And am manually running these Bash & SQL commands

 

canvasDataCli fetch -c config.js -t enrollment_term_dim


canvasDataCli unpack -c config.js -f enrollment_term_dim

 

delete from enrollment_term_dim;


LOAD DATA LOCAL INFILE '/opt/canvas-data/unpackedFiles/enrollment_term_dim.txt' INTO TABLE enrollment_term_dim FIELDS TERMINATED BY '\t' ESCAPED BY '\b';

 

However, I'm concerned that delete all is rather a brute force approach. I have searching for various alternatives. However, while I see plenty of alternatives, I'm not sure which might best meet our needs:

 

Canvas Data Loader

https://github.com/instructure/canvas-data-loader

 

Canvancement

https://github.com/jamesjonesmath/canvancement

 

Py Canvas Data

https://github.com/kajigga/py_canvas_data

 

Canvas Data SDK

https://pypi.python.org/pypi/canvas-data-sdk/

 

Any suggestions?

 

Regards

 

Brett S

Outcomes