Upcoming Webinar

Join us for a FREE Webinar on Automating Healthcare Document Processing with AI

October 2, 2024 — 11 am PT / 1 pm CT / 2 pm ET

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. 

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

Application  

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

Result   

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

Ready to Learn More?