Key Takeaways from 2024
Learn how AI is transforming document processing and delivering near-instant ROI to enterprises across various sectors.
Case Study
Metro Housing Authority Uses Astera to Split the Central Data System into Two Databases.
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
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.
Astera 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 offered the Metro Housing Authority data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform.
Profile
This Metro Housing Authority manages a central data system accessed by over 300 users at any given time.
Industry
Government
Use Case
The company specifically needed the reporting database to mirror tables from the application database.
Results
With Astera, the Metro Housing authority was able to split the central data system into two different databases for reporting and analysis. Astera has quickly become an everyday utility at the Metro Housing Authority and is even being used in other applications across the company.
Astera was exactly what Butler needed. Mirroring the correct tables was a snap and in no time, he found that Astera’s ability to insert new records and update existing records was easy and could even be automated. Butler began leveraging Astera for other applications outside of its original purpose. Astera quickly became an everyday utility which automated more and more of their data management tasks.
The Metro Housing Authority chose Astera 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.
Authors:
Irfan Ahmed
Company
Partners
Customers
Support
Copyright © 2025 Astera Software. All rights reserved.