Enterprise data integration
Empower API
An ASP.NET Core 8 API for querying Waters Empower 3 data stored in Oracle, with schema tracking, documented endpoints, and container deployment.
DATA → SERVICE → APPLICATION
Oracle→ASP.NET
Core API→OpenAPI
Enterprise data, connected.Core API→OpenAPI
Overview
From problem to working system.
Empower API provides a documented service layer over Waters Empower 3 data in Oracle. It combines focused query endpoints with SQLite schema tracking, background services, structured request logging, and a Docker-based runtime.
Inside the project
- Purpose-built endpoints for querying Waters Empower 3 data
- Oracle data access with SQLite schema metadata
- Swagger/OpenAPI documentation and structured Serilog logging
- Background services and a multi-stage Docker build