Dayalan Punniyamoorthy Blog

Showing posts with label My Dream Project. Show all posts
Showing posts with label My Dream Project. Show all posts

Wednesday, July 29, 2026

My Dream Project - Building EPM Connector: A Single Console for Oracle EPM Cloud

 Building EPM Connector: A Single Console for Oracle EPM Cloud

How I built a lightweight, AI-assisted control center for Oracle EPM Cloud — using Oracle's own documented REST APIs.


The Thought Behind This

If you've worked with Oracle EPM Cloud (Planning, EPBCS, PBCS, or FCCS), you know the drill: metadata lives in one place, data exports live in another, job statuses require a separate check, and activity history is scattered across logs and console screens. Every task — checking a data load rule, running an Essbase export, reviewing whether last night's job actually finished — means jumping between different tools and screens.

Honestly, it's the kind of friction you stop noticing after a while. You just accept that "checking on things" means five tabs open at once. It wasn't until I found myself doing the same five-tab dance for the third client environment in a row that I actually stopped and asked: why am I still doing this manually?

As an Oracle EPM consultant working across multiple client environments, I wanted one thing: a single console where I could authenticate once and handle the day-to-day operational work — without writing a new script every time I needed a quick answer.

That's what led me to build EPM Connector.