How can I use SQL to extract data on Powerschool

tshu
Padawan

How can I use SQL to extract data on Powerschool

Hi,

I found a post saying i can connect SQL developer (like oracle) to get write SQL query on powerschool. but im stuck on step 6, cause I dont know the IP address of the database server in hostname. Anyone know how can I find that?

 

Or is there a simply one you guys been using SQL to extract data on Powerschool. DDE just too inadequate for me.

Thanks.

13 Replies
JeromeO
PowerSchool Champion
PowerSchool Champion

You'll need to either ask your IT team if you're self-hosted or PowerSchool support if remote-hosted.

-----------
Troy School District, Troy, MI, USA
District Size: 13,000+
Server Config: On-prem/Self-hosted 3 app+1 db+2 test

I am not a PowerSchool employee

jtechaira
Journeyman

Have you had any progress since your post? I've reached out to PS multiple times and not able to obtain any back access. I've requested multiple times because the UI is so terribly written. 

 

Appreciate the update if you have one, in advance.

 

Thanks.

JeromeO
PowerSchool Champion
PowerSchool Champion


@jtechaira wrote:

Have you had any progress since your post? I've reached out to PS multiple times and not able to obtain any back access. I've requested multiple times because the UI is so terribly written. 

 

Appreciate the update if you have one, in advance.

 

Thanks.


Are you a technical contact for your district? How have you submitted your previous requests, and what was PS support's response (if any)? Also, have you seen this article?

https://help.powerschool.com/t5/PowerSchool-SIS-Administrator/Hosting-Services-FAQ/ta-p/62650

 

 

-----------
Troy School District, Troy, MI, USA
District Size: 13,000+
Server Config: On-prem/Self-hosted 3 app+1 db+2 test

I am not a PowerSchool employee

ItsOnlyDoug
PowerSchool Champion
PowerSchool Champion

Another plugin to check out would be SQL Studio built by @AdamLarsen it drops a query editor right into PowerSchool. It use it almost daily. It's much quicker than having to fire up developer if you are just making quick queries.



Doug Skinner

District Instructional Data Officer
Gateway Regional School District


Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution.


jtechaira
Journeyman

Can you please provide the link? This sounds like it would be pretty helpful. I really need the functionality like SQL where you can query data. The UI of powerschool is very poorly written where with even admin access you cannot write query or do IF statements.

 

JeromeO
PowerSchool Champion
PowerSchool Champion

@jtechaira :

 

https://auroraedtech.com/

 

(note, however, that this is read-only SQL; this does not permit you to run DELETE or UPDATE queries)

-----------
Troy School District, Troy, MI, USA
District Size: 13,000+
Server Config: On-prem/Self-hosted 3 app+1 db+2 test

I am not a PowerSchool employee

jtechaira
Journeyman

I appreciate the information. I am getting 404 errors on the SQL studio. Maybe it got removed / no longer available.

 

 

JeromeO
PowerSchool Champion
PowerSchool Champion

@jtechaira It still exists (trust us 😉 ).  Use the menu bar to find it.

-----------
Troy School District, Troy, MI, USA
District Size: 13,000+
Server Config: On-prem/Self-hosted 3 app+1 db+2 test

I am not a PowerSchool employee

jtechaira
Journeyman

Thanks, I did use the menu bar still same results. Also tried alternate browser to no success. I will try Apex and check on Aurora later maybe it will be back up.

JeromeO
PowerSchool Champion
PowerSchool Champion

It's not down or unavailable. The carousel banner link DOES point to the wrong URL, but neither the product nor the site is "down." I don't think you went deep enough through the links if you used the menu bar at the top and couldn't find it.

 

2021-05-07 08_37_52-SQL Studio.png

-----------
Troy School District, Troy, MI, USA
District Size: 13,000+
Server Config: On-prem/Self-hosted 3 app+1 db+2 test

I am not a PowerSchool employee

kenyonsb
Journeyman

I don't know if I can advertise a third party plugin that interfaces extremely well with Powerschool but I will because it's a very useful plugin that my District uses daily.

 

See this website https://www.freundresources.net/

 

I have created dozens of SQL Reports and charts that takes the need for the admin and teachers to design their own using the PowerSchool report generators. Each report can be assigned to a section on the SQL Reports menu. There are addition templates that can be created for form letters and Charts. There is a free version and a subscription version.

HeatherWeist
PowerSchool Champion
PowerSchool Champion

Enterprise Reporting (APEX) is a feature built in PowerSchool. It is basically Sql on steroids. I have used it to create Attendance Reports for each of my elementary schools, where it pulls the days absent and custom fields to show if a 5, 10 or 15 day letter has already been sent an attendance warning letter. I've also create some very specific reports for our nurses. 

 

Here is an article explaining it in more detail and explaining the setup process. 

 

Enterprise (APEX) Reporting 


Heather Weist, M.S.E
PowerSchool Specialist, Westside Community Schools, Omaha, NE (K-12, ~6000 students)

PowerSchool Mentor/Champion



Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!
jtechaira
Journeyman

Thank you for the reply this is really helpful. Support definitely have never mentioned this to me. Bad thing is we are not hosted we run it on our local servers so may have to use a VPN or ODBC connection to access.