Setting Up a SFTP Connection
Introduction
To successfully transmit report data to the CT SEDS for processing, an SFTP connection to a state-managed server must be defined within PowerSchool. Once the setup below is complete, school districts are able to upload the following reports for submission automatically:
- Student Contacts Report
Establishing an SFTP Connection
The SFTP Setup can be found by navigating to the following page in PowerSchool:
Navigation: Go to District Start Page, System, System Settings, Plugin Management Configuration, Remote Connection Manager, Remote Connection Manager and then click Create Connection.
To define the necessary connection, populate the following fields:
Field | Details | Required |
---|---|---|
Name | Define a name for this connection | Y |
Description | Enter a description for this connection | N |
Protocol | Select SFTP from the dropdown | Y |
Host | Enter the IP of the state server (Expected value: secureftp.pcgeducation.com) | Y |
Port | Enter the port number for the connection authentication (usually 22) | Y |
Authentication Type | Select the authentication type from the drop-down
| N |
Username | Enter your district number as the username for the connection | Y |
Password | Enter password | Y |
Confirm Password | Confirm password Note: Once the above fields have been populated, click Test Connection to verify that the connection is successful | Y |
Key Certificate Alias | Not applicable | N |
Finger Print | Not applicable | N |
Remote Path | Enter the file path to store the files (Expected value: imports) | Y |
Allow Download | Not applicable | N |
Allow Upload | Select the Allow Upload checkbox to allow extracts to be uploaded from the PowerSchool server | Y |
Running Reports with SFTP
To run a report using the newly establish SFTP connection, navigate to the desired report and select the SFTP connection on the report input page. For help with navigation and running the report, see How to Find and Generate a Report.