using filemaker pro for powerschool reporting tim scoff tim@scoff.net

Using FileMaker Pro for PowerSchool Reporting

Tim Scofftim@scoff.net

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

© Tim Scoff

Permission to re-use in whole or in part is hereby granted for any and all purposes

Thank You