Transcript Using FileMaker Pro for PowerSchool Reporting

Using FileMaker Pro for
PowerSchool Reporting
Tim Scoff
[email protected]
Who am I?
Technology Director
10+ Years FileMaker Pro Development
5+ Years PowerSchool Admin
Gymnastics Instructor
Connecting FileMaker Pro to
Oracle
External SQL Source
ODBC Driver
Oracle’s Driver for Windows
Actual Technology’s Driver for OS X
PowerSchool’s Tables
https://powersource.pearsonschoolsystems.com/
Data Dictionary SIS Views
Data Dictionary Tables
PowerTeacher Gradebook Data Dictionary
PowerSchool’s Custom Fields
Records, not fields
Access using views
PVSIS_Custom_Students
PVSIS_Custom_Teachers
Access directly
Complicated, but faster
Sample Report
Homeroom student counts by building
PowerSchool SQL Query
PowerSchool SQL Query
FileMaker Sub-Summary
FileMaker Sub-Summary
FileMaker Sub-Summary
FileMaker Sub-Summary
FileMaker Sub-Summary
FileMaker Sub-Summary
Security
What passwords to use
System -> Setup -> Security -> Database Security
Security
Security risks
PowerSchool’s default passwords are well known
“DELETE FROM Students;” works
PowerSchool’s License Agreement
Read-Only Access
Never edit Oracle directly
Thank You
© Tim Scoff
Permission to re-use in whole or in part is hereby
granted for any and all purposes