Externalizing security in Oracle Data Integrator

Hello everyone, I have been meaning to write this tutorial for a long time, but got stuck with work and other commitments. Well, better late than never I guess. Oracle has started allowing us to use third party authentication in its flagship integration product ODI since version 11g. This article …

Installing stand-alone Essbase client on Linux/Unix

A former colleague of mine reached out to me recently with an interesting request. He wanted to know how to install Essbase client on one of his Linux servers so that he can write batch scripts and call them using startMaxl.sh. I didn't quite understand why he needed my help. …

DRM EPMA Integration

If your organization is using Oracle Data Relationship manager for data governance and master data management, there is a good chance you are also using Oracle Hyperion suite for budgeting, reporting and consolidation applications. Some of the clients I worked for use Enterprise performance management architect to create and manage …

Oracle General Ledger Integration with Hyperion Data Relationship Management

Oracle DRM and Oracle Ebusiness Suite serve two different purposes in any organisation. While DRM acts as the metadata management tool, Ebusiness suite is used to run the core business of the organisation. Traditionally, metadata, i.e. segment values, hierarchies etc are shared between DRM and EBusiness suite using text or …

Integrated workflow in Oracle Data Relationship Management

One of the main drawbacks of earlier versions of Oracle DRM was the fact that you need significant efforts to build work-flow into your metadata management. Oracle ships with DRM a basic work-flow development kit, using which the developers are expected to write Java code to build any meaningful work-flow. …

Setting up DRM Sample application provided by Oracle

I get emails from many a people interested in either learning Oracle Data Relationship Management, or practice with a sample application. Unfortunately, there is no “sample” DRM application that ships with the product, like it does with other Hyperion products like Essbase, and Hyperion Planning.  This has been a considerable …