Our institution is wanting to take a look at Canvas Data to see what kind of information we can pull out of it. I have looked around the Canvas community quite a bit to learn more about the data portal and what it offers. I have seen how to download and sync data with the Canvas CLI tool, and it seems straightforward. I do have a few questions though to help us get moving forward.
- With the CLI tool, does it append the new data from the previous day to the tables, or does it override the old tables with new tables?
- How do I get all historical data?
- Has anyone tried to automate an import into a database running MS SQL?
- If this isn't a good option, then what would be a good alternative? We are wanting to us MS SQL because that is what we are used to using.
Thank you for your help?