RapidIdentity Studio Plug-in for PowerSchool

Identity Automation has created a plugin and data provider combination that allows school districts using PowerSchool to pull rostering data into RapidIdentity Studio for extract, transform, and load capabilities.
The plugin entity is installed locally on the PowerSchool instance, and allows for the use of specified data and endpoints defined within. These endpoints were developed using PowerSchool's PowerQuery mechanism, which is an augmented version of the SQL query language, used specifically for their systems. By triggering one of these endpoints, the PowerQuery denoted within it is executed and the data is returned through REST as a JSON object.

Prerequisites

• A RapidIdentity tenant licensed to operate the Studio module
• A RapidIdentity tenant that is at version 2022.4.5 or higher
• Access to a PowerSchool system through its Admin Console
• Access the most recent version of the Plugin

Installing the Plugin

1. Log in to your PowerSchool system through the Admin Console.
   

   1. Usually, this falls to /admin. You will be presented with the landing page pictured.

   2. Navigate to the Plugin Management Dashboard.

      1. Start Page > System Administrator > System Settings > Plugin Management Dashboard

   3. To Install and select the plugin.zip file from the data provider + plugin files.

   4. If you are prompted, select to Enable the plugin. Otherwise, enable it by selecting it from the list of plugins on the dashboard.
      

   5. Select the RapidIdentity Rostering Plugin from the list of plugins, then select Data Provider Settings.
      

      1. Take note of the Client ID and Secret, as these will be used to configure the Provider Application in Studio.

Installing and Configuring the Data Provider

1. Log in to your RapidIdentity tenant and navigate to the Studio module. Click the Add Application button in the top right corner and select From App Library to begin
   

2. Search for "powerschool" and click thePowerSchool (Power Query) provider application that appears.
   

   1. A dialog menu will open on the right.

      

   2. Click Install to begin the installation process.

   3. Each application in the Studio module is assigned a unique prefix in the system. This prefix is automatically selected for you. You can choose to change the prefix if you want, however it must be unique, from 1 to 16 characters long, begin with letters and capitalized.
      

   4. Click Install when ready.

3. Enter the Connection Settings for the PowerSchool plugin
   

   1. Substitute in your values for Base URL, Client ID, Client Secret, and Access Token URL, then click Save.

      Note:

      The connection setting information comes from the PowerSchool plugin

   2. The enrollments record definition requires a specific input to fetch the proper school year. To set the school year on the enrollments record:

      1. Click Advanced to open the advanced settings section of the PowerSchool Provider application

      2. Click the kebab menu to the left of the POWERSCHOO-enrollments record and select Details
         

      3. PowerSchool uses a 2 digit numeric to represent the current school year. For example, 32 is the value for the 2022/2023 school year. To set the 2022/2023 school year on the enrollment record, enter {"yearId":31} in the DATA field.
         

4. Click Save when done.

5. Navigate to the Jobs tab and configure the Powerschool (PowerQuery) import jobs to fit your processing needs.
   1. Scheduling jobs to run on a regular basis is ideal, but starting a run independent from the scheduler will allow for data access sooner.

Once the jobs have been run, you can use the Data Explorer tab to navigate through the individual data provider and ID Hub tables.