Skip to Main Content
Return to Navigation

Extract, Transform, and Load (ETL) in EPM

PeopleSoft has an original equipment manufacturer (OEM) agreement with IBM WebSphere to supply extract, transform, and load (ETL) technology that supports source data acquisition and data movement within EPM . The ETL tool, IBM WebSphere DataStage, is delivered with EPM.

PeopleSoft uses IBM WebSphere DataStage to deliver prepackaged ETL jobs that extract information contained in PeopleSoft source systems, load it into the Operational Warehouse - Staging (OWS), and migrate that data to the Operational Warehouse - Enriched (OWE) and the Multidimensional Warehouse (MDW). But ETL jobs do more than migrate data; they also identify data for extraction and ensure the consistency and validity of your data. Because the ETL jobs are so versatile, separate tools and engines that extract, stage, and move data are not necessary.

Image: ETL process in EPM

The following graphic illustrates the various components comprising the EPM architecture and how data flows from source systems to the Operational and Multidimensional warehouses via the ETL process.

 ETL process in EPM

As depicted in the diagram, source transaction data is extracted into OWS tables and migrated across warehouse layers using the aforementioned ETL jobs. Also, source data is sometimes extracted directly into the MDW.

You can use IBM WebSphere DataStage to build custom jobs for mapping your data into EPM . However, PeopleSoft does not support custom jobs.

Detailed information regarding the ETL process can be found in the Understanding ETL in EPM topic.