Select Page

Bringing DRM and PeopleSoft Together

Author: Todd Rebner | | October 9, 2017

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.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

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


Work for Us

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