Oracle Fusion dataset hub
HCM Data Hub
Extract, stage, and query curated HCM data from Oracle Fusion — people, assignments, benefits, payroll, timecard, and GL. Splash BI–style foundation with data marts, semantic metrics, and optional PostgreSQL loading.
At a glance
Oracle Fusion dataset hub — extract, stage, and analyze.
Built for Oracle Cloud HCM teams.
Extract from Fusion
BIP catalog reports and SQL runner extracts — scheduled, repeatable, no extra cloud required.
Stage & load
CSV staging per domain with optional PostgreSQL gold marts for dashboards and APIs.
Analyze & govern
Semantic headcount and turnover metrics, row-level security, and REST bronze sync.
How it works
Three steps to value
Connect Fusion & probe extracts
Configure HCM credentials and verify BIP SQL runner with the bundled SAAS Tool catalog.
Extract domains on schedule
Run nightly extracts to data/staging/ — people via BIP report, other domains via SQL runner.
Query marts & push to EPM
Serve gold marts via API, explore in the UI, and optionally push headcount to Oracle Planning.
Data domains
Curated Oracle Fusion datasets
Each domain has proven extract SQL and staging paths.
| Domain | Source | Primary extract |
|---|---|---|
| People | HCM | Employee Master BIP catalog report |
| Assignments | HCM | Active employee roster |
| Benefits | HCM | Active benefits enrollment |
| Payroll elements | HCM | Payroll element entry values |
| Timecard | HCM | HXT timecard matrix |
| General ledger | HCM / Payroll GL | Payroll cost allocation GL |
| EPM | EPBCS / Planning | Headcount push to Planning (stub) |
Capabilities
Features
HCM Data Hub extracts curated Oracle Fusion datasets — people, assignments, benefits, payroll, timecard, and GL — into staging and optional PostgreSQL marts with semantic metrics and row-level security.
Dataset catalog
Curated domains with full SQL under extracts/sql/ — proven patterns from Oracle HCM reporting.
Data marts & dashboards
Employee, absence, payroll, and timecard marts with a React UI for exploration and sync history.
Semantic layer
Headcount, terminations YTD, and turnover rate by business unit, country, and department.
Row-level security
API-key auth with business-unit and country filters; PII redaction for non-admin queries.
REST bronze sync
REST entity catalog with workforce-tier sync and run history.
Lean architecture
One Node process, optional local or managed Postgres — no BigQuery, Airflow, or LLM spend.
Get started
Get started with HCM Data Hub
Contact us for a demo, deployment, and dataset rollout on your Oracle Fusion tenant.
Contact Us
Tel: 419-322-0280 or 734-345-3433
16801 Newburgh Road, Livonia, MI 48154