Price Volume Mix (PVM) Analysis using Enterprise Performance Management (EPM) Planning Cloud

Watch the Customer Connect recording presented by Rajesh Pachiyappan and Vamshi Krishna. A copy of the presentation can be downloaded from this link, too.

This session covered the setup required for connecting Cloud EPM to Oracle Autonomous Database, using the ADW service in an Oracle Cloud Infrastructure (OCI) instance and setting up the Data Integration in a step-by-step flow.

  1. Setup required for connecting to the Oracle Autonomous Database
  2. Configuring EPM Integration Agent
  3. Preparing the Autonomous DB environment in OCI Instance
  4. Loading Data from Autonomous Database
  5. Writing back Data from Autonomous Database

Introduction about Oracle Autonomous Database

  • Oracle Autonomous Database is a comprehensive cloud experience with fully automated data  warehousing and transaction processing workloads optimized on high-end Oracle hardware systems
  • The Oracle Autonomous Database provides an easy-to-use, fully autonomous database that scales  elastically and delivers fast query performance
  • Oracle Autonomous Database does not require database administration
  • Oracle Autonomous Database handles provisioning the database, backing up the database, patching
  • and upgrading the database, and growing or shrinking the database
  • Oracle Autonomous Data Warehouse (ADW) is tailored to Data Warehousing, Data Marts, Data  Lakes..
  • Oracle Autonomous Transaction Processing (ATP) is tailored to On-Line Transaction Processing,  Batch, reporting, IoT, application development.

Helpful References: