Air Force Knowledge Services

The US Air Force has more than 327,000 active personnel and nearly 5,600 aircraft, as well as missiles and satellites around the globe.

“Before Air Force Knowledge Services, there wasn’t visibility on a timely basis. It might have taken weeks or months to extract that information manually out of all the stove-piped transaction systems.”

— Mike Riley, Program Manager, Air Force Knowledge Service


Business Need

Keeping the fleet in repair and ready to fly.

Lower the cost of delivering defense services.



Air Force analysts needed to pull information manually from different databases and information systems and compile it in spreadsheets.

Integrate 26 discrete source systems and databases.

Improve speed and availability of data access.

Introduce reporting tools and dashboards.


Solutions & Results

Recouped $300,000 in excess equipment in one week.

Shortened reporting time from six months to less than an hour.

Enabled end users to generate approximately 20,000 reports a week.

Identified more than $600 million in excess parts.


Technologies Used

Informatica PowerCenter

Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hard coding.

Success Stories

State of Washington

Enhancing service quality and efficiency across the infrastructure with Informatica Data Integration Hub

Florida Turnpike Enterprise

Reduced time to deliver reports on issues such as revenue, traffic, violations and safety from up to three months to four hours.

The Netherlands Ministry of Defense

Deployed PowerCenter to standardize data migration methodology for greater efficiency.