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)…
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-220.127.116.11.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-18.104.22.168.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)