If you have spent any time around enterprise reporting, you know exactly where things tend to break. The numbers are fine, but the hierarchies are off. Two teams run the same report and get two different structures. A spreadsheet works beautifully in Finance and behaves mysteriously in Operations. Many times, the issue is not the data. It is the metadata behind it.
Dodeca’s new Oracle Enterprise Data Management (EDM) Connector helps to narrow that gap.
What the EDM Connector Does
At a high level, the connector takes governed metadata from Oracle EDM and makes it available directly inside Dodeca. The data is live, structured, and ready to use.
Dodeca calls the EDM REST API and runs real operations against the source. This is not a cached export, a file someone refreshes once a day, or a CSV sitting on a server that might or might not be current.
Instead, the connector:
- Identifies the EDM viewpoint extract you want.
- Executes that extract on demand.
- Retrieves the results as a CSV payload.
- Converts that payload into a Dodeca dataset you can drop into a view, selector, or range.
In simple terms, EDM produces a governed extract and Dodeca converts it into something immediately usable.
The result is live, authoritative metadata appearing inside the user experience without maintenance work.
Why Viewpoint Extracts Matter
The connector does not generate metadata or interpret EDM logic. It relies on viewpoint extracts that are already defined and controlled inside EDM.
This brings several advantages:
- Data governance teams remain the source of truth.
- Dodeca consumes only what EDM intentionally exposes.
- Report structures stay aligned with enterprise definitions.
If someone adds a member to a hierarchy in EDM, that member appears in Dodeca the next time a user opens the view. No rebuilds, no refresh processes, and no questions about outdated structures.
A major architectural choice is that the connector runs only when needed. There is no staging layer, no nightly sync, and no brittle integration pipeline. When a user opens a view:
- Dodeca calls the EDM REST endpoint.
- EDM runs the viewpoint extract.
- The results stream back as a CSV.
- Dodeca renders the data immediately.
It feels less like integration and more like native access to governed master data.
Security and Access
The connector supports the security patterns large organizations rely on:
- Delegated authentication using SSO so the user’s own credentials are applied.
- Service accounts when access needs to be controlled centrally.
This flexibility allows organizations to choose the access model that fits their governance structure without changing how views are built.
Built for Iteration
The connector is built on Dodeca’s extensible connector framework introduced in version 8.4. This matters because:
- The EDM connector ships as its own module.
- Enhancements can be delivered quickly.
- Real-world customer use cases can drive new functionality without waiting for a full platform release.
This is not simply a feature. It is part of a shift in how Dodeca approaches enterprise integration.
Possible Use Cases in Dodeca
The real value of the EDM Connector appears when you start applying governed metadata inside the places where users actually work. A few common patterns stand out:
Dynamic Selectors that Never Go Out of Date
Selectors for Entities, Products, Accounts, or Cost Centers can now be fed directly from EDM. This keeps reports aligned with current structures without anyone updating a list manually. This can be leveraged in both selectors and report layouts. Imagine never having to update a report because an Account was added more moved.
Driven Cascades for Mass Reporting
Cascades can use EDM driven lists to create a full reporting package across every node in a hierarchy. If a new business unit is inserted in EDM, the cascade automatically incorporates it on the next run.
View Templates Aligned to Enterprise Structures
Templates that rely on controlled hierarchies such as P&L outlines or management reporting dimensions can now use EDM as the structural source. This keeps the logic inside templates clean and predictable.
Audits and Reconciliations
Dodeca views can surface EDM metadata for quick audits and reconciliations. This is useful for identifying structural gaps, missing parent assignments, or members that have not been promoted through governance workflows.
Ad Hoc Exploration
Power users often need to look at the current state of a hierarchy without logging into yet another system. Dodeca can provide that window using the same viewpoint extract the governance team maintains.
These are only starting points. Any place where metadata drives the user experience is a candidate for live EDM powered content.
The Bigger Picture
Bringing EDM into Dodeca fits into a larger direction:
- Modern, modular connectors in version 8.4 and above.
- Cloud friendly and REST native integration patterns.
- Real time access to governed enterprise structures.
- Metadata treated as a first-class component of the reporting environment.
This is not only about adding another data source. It is about making governance visible and useful inside the tools people use every day.
Final Thought
Enterprise metadata has long been handled behind the scenes. With the EDM Connector, that metadata can finally flow into the reporting layer where it has always belonged.
TLDR
The new Dodeca EDM Connector brings live, governed metadata from Oracle EDM directly into the reporting layer. It runs viewpoint extracts in real time, so selectors, cascades, and templates always reflect the current enterprise structures. There are no staging tables, sync jobs, or manual updates. The result is reporting that stays aligned with master data by design. This matters because accurate reporting depends on governed metadata and the EDM Connector is a practical way to bring that information directly into a tool that can be deployed to your entire organization.
