How can I use SQL to extract data on Powerschool

[tshu]

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.

[JeromeO]

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

[jtechaira]

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]

---

@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

[ItsOnlyDoug]

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.

[jtechaira]

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]

@jtechaira :

https://auroraedtech.com/

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

[jtechaira]

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

[JeromeO]

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

[jtechaira]

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]

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.

[nteeters]

@JeromeO - hello! Do you subscribe to the premium version of SQL Studio? Have you had any issues?  Thanks!

[JeromeO]

We do not.

[ItsOnlyDoug]

We also do not, but I do have the free version installed. This is where I test different queries before I try to build Apex reports, I just find a it a little faster than creating a brand new report in Apex out of the gate.

[kenyonsb]

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]

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 

[jtechaira]

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.