Data & Integration

Manage EPM Data Management mappings directly from Excel: review, edit, and maintain mapping tables in the grid where mapping work naturally belongs — no more exporting, editing, and re-importing through the web UI.

• Every location is listed on Load, and mappings are keyed by rule name rather than stamped with the location. Rows that share a Data Management key are highlighted.
• Save to EPM sends only the delta since Load as a MERGE. Because MERGE cannot update an existing row, an edit escalates to a per-dimension REPLACE — and a REPLACE shows what it will overwrite before it runs.
• Syntax is validated against Oracle's predefined rules before submission, with a versioned automatic backup to roll back to. Every control is documented in-product, with a mapping reference guide.

Visualize your Data Management integration pipelines end to end — sources, transformations, and targets in one interactive graph. Understand at a glance how data flows into your application.

Analysis and monitoring of Data Management integration logs. Point it at your integration runs and it surfaces failures, anomalies and slowdowns — before users file tickets.

• Overview digest and a real chat over the logs — ask why 4,000 rows did not load and get the mapping at fault, not a log excerpt. These two need a configured LLM API key; everything below works without one.
• Incremental log load through a parsed-log index, an in-place refresh with lookback, and a log cache shared with the Performance Investigator, so the same process log is never downloaded twice.
• Safe re-run of a load rule with polling and an editable period range. Concurrent re-runs are prevented, and a recoverable error state with retry never strands a loaded dashboard.

The Integration Agent's dashboard, usable without an AI key: each load rule's run as an import → transform → export funnel with inline kickouts, source / not-loaded / kickout columns, a trend chart across runs, and a safe re-run of the load rule over an editable period range. Any short load is explained in seconds, and the fix happens in the same window.