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 Data Pipeline Builder

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 Astera Data Pipeline Builder. 

Astera Data Pipeline Builder 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, Astera Data Pipeline Builder offered the Metro Housing Authority data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform.  

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

The Metro Housing Authority chose Astera Data Pipeline Builder 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.