Background

This Metro Housing Authority is in the public sector industry. It maintains a central data system, which has an average of 300 users at any given time accessing the database for both production and reporting demands. 

Use Case

The Metro Housing Authority found that because so many users were accessing the database, they began to receive reports of poor performance from many different directions. Because the database was being used for both applications as well as reporting data, the system was not able to keep up with both demands.  

Donald Butler, IT Manager, decided that the best way to solve his problem was to split the database into two: one for applications and one for reporting. For this to work, the reporting database would have to mirror a subset of the tables used in the applications database from time to time. 

Enter Astera Centerprise

Since the Metro Housing Authority system used SQL Server 2005 database servers, Butler first tried SSIS. He found the tool too complicated to use and turned to Centerprise. 

Astera Centerprise is a high-performance, scalable data integration platform that allows businesses to meet today’s advanced data needs. Powered by an enterprise-grade, parallel processing engine, Centerprise offered the Metro Housing Authority data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform. 

Centerprise was exactly what Butler needed. Mirroring the correct tables was a snap and in no time, he found that Centerprise’s ability to insert new records and update existing records was easy and could even be automated. Butler began leveraging Centerprise for other applications outside of its original purpose. Centerprise quickly became an everyday utility which automated more and more of their data management tasks. 

The Metro Housing Authority chose Centerprise because it was a cost-effective option that provided all the functionality needed, as well as a user-friendly interface that enabled Butler to quickly and easily split his database into applications and reporting, as well as take on other data management tasks. 

Profile  

This Metro Housing Authority manages a central data system accessed by over 300 users at any given time. 

Industry 

Government/ Public Sector 

Use Case 

Because so many users were accessing the central system for production and reporting, the IT team received many reports of slow performance and poor functionality.  

Product

Astera Centerprise  

Application  

With Centerprise, the Metro Housing authority was able to split the central data system into two different databases for reporting and analysis. The company specifically needed the reporting database to mirror tables from the application database, a functionality provided by Centerprise.  

Result   

Centerprise has quickly become an everyday utility at the Metro Housing authority and is even being used in other applications across the company.  

Learn more about Astera Centerprise 

Ready to Learn More?