[ARCHIVED] How to load all the Canvas dimension and fact tables directly to a MS SQL database

[JiaqiCheng]

Hi, Canvas team,

We extracted 93 tables from Canvas by using the CLI tool. Now we want to load all the tables to an MS SQL database while still keeping the same names and data relationships like the STAR schema created by the Canvas platform.

Wonder whether the Canvas team has already developed some API tools for loading these tables to a SQL-like database or we need to load all the tables by ourselves like using Python SQL database connectors.

Thanks. 

[mzimmerman · Accepted solution]

Hi @JiaqiCheng 

You might have a look at the Canvas Data Loader app over in Github:  https://github.com/instructure/canvas-data-loader