PowerSchool ODBC

Mr YanLNetwork Administrator
Network Admin in education setting. Manage all aspects of network for our small-medium size environment. Jack of all...yet to master one
Published:
Updated:
PowerSchool SIS ODBC
Was learning the PowerSchool app and as luck would have it, I came across a Q&A thread that immediately addressed and solved a problem I was having.

So, I thought I would write this Article to help other net admins that work in a education environment. The thread I cited as a reference (appears below) was a little confusing, so wanted an easy walk through for people. This will be more relevant as one of the major players in account provisioning (Kimono) is “getting out of the game”. Thousands of school districts across the nation use PowerSchool  (Oracle db) and there will be many others who need to configure this exact solution.

On client machine (not the system containing database; the system that’s going to pull the data instead)…

You need 3 downloads:

  1. Instant Client Package - Basic
  2. Instant Client Package – ODBC
  3. Microsoft Visual Studio 2017 Redistributable 
 
http://www.oracle.com/technetwork/topics/winx64soft-089540.html


  • Create a new folder (i.e. c:\Drivers\oraclepsODBC)
  • Unzip contents of “Basic” package to created folder
  • Unzip contents of “ODBC” package to same created folder (combine duplicate folders; files from ODBC package should be in same directory as basic package contents) (i.e. EVERYTHING including odbc files should be in here…. C:\Drivers\OraclePsODBC\instantclient-basic-windows.x64-19.10.0.0.0dbru\instantclient_19_10) 
  • Right-click odbc_install.exe and open properties.
  • “Unblock” installer on general tab and click OK
  • CMD as administrator and change directory to location you created and combined like folders (i.e. cd c:\oracle\odbc\instantclient-basic-windows.x64-19.10.0.0.0dbru\instantclient_19_10\)
  • Type odbc_install.exe and hit enter

 ODBC driver should now be installed and ready for use
 
You can now create a DSN (ODBC data source) connection on the client workstation.
Type ODBC in your start menu and choose the appropriate (x86 vs x64) result.

On the System DSN tab, click Add...
Choose the Oracle instant client driver you installed and click Finish.

TNS Service Name = IP:Port
User ID: PSNavigator

Click Test Connection

Default PowerSchool DB : PSPRODDB
Default PowerSchool DB user : PSNavigator
Default PowerSchool port : 1521 (i.e. xxx.xxx.xxx.xxx:1521)


Once the driver is installed and the DSN created, you can connect to the database via different methods. Some schools may elect for a third party, such as the popular choice ClassLink, to handle provisioning. However, some schools may not have the necessary funds for such a solution. In that case you can even use Microsoft Excel to connect to the database.
 
Referenced and Credit to:
Solved: ODBC Access to PowerSchool (Oracle) | Experts Exchange (experts-exchange.com)
https://silo.tips/download/powerschool-student-information-system
0
1,826 Views
Mr YanLNetwork Administrator
Network Admin in education setting. Manage all aspects of network for our small-medium size environment. Jack of all...yet to master one

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.