"It all comes down to a need to document the full lifecycle of data from the time of application until the student no longer has an affiliation with the university. Centerprise has made the whole process WAY easier."
Scott Lowe, IT Consultant
Established in 1970 to focus on higher education for the Jewish community, this university system has grown to serve a widely diverse population of over 19,000 students across 32 schools in 5 countries. The university is uniquely attuned to the importance of an education that accommodates students from all backgrounds and circumstances. From liberal arts to law, health sciences to technology, business, Jewish studies, education—and everything in between—this university provides educational opportunities and career paths to not only the most talented and motivated students but also those who have been overlooked and underserved, who have the drive and potential to succeed.
The university system uses a DB2/AS400-based ERP system to host student information, while the financial aid system uses a SQL server-based data storage system. In order to comply with federal student aid programs authorized under Title IV of the Higher Education Act (HEA) of 1965, the university needed to keep its student data up to date, accurate, and complete within its financial aid system.
Since the two systems needed to have students’ data in sync, the IT department had implemented an integration solution that was a mix of hand coding and disparate software products. This solution worked in some cases, but it was difficult to manage and maintain. For example, if a new field from students’ data needed to be brought into the financial aid system, it took a long time and hours of developer coding to make changes in the implementation.
The university needed a single solution that would integrate and maintain student data from both the ERP system and the financial aid system, keeping it current and accurate, as well as ensuring it met Title IV requirements. The solution had to enable IT to make changes to and update the data in both systems quickly and automatically, without hours of custom coding.
Implementing Centerprise, the university was able to replace all of the the hand coding and disparate software products being used to extract and transform student data. Thanks to its superior usability, Centerprise integration projects can be designed in a matter of hours and modifying the system takes just a few minutes. With the Centerprise built-in scheduler, student data from the ERP system is sent to the financial aid system every night, keeping the data complete and accurate.
Astera provided a complete solution in a single interface that met all of the university's technical data integration needs and was affordable for a non-profit educational institution. The software's advanced data extraction and transformation capabilities allowed the university to overcome its challenges for keeping both systems updated, and the Centerprise scheduler automated the process of keeping the systems in sync.
Astera brings powerful data management and application integration solutions within reach of any organization. Astera's open source solutions for developing and deploying data management services like ETL, data profiling, data governance, and MDM are affordable, easy to use, and proven in demanding production environments around the world. For organizations looking to jump-start a big data initiative, Astera provides applications that accelerate data loading and other aspects of Hadoop setup by enabling developers and analysts to leverage powerful Hadoop technologies like Hadoop Hive, Pig, and Sqoop without having to write Hadoop code. Astera's ESB and data services infrastructure solutions extend proven Microsoft technologies like WCF and MSMQ to deliver affordable, flexible service enablement of distributed applications. To help enterprises improve operational performance, Astera also offers packaged solutions that support business process modeling and simulation as well as rapid development, testing, and deployment of process-oriented applications..NET, SQL Server and all Microsoft-related trademarks are the property of the Microsoft, and are used with permission.