About the Organization
The National Institutes of Health is the nation's medical research agency, part of the U.S. Department of Health and Human Services. The Center for Scientific Review (CSR) division handles peer review of grant applications — a critical function supporting billions of dollars in research funding.
Leadership needed analytics capabilities from their grant application databases, but the existing systems had no API layer — and the complexity and cost of re-architecting federal systems made a full rebuild impractical.
The Challenge
NIH faced significant constraints in meeting leadership's analytics requirements:
No API layer for existing data: Before DreamFactory, there was no way to expose the grant database to business intelligence tools — data was locked in SQL Server databases without REST API access.
Federal system constraints: Re-architecting existing systems to add native API capabilities would require extensive procurement, security review, and development cycles — potentially years in a federal environment.
Leadership analytics demand: Executive leadership needed BI dashboards and analytics reports from grant application data, requiring real-time API access that didn't exist.
Security and compliance: Any solution needed to operate within NIH's on-premises government environment, meeting federal security requirements for sensitive grant and research data.
The Solution
DreamFactory deployed as an on-premises API platform in NIH's government environment, with production and development instances:
Microsoft SQL Server connectivity exposing multiple databases for grant application data through auto-generated REST APIs — without modifying the underlying database systems.
On-premises deployment meeting federal security requirements, operating within NIH's existing infrastructure and security perimeter.
BI tool integration providing the API endpoints needed for business intelligence dashboards and analytics reporting requested by leadership.
Production and development environments enabling the team to test and iterate on API configurations before deploying to production — following federal change management best practices.
The Results
System re-architecture avoided: NIH gained API access to grant databases without the multi-year, multi-million dollar effort of re-architecting existing federal systems.
Leadership analytics delivered: Executive leadership now has BI dashboard access to grant application data through governed API endpoints, enabling data-driven oversight of the peer review process.
Federal compliance maintained: On-premises deployment within NIH's government environment meets all federal security and compliance requirements for sensitive grant data.
Rapid deployment: The API layer was operational far faster than a full system re-architecture would have allowed — meeting leadership's analytics needs on a practical timeline.
The NIH deployment demonstrates DreamFactory's ability to add modern API capabilities to existing government systems without the cost and complexity of full re-architecture — a critical capability for federal agencies operating under procurement and budget constraints.
