About
a1222252
Rank:
Community Participant
Joined:
Aug 8, 2016 6:36:55 PM
Posts:
65
Solutions:
0
Likes:
69
Bio:
Member of the Planning and Analytics team at The University of Adelaide. BSc in Electrical and Electronic Engineering from the University of Sussex 1979. Various IT roles prior to my current role both in employee and consultant capacities. Primary recent experience is database focussed with extensive experience of Oracle products including specialist skills in E-Business Suite deployment.
Most Liked Posts
Hi,The gz files for all tables except for requests change daily so we sync and unpack them all. The ODI mappings are all truncate / insert. I'm not aware of any way to segregate incremental data, I th...
Hi,To expand on Daniel's response, we download daily from the Canvas Data Portal using the canvasDataCli tool. This is then uploaded into an Oracle database and presented as views in the data lake tha...
Hi everyone,I've been working on making the requests data more usable by deriving ids for all course elements rather than just the four provided in the raw requests data. I thought I would share some ...
Hi Rick,We have also been looking at this issue for some time.We implemented Canvas in mid-2016 and our requests table is now approaching 2 billion records. Early on Instructure advised that this volu...
Hi All,We use Oracle Data Integrator to upload the Canvas Data tab-delimited files into an Oracle database. It allows conversion of a text string to a CLOB if a field exceeds the 4,000 character limit...
Most Recent Posts
@Edina_Tipter I note that the format of the web_logs table has been changed recently to include the user_agent value, the same as CD1 requests. Previously the web_logs table only contained the user_ag...
@Edina_Tipter I should add that we are currently using dap 0.3.8.2. We are awaiting an upgrade to 0.3.11. Is there any documentation regarding the changes introduced with newer versions?
Thanks, Stuar...
@Edina_Tipter Hi Edina, we are in the process of testing CD2 downloads and have found some issues. I've sent details to isaiah.alamani@instructure.com and to the support desk.
1. Performance of the da...
@Edina_Tipter Thanks for the update. Does that mean student activity generated using apps is not recorded in the database, and is only available using requests data?
@Edina_Tipter we were doing some work around most recent student activity and found that pseudonym_dim.last_request_at reports the last request generated by browser-based activity and does not take ac...
Latest Badges
Elf Panda
Thanks for engaging in the community in 2021! Your use of ed-tech in your professional career and educational journey continues to inspire us.
2021-12-08
Courageous
The first step to building trust in an online community is being vulnerable. Thanks for having the courage to write your first post. #NoJudgment
2021-08-16
Present
When a question or thought is posted in the forums, you respond with feedback or follow-up. Thanks for being present by posting 10 forum replies!
2021-08-16
