Overview

This information will be used by teachers who wish to connect Gripper to a hosted PowerSchool database.

Note: All information needed for step two has to be obtained from the School Admin or District Admin in the case of an onsite instance or can be collected from the SAAS team of where ever the school has hosted the PowerSchool SIS instance.

The DB details mentioned in the KB are for the SIS system. SchoolLoop offers a paid service to provide schools with a tab-delimited or CSV file (termed as Import file) to be imported into their PowerSchool SIS by using the Gripper tool.

Reference Information

1. Set up a VPN Connection. Pearson provides this connection.
2. Obtain the following information about the database:
   • The IP address;
   • Port number;
   • SID for the PowerSchool database.
3. Edit Gripper.bat in the Gripper folder. Replace the default port number (1521) if necessary and replace PSPRODDB with the database SID in the java line:
   ava -DjdbcCon=jdbc:oracle:thin:%%s/%%s@%%s:1521:PSPRODDB