Infinite Campus¶
| Vendor: | Infinite Campus |
|---|---|
| Frequency: | Nightly |
| Method: | SQL queries are added to Infinite Campus’ Data Extract Utility. Exports are run nightly transferring CSV files to the Landing Zone SFTP server. Data is transformed and sent to the Ed-Fi ODS via the API. |
Initial setup¶
Airflow connections¶
Our DAGs look for two Airflow connections:
edfi_api
- Login: your Ed-Fi key
- Password: your Ed-Fi secret
sftp_landing_zone
- Conn type: SSH
- Host: Landing Zone SFTP address
- Username: Landing Zone SFTP username
- Password: Landing Zone SFTP password
- Port: 22
Configuration¶
Data we pull¶
Schools¶
School names for each site, their physical address, and grade levels served
Sessions¶
Terms for the school year.
Marking Periods¶
Grading periods for the school year.
Calendar dates¶
Academic calendar for the year noting which days are instructional days and which are not.
Courses¶
Course information.
Course Enrollments¶
This is a comprehensive export of the things needed to associate students and staff with class sections. This includes locations, class periods, course offerings, sections, student associations, and staff associations.
Staff¶
Staff demographics and school assignments.
Student Demographics¶
Student demographics, program info, and enrollments.
Student Attendance¶
All day student attendance events. This export includes whether a student is in attendance for a school day.