AnsweredAssumed Answered

API data in SQL Server Data Warhouse

Question asked by Paul Johnson on May 13, 2019
Latest reply on Jul 22, 2019 by Raj Veeravalli

Hi all - 


I may just not have entered the proper search parameters in Google to get this, so, I'm going to post it here.  If this has been answered already, please direct me to the proper place.


We are brand new to Canvas - coming over from Blackboard (thank goodness!!).  We are also a Microsoft shop and will be putting the Canvas API data into a SQL data warehouse.  I just started with using the canvasDataCLI node.js tool and have our tables downloading and unpacking - super easy!!  The next thing I need to do is put them into SQL Server.  I was going to use an SSIS solution to get the unpacked data to the database, but will need to build up my tables and relationships.  I can certainly do that by hand, but may take quite some time. 


Does anyone have a set of scripts that can create the blank SQL Server schema needed for the API data to load into?