Skyward SMS 2.0

Abstract

Overview of Skyward SMS 2.0, a student and business management software for K-12 schools, aimed at enhancing compliance, efficiency, and communication.

Skyward, a leading provider of student and business management software for K-12 leaders, empowers district-wide compliance, operational efficiency, and open communication between schools and families. Skyward's Student Management Suite - supported by industry thought leadership and best practices - is helping districts everywhere improve outcome, reduce costs, and achieve success.

About

Vendor

Skyward

Product

SMS 2.0

Integration Type

PowerShell

Links

Functionality

Table	Key	Read	Create	Update	Delete
<Table Name>	--

Recommended Relations

Referencing Table	Foreign Key	Parent table	Primary Key

Configure Connection

This integration uses a database connection via Progress OpenEdge Driver 11.7+. Please see documentation provided by vendor

Using Client VPN

Warning

When a VPN is necessary for connection to the database, then it is recommended to use a site-to-site VPN for reliability.

This example shows how to open the Cisco AnyConnect VPN prior to connection to the database

Create config file to open vpn (e.g. connect.txt)

connect vpn-1.iscorp.com
idofgroup
thisismyusername
thisismypassword
y
quit

Create bat file to open vpn (e.g. OpenVPN.bat)

cd C:\Tools4ever\Scripts
taskkill /S localhost /im vpncli.exe /f /t
taskkill /S localhost /im vpnui.exe /f /t
"c:\program files (x86)\Cisco\Cisco AnyConnect Secure Mobility Client\vpncli.exe" -s < connect.txt

Create bat file to close vpn (e.g. CloseVPN.bat)

cd C:\Tools4ever\Scripts
"c:\program files (x86)\Cisco\Cisco AnyConnect Secure Mobility Client\vpncli.exe" disconnect

In this section:

NIM