Work with Skyward to deploy OpenEdge Pro2 to add an extra layer of security to allow students, administrators, guardians and teachers to view student information without compromising personal information.
System administrators for the whole district can pull data from the district's database for over 3,000 users and are enabled to reutilize preexisting reports from their previous system and convert them into new ones while using Pro2 with SQL Server Management Studio makes querying and updating data easier.
Encompassing 52 different schools in the Northeast region of Texas, the Mesquite Independent School District (ISD) is dedicated to educating close to 40,000 students across several grades. As such, the Mesquite ISD requires top-of-the-line software and hardware to keep things running smoothly for students but also for those working on the backend, including system administrators, developers and IT professionals.
Lane King, Director of Information Systems at Mesquite ISD, has said the district “has always been on the cutting edge of technology” and has been a part of three significant database solution changes. Its last one, Crystal, was used to manage its extensive database and systems, until 2014 when the solution eventually went to its end-of-life cycle.
King and other system administrators began researching solutions to help store and manage system data that also provide robust reporting capabilities. Since the district’s systems encompass several unique data sets, users require a tool to help obtain it quickly. Additionally, King spoke about the data reporting requirements set by the state.
“Our goal ultimately is to find the best software provider that would provide everything that the district needed regarding student data,” says King. “And in Texas, one of our big things is the state reporting requirements, which are extensive. We looked for a solution with a proven history of accurately providing the state reporting requirements we needed."
Our goal ultimately is to find the best software provider that would provide everything that the district needed regarding student data, and in Texas, one of our big things is the state reporting requirements, which are extensive. We looked for a solution with a proven history of accurately providing the state reporting requirements we needed.
Lane King
Director of Information Systems at Mesquite Independent School District
Since the system administrators at Mesquite ISD had previously worked with SQL databases, King wanted to find a solution to match the skillsets of the team. King and his team began discussing solutions with Skyward, a school database management software company, and discovered Progress® OpenEdge® Pro2.
After Skyward deployed OpenEdge, King and his team created a link server, which connected to various information ports — ranging from on-campus related data, such as staff information, to more business focused ones, like financial systems. They received an improved insight into what happens within these parts of the system.
Mesquite ISD was also able to better serve students, teachers, guardians and administrators. Information from the database needed to be used by those groups and a 3rd party vendor while respecting the private nature of the data. Mesquite ISD's system administrators created "views" to allow information deemed pertinent for users without compromising social security numbers and other private information. This became an extra layer of security around student information.
System administrators with Mesquite ISD have been utilizing OpenEdge® Pro2 to effectively manage their database, which helps make several data-related jobs more streamlined.
In one use case of OpenEdge® Pro2, the system administrators have increased accessibility and usability. For example, they can pull data from various sets, querying or searching for it via the SQL Server Management Studio. Additionally, the staff can take this data and send it back to requesters much easier.
Lane politely declined when asked if they would change their solution choice, as his organization reliably uses OpenEdge's Pro2 for replication to SQL server to manage its ever-growing database efficiently.
"If we didn't have Pro2, I think we would be stuck. We rely too much on SQL to go another direction," says Lane. "We'd have to find something that would replicate that data so that we could report on it accurately. I can't say what would've happened in the past, but I can tell you we probably wouldn't be where we are today without it."
If we didn’t have Pro2, I think we would be stuck. We rely too much on SQL to go another direction. We’d have to find something that would replicate that data so we could report on it accurately. I can’t say what would’ve happened in the past, but I can tell you we probably wouldn’t be where we are today without it.
Lane King
Director of Information Systems at Mesquite Independent School District