Developers Improve Responsiveness and Productivity at National Defence Department
Australian Defence Materiel Organisation (DMO) System Program Offices must retain and access maintenance and engineering records to help ensure the safety and airworthiness of hundreds of aircraft. Obtaining reports from the database took several days—potentially jeopardizing the Air Force's responsiveness. Aging systems became costly and difficult to maintain, and DMO sought a solution. DMO contracted Apt Business Solutions to develop NetMAARS, an enterprise maintenance intelligence solution based on Microsoft® SQL Server™ 2005 Enterprise (64-bit) Edition and SQL Server Reporting Services. Four Apt Business Solutions programmers completed the solution in only 15 months. They experienced smoother development and debugging by using Microsoft Visual Studio® 2005 Professional Edition, and the Microsoft .NET Framework 2.0. Users now report faster reporting and increased productivity.
The Defence Materiel Organisation (DMO) consists of members of the military and civilians in the Australian Public Service whose mission is to equip and sustain the Australian Defence Force.
Business Situation
DMO needed to improve data access and replace aging systems, including its mission-critical air fleet maintenance database.
Solution
DMO engaged Apt Business Solutions to develop a business intelligence and reporting solution that relies on Microsoft® SQL Server™ Reporting Services and Microsoft SQL Server 2005 Enterprise (64-bit) Edition.
Benefit
Smoother development and debugging
Increased productivity
Better responsiveness
Hardware
Software
Feature: Reporting Services
Microsoft .Net Framework 2.0
Microsoft Office Access 2003
Microsoft Office Excel 2003
Microsoft Office Outlook 2003
Microsoft Office Word 2003
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft Visual Studio 2005
Microsoft Windows Server 2003 Enterprise Edition
Quote
"New features in SQL Server Reporting Services, such as multiple select controls, give report developers a lot more flexibility in the way that they construct report requests."
