A major campus within a New England state university system has been on the forefront of a major trend now unfolding in enterprises worldwide – the migration of applications that don’t require specific database management capabilities of Oracle® onto less costly open source solutions such as EDB Postgres Enterprise®.
The deployment of EDB Postgres Enterprise from EnterpriseDB® (EDB™) in 2008 was prompted by the university’s adoption of PeopleSoft and a consolidation of its data infrastructure. The campus had been supporting a local Oracle database and needed a more robust environment.
As the lead engineers examined their database needs during this process, they determined that EDB Postgres Enterprise could easily support multiple applications, including several PeopleSoft apps, the campus information portal, and a series of applications developed in-house — at a fraction of the cost of Oracle. The data is largely comprised of sensitive student information used for real-time applications.
EDB Postgres also powers a number of third-party apps that don’t have a direct PeopleSoft connection. EDB Postgres is the database of record and information is exported into the appropriate PeopleSoft applications as needed.
“We all love it,” said the university’s lead engineer. “Postgres is more robust than MySQL and it’s SQL-standards based so it worked seamlessly within our environment. Deployment took a couple of hours. One day we did some development, the next we rolled it out into production. Then it was a matter of re-pointing the data configurations and everything continued to work.”
Another significant factor in the campus’ decision to partner with EDB was EDB’s support in setting up a hot standby. In order to create a backup scenario, the campus was facing the high price tag of the Oracle RAC solution, with even higher costs for support in setting up the configuration. EDB provided an on-site expert to set up a duplicate system that could be deployed in about 10 minutes, which exceeded the university’s needs.