Select Page

Bringing DRM and PeopleSoft Together

Todd Rebner | | October 9, 2017

EPM, PeopleSoft, DRM

Datavail’s DRM PeopleSoft Adapter provides integration between Oracle Hyperion Data Relationship Management (DRM) and PeopleSoft Financials for Chart of Accounts and Trees. It helps streamline business user experience by providing more flexibility and better performance. This enables users to enjoy seamless integration in maintaining PeopleSoft Trees and managing chart-field creation.

 Challenges of Integrating DRM and PeopleSoft

  • Loss of time and money due to manual processes
  • Human errors arising from manual integration
  • Management of PeopleSoft Trees in DRM using Batch files and flash files
  • Custom Java APIs that are difficult to use and are not upgradeable

Datavail’s Oracle DRM to PeopleSoft Adapter

Datavail’s DRM PeopleSoft Adapter is a hierarchy management tool that helps manage operational and analytical master data, master data and analytical metadata, and data quality and integrity. The integration of Oracle DRM and PeopleSoft Financials, through the use of Datavail’s Adapter, allows these two applications to communicate and update using standard-based, real-time connectivity and powerful integration technologies. In turn, organizations are able to synchronize master data across Enterprise Performance Management applications such as transaction systems, BI platforms, and financial and analytic applications.

Product Features

  • Service Oriented Architecture (SOA), based on out-of-the-box functionality for integrating Chart-of-Accounts (COA) for PeopleSoft
  • Ability to build templates for configuring COA and Trees for PeopleSoft
  • Ability to promote hierarchies automatically from DRM into PeopleSoft
  • Unique web-based user interface
  • Scalable integration framework which can be extended to HR and other modules

 Product Benefits

  1. Solves problems with PeopleSoft Trees and allows direct and real-time access in DRM
  2. Dramatically improves and enhances referential integrity
  3. Allows data to be populated automatically through your systems, so the administrators have less to do in order to patch and maintain it
  4. Lets DRM act as a source for Chart of Accounts and PeopleSoft Trees by allowing it to:
    • Publish COA updates from DRM to PeopleSoft
    • Maintain and publish PeopleSoft trees from DRM
    • Lower the costs of implementation and long-term support
  1.       Removes the need to build custom processes for custom integration through:
    • The use of application templates for loading the properties, exports, validations, and queries
    • The use of a web-based user interface to maintain DRM and PeopleSoft configuration
    • Visibility of the changes published to PeopleSoft through DRM reports
    • The use of adaptor scheduler to publish the changes at required intervals

Leverage Datavail’s extensive experience with DRM across diverse industries and geographies. To learn more, check out some of our additional materials on DRM including our white paper, Stop the Manual Madness with Datavail’s DRM PeopleSoft Adapter.

As an Oracle Platinum Partner with 17 specializations, our EPM know-how and tight integration across consulting, development, support, and education puts our entire team behind your success. Contact us today to start solving your DRM and PeopleSoft integration challenges.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018
code

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database

Megan Elphingstone | February 2, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS