Hi We are currently downloading the daily Canvas data files into our own SQL server data warehouse. We're using power BI to start creating reports/dashboards. Would be really interested in connecting with anyone in similar situations to discuss practice and share any findings
Let's get some visibility on your call for collaborators, email@example.com! I've shared this with the https://community.canvaslms.com/groups/canvas-developers?sr=search&searchId=1303ea1c-3729-4367-80d8-... and https://community.canvaslms.com/groups/admins?sr=search&searchId=ff0e8cb1-3887-486c-9ba6-ee7bd39ec2c... groups, and have also shared it into the https://community.canvaslms.com/community/answers/data?sr=search&searchId=56b35aee-a55c-4556-9f2a-3e... space. And, since it's a prompt more likely to elicit open-ended discussion than a single correct answer, I've flipped the format over to a discussion post.
Hi! We have two https://community.canvaslms.com/community/ideas/canvaslive?sr=search&searchId=3c10439d-5ce3-453b-a06... sessions coming up on https://community.canvaslms.com/community/answers/data?sr=search&searchId=35eeb267-8c3f-4384-9816-8c... you might want to RSVP to or follow for more information. If you have any questions about the events, feel free to post them in the comments section at the links below so the host has the opportunity to respond. Hope to see you there!
Oct. 5 9:30am MDT / 11:30am EDT
Oct. 10 12pm MDT / 2pm EDT
Thanks Adam, Stephanie. Currebtly exploring the data and conducting some basic modelling. We've just gone live with Canvas so it is a very busy time and as a result my time to explore is limited. I'll take a look at these and definitely share anything that I find
We're pretty new to Canvas Data too, and it sounds like we are on the same track as you. Currently we have a test VM spun up and I've successfully downloaded/imported the CD files. My next step will be working on the modeling/reporting. I'd love to hear how your progress is coming.
Hi all -
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, 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?
I just landed this page while searching on ways to connect canvas reports to Power BI.
I am incredibly new to the canvas, but I do see a Developer Keys section in there that allows creating API Keys.
I am hoping to connect Power BI using the Web Data source and providing the URL. I am running into some challenges doing the same, but I learned more on API to get ideas on that.
Has anyone else tried that approach?
I have not seen this approach before. The way I'm getting Canvas information into our power bi is one of two ways.
I then connect our PBI to our SQL to run queries for of our reports we have in PBI. This also allows us to connect Canvas data with our SIS to be able to produce more in depth reports.
Can you please detail a little bit on how you are moving the report's data into SQL? Is it using SISS?
My first thought was to move the data into SQL but then I saw the Developer key option in the canvas as I got the admin access.