By Eldred Smikle
November 15th, 2010
In June 2009, the buzz in the financial services industry was about the new module in the Hyperion Workspace called Enterprise Resource Planning Integrator (or ERPi). ERPi is a component of FDM that allows users to integrate metadata and data from an Enterprise Resource Planning (ERP) source system into an Enterprise Performance Management (EPM) target application. It’s used in conjunction with ODI and supports drill-through, from EPM applications, to the supported source systems.
The new features, of ERPi, already seem to be in high demand. The drill through capability from EPM applications to ERP systems, such PeopleSoft and Oracle E-Business Suite, is very compelling. Once ERPi is up and running, financial analysts can easily chart the path for metadata and data all the way from the target system back to the source of the transaction. Streamlining a cumbersome process and freeing up time for analysts to do more in-depth analysis.
The one caveat to the new ERPi release is it is only compatible with an Oracle database. This version doesn’t support Oracle RAC, Microsoft SQL Server, or IBM DB2. Now that ERPi has been released, we have realized that the current version is only compatible with an Oracle database. This support makes the ERPi functionality available only to users whose applications are running on Oracle. However, the next release of ERPi is supposed to encompass a wider range of Relation Database Management Systems. The promised release date was Q4 2010, but it has now shifted out to Q1 2011. For everyone not running an Oracle Instance, stay tuned. You will definitely want to take advantage of ERPi as soon as it’s available.